> Markdown version of [/jobs/ext/3557245-date-engineer-datawarehouse-etl-elt](https://www.wearedevelopers.com/jobs/ext/3557245-date-engineer-datawarehouse-etl-elt). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Date Engineer Datawarehouse ETL ELT - **Company:** Intersources Inc. - **Location:** Eatontown, NJ, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Sql Server Data Tools (SSDT), Microsoft Excel, Application Programming Interfaces (APIs), Automation of Tests, Microsoft Azure, Business Intelligence Development, Software as a Service, Profiling, Information Systems, Continuous Integration, Data Dictionary, Information Engineering, Data Infrastructure, Extract Transform Load (ETL), Data Mart, Data Security, Data Warehousing, Database Queries, Software Debugging, Dimensional Modeling, Python (Programming Language), Metadata, Meta-Data Management, Performance Tuning, Power BI, SQL Databases, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Data Streaming, Systems Integration, Transact-SQL, Workflow Management Systems, Parquet, File Transfer Protocol (FTP), Azure Data Factory, Apache Spark, Git, Microsoft Fabric, Data Lakes, Pyspark, Information Technology, Collibra, Star Schema, Data Management, SQL Server Management Studio (SSMS), Restful APIs, Software Version Control, Data Pipelines, Databricks - **Published:** October 2, 2026 - **Apply:** https://www.careerjet.com/job/usc12e7a7c2a1a3cd9b5c6ac597940d930/eaa ## About the Role * Bachelor's degree in Computer Science, Information Systems, Engineering, or related field. * 9+ years of experience in data engineering, BI development, or data warehouse development. * Strong SQL skills (T-SQL) for complex transforms, joins, window functions, and performance tuning. * Hands-on experience with Microsoft Fabric (Lakehouse, Warehouse, OneLake, Pipelines, Dataflows Gen2, Notebooks). * Experience with Delta Lake, parquet, and medallion architectures. * Proficiency with Python or PySpark for ingestion and transformation. * Experience integrating REST APIs, SFTP feeds, SaaS connectors, and partner files. * Strong understanding of dimensional modeling (Kimball), conformed dimensions, and data mart design. * Familiarity with CI/CD workflows (Azure DevOps, Git). * Excellent troubleshooting, debugging, and performance optimization abilities. * 5 years of experience with SSMS / SSDT / SSIS / SSAS / SSRS., * Experience with Power BI (understanding semantic models and performance considerations). * Exposure to Azure Data Factory, Synapse, or Databricks. * Experience with workflow orchestration and metadata-driven frameworks. * Knowledge of data governance tools (Purview), data security best practices, and lineage management. ## Description Must be strong in Data Warehouse development/ETL/ELT and be able to create a DW from the bottom up. Data Engineering & Pipeline Development * Design, build, and maintain ETL/ELT pipelines using Microsoft Fabric (Pipelines, Dataflows Gen2, Notebooks, Spark) and legacy SSIS. * Develop ingestion frameworks for flat files (CSV/Excel), APIs, SaaS platforms, cloud feeds, and partner data. * Implement medallion architecture (Bronze, Silver, Gold) using Lakehouse (Delta Lake), Warehouse, and OneLake. * Automate data transformations using SQL, PySpark, and Fabric Notebooks. Data Modeling & Optimization * Build and optimize star schema models, conformed dimensions, and fact tables for BI consumption. * Implement incremental loads, SCD handling (Type 1/2), partitioning, Z-ordering, compaction, and other Delta Lake optimization techniques. * Collaborate with BI Analysts to translate business requirements into performant data models. The DW Data Engineer will play a critical role in building, enhancing, and optimizing client's analytics platform. This individual will design and develop ETL/ELT pipelines, Lakehouse/Warehouse models, and curated datasets that power reporting and analytics. This position works closely with BI Analysts, BI Developers, Architects, and business stakeholders to ensure that high-quality, scalable, and governed data is made available for decision-making Data Engineering & Pipeline Development * Design, build, and maintain ETL/ELT pipelines using Microsoft Fabric (Pipelines, Dataflows Gen2, Notebooks, Spark) and legacy SSIS. * Develop ingestion frameworks for flat files (CSV/Excel), APIs, SaaS platforms, cloud feeds, and partner data. * Implement medallion architecture (Bronze, Silver, Gold) using Lakehouse (Delta Lake), Warehouse, and OneLake. * Automate data transformations using SQL, PySpark, and Fabric Notebooks. Data Modeling & Optimization * Build and optimize star schema models, conformed dimensions, and fact tables for BI consumption. * Implement incremental loads, SCD handling (Type 1/2), partitioning, Z-ordering, compaction, and other Delta Lake optimization techniques. * Collaborate with BI Analysts to translate business requirements into performant data models. Data Quality, Governance & Security * Ensure end-to-end data quality through validation, reconciliations, profiling, and automated tests. * Apply governance principles using Purview for lineage, classification, and data cataloging. * Enforce Row-Level Security (RLS), object-level security, and access controls across Fabric datasets. Cross-Team Collaboration * Partner with BI Analysts and Business Stakeholders to understand KPIs, metrics, and reporting requirements. * Work with Architects to establish data platform standards, naming conventions, folder structures, and version control patterns. * Provide technical expertise during UAT, troubleshooting, and performance tuning. Operational Excellence * Monitor pipeline performance and proactively resolve pipeline failures. * Implement CI/CD practices using Azure DevOps / Git integration for code and artifact promotion across Dev, Stage, and Prod. * Contribute to documentation of data flows, data dictionaries, technical specifications, and workflows. ## Related Videos - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Parquet, Delta, Iceberg & Ducklake - An introduction for developers](https://www.wearedevelopers.com/videos/100075-parquet-delta-iceberg-ducklake-an-introduction-for-developers) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)