Apply Now

Data Warehouse and ETL Developer

Coppell, TX, US • Posted 1 day ago • Updated 2 hours ago

Full Time

On-site

Fitment

Dice Job Match Score™

To see how well you match this job, please log in or create an account.

Once logged in, be sure to complete your profile to get the most accurate match score.

🔢 Crunching numbers...

Job Details

Skills

Business Systems
Decision-making
System Requirements
Data Extraction
Data Loading
Version Control
Code Review
Change Management
Data Flow
Dependability
Computer Science
Information Systems
Transact-SQL
Performance Tuning
Data Validation
Microsoft SSIS
Scheduling
Workflow
Stored Procedures
Dimensional Modeling
Extract
Transform
Load
ELT
Testing
Production Support
Root Cause Analysis
Analytical Skill
Conflict Resolution
Problem Solving
Communication
Collaboration
Retail
Sales
Inventory
Merchandising
Supply Chain Management
Snow Flake Schema
Data Warehouse
Reporting
Analytics
Microsoft Power BI
Microsoft SQL Server
Microsoft SSRS
Data Governance
Data Quality
Data Integration
Microsoft Azure
Cloud Computing
Migration

Business Systems
Decision-making
System Requirements
Data Extraction
Data Loading
Version Control
Code Review
Change Management
Data Flow
Dependability
Computer Science
Information Systems
Transact-SQL
Performance Tuning
Data Validation
Microsoft SSIS
Scheduling
Workflow
Stored Procedures
Dimensional Modeling
Extract
Transform
Load
ELT
Testing
Production Support
Root Cause Analysis
Analytical Skill
Conflict Resolution
Problem Solving
Communication
Collaboration
Retail
Sales
Inventory
Merchandising
Supply Chain Management
Snow Flake Schema
Data Warehouse
Reporting
Analytics
Microsoft Power BI
Microsoft SQL Server
Microsoft SSRS
Data Governance
Data Quality
Data Integration
Microsoft Azure
Cloud Computing
Migration

Summary

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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10124901
Position Id: 648eeb06c6724cd6bf21a765d0f7b9a5
Posted 1 day ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Senior Data Platform Engineer

Irving, Texas

•

Today

We are seeking a highly skilled and motivated Senior Data Platform Engineer, AVP (Python/PySpark, Microsoft SSIS, SQL Server, ETL & Database Development) to design, develop, enhance, and support robust, scalable, and high-performance data processing solutions. The ideal candidate will combine strong hands-on expertise in Python/PySpark, SQL Server, ETL/data pipelines, Microsoft SSIS, and large-scale data platforms, with experience troubleshooting production data applications, optimizing databas

Full-time

USD 107,120.00 - 160,680.00 per year

Data Analyst

Irving, Texas

•

Today

Job Title: Data Architect - CRA Data Architecture & Reporting (CDAR) Location: Irving TX Duration: Contract - 2+ months, with potential extension (end date TBD) Pay Range: $58.62/hr to $60.70/hr Job ID: 410610 About BCforward BCforward is a leading global IT consulting and workforce solutions firm providing services and support to Fortune 500 and government clients. Founded in 1998, BCforward has grown with our customers needs into a full-service business solutions provider. With delivery c

Easy Apply

Contract

$58.62 - $60.7 per hour

SQL Server Data Engineer

Hybrid in Dallas, Texas

•

4d ago

Job Title: SQL Server Data Engineer Location: Dallas, TX Job Overview We are hiring a Mid-Level Data Engineer to design and build OLTP (Online Transaction Processing) systems and pipelines. This role focuses on transactional system design, API-driven data flows, and building reliable, high-performance data services. The ideal candidate thinks in terms of system architecture, transactional integrity, and low-latency data handling rather than scheduled data warehouse loads. Key Responsibilities De

Easy Apply

Contract

Depends on Experience

Data Engineer (Only W2)

Hybrid in Westlake, Texas

•

3d ago

Job Title: Data Engineer Employment Type: W2 Contract Job DescriptionWe are looking for a skilled Data Engineer to design, build, and maintain scalable data pipelines and data platforms. The ideal candidate should have strong experience working with large datasets, cloud environments, ETL/ELT processes, and modern data engineering tools. Key ResponsibilitiesDesign and develop scalable ETL/ELT pipelinesBuild and maintain data ingestion, transformation, and integration workflowsWork with structure

Easy Apply

Contract

65 - 75

Search all similar jobs

More jobs at AtHome America in Coppell, TX