Hybrid Data Warehouse & 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

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.