Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Warehouse and ETL Developer

At Home Stores LLC

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. At Home Stores LLC

Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the Data Warehouse and ETL Developer in Coppell, TX vacancy
  • $107.12k - $160.68k

     ...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,...  ...relational, dimensional, and data-warehouse modeling principles to build scalable... 
    Suggested
    Full time

    Citigroup

    Irving, TX
    4 days ago
  • $125.76k - $188.64k

     ...exceptionally skilled and motivated Lead Data Platform Engineer, to guide...  ...(VLDB) Management: Managing, developing, and optimizing solutions for...  ...environments.Data Loading & ETL Leadership: Overseeing and...  ...decisions for data warehouses, ensuring data integrity, scalability... 
    Suggested
    Full time

    Citigroup

    Irving, TX
    4 days ago
  • $58 per hour

    ETL Developer Experience level: Mid-senior Experience required: 7 Years Education level: Bachelors...  ...ETL Developer with experience in Oracle Data Integrator (ODI), OCI Data Integrator,...  ...we are migrating our IT portfolio data warehouse from on-prem (SQL Server, SSIS) to... 
    Suggested
    Hourly pay
    Contract work
    Visa sponsorship
    Relocation package

    ESR Healthcare

    Coppell, TX
    1 day ago
  • Data Integration and ETL Develop and maintain Extract, Transform, Load (ETL) processes to integrate data from various sources into a unified data warehouse. Data Modeling and Database Management by Designing and implementing data models to support business reporting and... 
    Suggested

    Invences, Inc.

    Carrollton, TX
    1 day ago
  •  ...in class, hands -on Snowflake Data & Analytics Engineer with deep...  ...including compute optimisation, warehouse sizing, and cost management.• Design and implement ELT/ETL frameworks using Snowflake SQL,...  ...Cortex Search, and Cortex Analyst.• Develop production-grade Retrieval-... 
    Suggested
    Work experience placement
    Live in
    Work at office
    Local area
    3 days per week

    Accenture

    Irving, TX
    3 days ago
  • $70.35k - $205.8k

     ...in class, hands -on Snowflake Data & Analytics Engineer with deep...  ...including compute optimisation, warehouse sizing, and cost management. • Design and implement ELT/ETL frameworks using Snowflake SQL,...  ...Search, and Cortex Analyst. • Develop production-grade Retrieval-Augmented... 
    Work experience placement
    Live in
    Work at office
    Local area
    3 days per week

    Accenture

    Irving, TX
    1 day ago
  • $156.16k - $234.24k

    About the Role We are seeking a Data Platform Engineer with deep, specialized expertise...  ...the enterprise. Data Normalization: Develop robust normalization and enrichment logic...  ...maintain the storage backbone (data lakes, warehouses, streaming stores) that serves as the durable... 
    Full time

    Citigroup Inc

    Irving, TX
    1 day ago
  • $38k

    Senior Data Platform Engineer Photon is looking for a Senior Data Platform Engineer to support...  ..., AI/ML, and operational use cases. Develop pipelines to ingest and process customer,...  ...transformation. Strong experience building ETL/ELT and streaming data pipelines. Experience... 
    Full time
    For contractors
    Shift work

    Photon

    Irving, TX
    1 day ago
  •  ...Bachelor's degree in Computer Science, Information Technology, or related field. Proven experience as an ETL Developer or similar role, with a strong understanding of data concepts and methodologies. Proficiency in SQL and experience working with relational databases (e... 
    Full time
    Local area
    Flexible hours

    Radiant Digital

    Irving, TX
    4 days ago
  •  ...Jconnect INC . Below is the requirement with my client. Please let me know if you are available for this role. Title: Sr. Data Engineer ( ETL Developer) Location: Irving, TX Duration: Fulltime JOB DESCRIPTION : Must Have Technical/Functional Skills • SQL Server, Azure... 
    Full time
    Immediate start
    Relocation

    3B Staffing LLC

    Irving, TX
    1 day ago
  • Role - Senior AI Customer Data Platform Engineer with Banking & Financial Domain Location...  ...personalization, and customer 360 solutions. Develop AI chatbots, virtual assistants, and...  ...Customer Data Modeling Data Pipelines & ETL SQL REST APIs Data Governance Development... 
    Contract work

    AceStack LLC

    Irving, TX
    1 day ago
  • Role : GCP Data Engineer with AI/ML Integration & MLOps Location : Irving, Texas 75039...  ...foundational data lake and BigLake to unify data warehouses and data lakes. Implement fine-grained...  .... Data Pipeline Engineering: Design, develop, and orchestrate batch and streaming data... 

    United IT Solutions

    Irving, TX
    1 day ago
  •  ...future of convenience.Job SummaryBuild, test, and support reliable data pipelines, datasets, and data products with guidance from senior...  ...data tools.· Experience building or supporting data pipelines, ETL/ELT jobs, datasets, or data products.· Basic understanding of data... 
    Hourly pay
    Work experience placement

    7 eleven

    Irving, TX
    7 hours ago
  • $76.73k - $150.8k

     ...are looking for a Senior BI / ETL Test Engineer with strong experience...  ..., SAP HANA, ETL testing, and data validation. The candidate will...  ...to-end testing of BI and data warehouse solutions, including...  ...professional who can independently develop test strategies, recommend appropriate... 
    Full time
    Local area

    Capgemini Service SAS

    Irving, TX
    6 days ago
  • $76.73k - $150.8k

     ...Summary We are seeking a BI ETL Test Engineer, you take care...  ...includes validation of the business data flow , ETL components, data...  .... Your Role Design, develop, and execute comprehensive test...  ...test plans for BI, ETL, and data warehouse solutions, ensuring high data... 
    Full time
    Local area

    Capgemini Service SAS

    Irving, TX
    14 days ago
  •  ...HBase2+ years of experience with NOSQL database - HBase1+ years of working knowledge in Kafka/Storm data pipelines6+ years of experience in working in a Data warehouse environment4+ years of Linux skills2+ years in code documentation and API/Framework documentation/process... 

    LanceSoft

    Irving, TX
    3 days ago
  •  ...scalable, reusable Cloud-based data management and reporting platform components. Designs and develops data models, reports, and...  ...building financial and Medicare data warehouse applications using data...  ...Extract, Transform, and Load (ETL) processing. Or, alternatively... 
    Full time

    Fidelity Investments

    Westlake, TX
    4 days ago
  •  ...Irving, TX that is seeking a Data Engineer. Responsibilities:...  ..., analysis-ready datasets * Develop data transformations across structured...  ...* Experience developing ETL/ELT pipelines within cloud...  ...relational databases, data lakes, data warehouses, and incremental processing... 
    Hourly pay
    Contract work

    Kforce Technology Staffing

    Irving, TX
    4 days ago
  •  ...TX that is seeking a Mid Level Data Engineer. Responsibilities:...  ..., and reporting needs * Develop and maintain data models, data...  ...technologies, and data lake or data warehouse environments * Experience...  ..., developing, and maintaining ETL/ELT data pipelines and workflow... 
    Hourly pay
    Contract work

    Kforce Technology Staffing

    Irving, TX
    1 day ago
  •  ...Thurs in Irving, TX Our client seeks a Data Engineer to join the MarTech team. The...  ...experience with Databricks or Spark, data lake or warehouse design, and pipeline orchestration. ~...  .... ~ Experience with reverse-ETL or activation and identity resolution such... 
    Hourly pay
    Local area

    Eliassen Group

    Irving, TX
    3 days ago
  •  ...site Every Other Week in Westlake, TX Our client seeks an AI Data Engineer Visualization Engineer to build and optimize data pipelines and deliver effective analytics. The role will develop ETL processes, design scalable data models, and create Power BI... 
    Hourly pay
    Local area

    Eliassen Group

    Westlake, TX
    3 days ago
  •  ...organization is seeking a Principal Engineer - Data Engineering to drive the architecture,...  ...-native data platforms, data lakes, data warehouses, and lakehouse architectures....  ...engineering languages. ~5+ years of expertise in ETL/ELT architecture, data integration... 
    Full time
    Work experience placement

    Wells Fargo

    Irving, TX
    2 days ago
  • ## Senior Manager, Data EngineeringApply: SSC Irving TX: Full time...  ..., and modernization of legacy ETL into a lakehouse architecture....  ..., code quality, and developer experience standards.· Partner...  ...ELT/ETL) in lakehouse or data warehouse environments.· 5+ years working... 
    Full time

    SuperMom

    Irving, TX
    1 day ago
  • $52 - $57 per hour

     ...Irving, TX that is seeking a Data Engineer.Responsibilities:* Build...  ..., analysis-ready datasets* Develop data transformations across structured...  ...* Experience developing ETL/ELT pipelines within cloud...  ...relational databases, data lakes, data warehouses, and incremental processing*... 

    KForce

    Irving, TX
    3 days ago
  • $46 - $51 per hour

     ...TX that is seeking a Mid Level Data Engineer.Responsibilities:*...  ...analytics, and reporting needs* Develop and maintain data models, data...  ...technologies, and data lake or data warehouse environments* Experience...  ..., developing, and maintaining ETL/ELT data pipelines and workflow... 

    KForce

    Irving, TX
    7 hours ago
  •  ...interviewDescription: Minimum 7 years of experience in Data Management, with deep expertise in...  ...-on experience with Snowflake Cloud Data Warehouse, including advanced features and...  ...data solutions using core AWS services. develop complex SQL and PL/SQL procedures to support... 

    Mindlance

    Coppell, TX
    4 days ago
  •  ...models to store and retrieve company data Examine and identify database...  ...storage and management solutions Develop data models for applications, metadata...  ...by conducting regular tests and troubleshooting Manage ETL processes that support existing data warehouse United IT

    United IT

    Irving, TX
    1 day ago
  • $1,000 per month

     ...solutions and recognizing great performance.Primary FunctionThe Sr Data Analyst is responsible for leading projects designed to improve...  ...business processes and reporting.Retrieve data from the data warehouse structure.Perform query optimization and performance tuning.... 
    Full time
    Work experience placement

    NewRez

    Coppell, TX
    2 days ago
  •  ...We are looking for an experienced AI and Synthetic Data Engineer to develop synthetic-data pipelines and AI experiments for computer vision, perception, and Physical AI applications using simulated industrial environments and sensor data. Key Responsibilities Develop... 
    Full time

    2T Consulting

    Irving, TX
    23 days ago
  •  ...Job Description Job Description Analyst - Data Grapevine TX Position Type Full Time Job Shift Day Education Level...  ...Must be able to tolerate moderate to high noise levels in a warehouse environment. Office and outside environmental conditions are found... 
    Full time
    Summer work
    Work at office
    Flexible hours
    Shift work

    SMS InfoComm Corporation

    Grapevine, TX
    more than 2 months ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Warehouse and ETL Developer. Be the first to apply!