Data Engineer jobs

Data Warehouse and ETL Developer

At HomeCoppell, TXHybrid3+ years experiencePosted 1 month ago

Pay not listed

Looks real. 1 thing to check before you apply.

On At Home’s own careers site (Oracle Recruiting), checked open today.

  • To check: No pay range listedAsk for the pay range before you interview.
  • Checked: On the company's own careers siteOracle Recruiting board
  • Checked: Checked open todayOracle Recruiting board
  • Checked: No reposts foundOracle Recruiting board
  • Trust score 89 / 100 · Looks good
See all 5 checksShow fewer
How we check

What you’ll do

  • Design, develop, maintain, and support SQL Server data warehouse ETL pipelines and SSIS packages.
  • Translate business and source-system requirements into mappings, transformation rules, and technical designs.
  • Build dimensional models and reusable transformations for reporting and analytics.
  • Test and validate data, monitor production pipelines, troubleshoot failures, and optimize performance.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • 3 to 5 years of hands-on experience developing and supporting data warehouse and ETL/ELT solutions
  • Hands-on experience developing and supporting Microsoft SQL Server data warehouse solutions
  • Strong hands-on experience with SSIS package development, deployment, scheduling, monitoring, and error handling
  • Experience designing and supporting ETL workflows, dependencies, restartability, logging, and production support processes
  • Experience developing stored procedures and reusable data-transformation logic
  • Experience with testing, reconciliation, production support, and root-cause analysis for data pipelines
  • Experience in a retail environment or with retail data (preferred)
  • Experience with Snowflake, Snowpipe, or a comparable cloud data warehouse platform (preferred)
  • Experience supporting Power BI or SSRS (preferred)
  • Experience with data governance, data quality tools, or cloud-based data integration patterns (preferred)
  • Experience with Azure data services or other cloud data platforms and migration initiatives (preferred)

Education

  • Bachelor's degree in Computer Science, Information Systems, or a related field (preferred)

Skills

  • Strong T-SQL skills, including complex queries, stored procedures, performance tuning, data validation, and troubleshooting
  • Strong understanding of data warehousing concepts, dimensional modeling, and ETL/ELT best practices

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Full job description

From At Home’s careers site

WORK LOCATION DETAILS

Work Location: Home Office - Coppell, TX

Work Schedule: Hybrid

- Onsite: Tuesdays, Wednesdays, and Thursdays

- Work from Home: Mondays and Fridays

JOB SUMMARY

Show full descriptionShow less

The Data Warehouse & ETL Developer designs, develops, maintains, and supports enterprise data warehouse solutions and data integration processes, primarily using Microsoft SQL Server and SQL Server Integration Services (SSIS). This mid-level role transforms data from multiple business systems into reliable, well-structured data models that support reporting, analytics, and business decision-making. The developer partners with technical teams and business stakeholders to deliver accurate, scalable, and maintainable data solutions.

ESSENTIAL FUNCTIONS

- Design, develop, and maintain ETL pipelines that load and transform data in Microsoft SQL Server data warehouse environments.

- Translate business and source-system requirements into source-to-target mappings, transformation rules, and technical designs.

- Write and optimize complex T-SQL, stored procedures, and reusable transformations for data extraction, cleansing, integration, and validation.

- Develop, deploy, schedule, monitor, and support SQL Server Integration Services (SSIS) packages and workflows.

- Develop and maintain dimensional data models, including fact and dimension tables, to support reporting and analytics.

- Create and execute unit tests, data reconciliations, and validation routines to ensure data accuracy and completeness.

- Monitor production SSIS packages and data pipelines, troubleshoot failures and data issues, and perform root-cause analysis.

- Optimize SQL Server queries, stored procedures, SSIS packages, and data-loading performance.

- Follow source-control, code-review, deployment, and change-management standards.

- Document data flows, technical designs, transformation logic, dependencies, and operational support procedures.

- Collaborate with data architects, analysts, application teams, and business stakeholders to deliver and support dependable data solutions.

QUALIFICATIONS

- Bachelor's degree in Computer Science, Information Systems, or a related field preferred; equivalent practical experience will be considered.

- 3 to 5 years of hands-on experience developing and supporting data warehouse and ETL/ELT solutions.

- Strong T-SQL skills, including complex queries, stored procedures, performance tuning, data validation, and troubleshooting.

- Hands-on experience developing and supporting Microsoft SQL Server data warehouse solutions.

- Strong hands-on experience with SQL Server Integration Services (SSIS), including package development, deployment, scheduling, monitoring, and error handling.

- Experience designing and supporting ETL workflows, dependencies, restartability, logging, and production support processes.

- Experience developing stored procedures and reusable data-transformation logic.

- Strong understanding of data warehousing concepts, dimensional modeling, and ETL/ELT best practices.

- Experience with testing, reconciliation, production support, and root-cause analysis for data pipelines.

- Strong analytical, organizational, and problem-solving skills.

- Strong communication skills and the ability to collaborate effectively with both technical and business partners.

Preferred:

- Experience in a retail environment or with retail data such as sales, inventory, merchandising, customer, loyalty, or supply chain data.

- Experience with Snowflake, Snowpipe, or a comparable cloud data warehouse platform.

- Experience supporting reporting and analytics tools such as Power BI or SQL Server Reporting Services (SSRS).

- Experience with data governance, data quality tools, or cloud-based data integration patterns.

- Experience with Azure data services or other cloud data platforms and migration initiatives.

Something wrong with this job? Report it · This flag looks wrong

Similar jobs nearby

Data Engineer

Royal Electric · Dallas, TX

$93k–$119k/yrFull-time

StrongChecked open todayPosted 1 month ago

Principal Data Engineer

CG Infinity · Houston, TX +1 place

Full-time

StrongPay not listedChecked open todayPosted 21 days ago

Senior Data Engineer

Cetera Financial Group · Dallas, TX

StrongPay not listedChecked open todayPosted 1 month ago

See more like this