Data Warehouse and ETL Developer

At Home Group Inc.; Coppell (TX); Hybrid; USD 85,000 - 120,000; Full time

Job summary

At Home Group Inc. is seeking a mid-level Data Warehouse & ETL Developer to design, develop, maintain, and support enterprise data warehouse solutions using Microsoft SQL Server and SSIS. The role focuses on transforming data from multiple systems into reliable models for reporting and analytics.

You will partner with technical teams and business stakeholders to deliver accurate, scalable data solutions, ensuring quality and maintainability across pipelines and data models.

Qualifications

• Bachelor's degree in CS/IS or related field; equivalent experience considered.
• 3–5 years of hands-on data warehouse and ETL/ELT development.
• Strong T-SQL, including complex queries and performance tuning.
• Hands-on experience with SQL Server data warehouse solutions.
• Hands-on SSIS experience: development, deployment, scheduling, monitoring, error handling.
• Experience designing and supporting ETL workflows with logging and restartability.
• Strong understanding of data warehousing concepts and dimensional modeling.

Responsibilities

• Design, develop, and maintain ETL pipelines in SQL Server data warehouse environments.
• Translate requirements into source-to-target mappings, transformation rules, and designs.
• Write and optimize complex T-SQL, stored procedures, and transformations for data extraction and validation.
• Develop, deploy, schedule, monitor, and support SSIS packages and workflows.
• Develop and maintain dimensional models including fact and dimension tables.
• Create and execute unit tests, data reconciliations, and validation routines.
• Monitor production SSIS packages and data pipelines; troubleshoot failures and issues.
• Optimize SQL queries, stored procedures, SSIS, and data-loading performance.
• Follow source-control, code-review, deployment, and change-management standards.
• Document data flows, designs, transformation logic, dependencies, and support procedures.
• Collaborate with data architects, analysts, and business stakeholders.

Skills

T-SQL

SSIS

ETL/ELT design

Data modeling

SQL Server

Data quality

Problem-solving

Collaboration

Education

Bachelor's degree in Computer Science or Information Systems

Equivalent practical experience

Tools

SQL Server

SSIS

Snowflake

Power BI

SSRS

Azure

Job description

Job Description

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

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.