Data Warehouse and ETL Developer

At Home Group•Coppell, TX

18h•Hybrid

About The Position

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.

Requirements

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.

Nice To Haves

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.

Responsibilities

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.