Data Warehouse Data Engineer

We are seeking a Data Warehouse Data Engineer to design, build, and optimize enterprise analytics solutions. This role focuses on developing ETL/ELT pipelines, Lakehouse/Warehouse models, and curated datasets to support reporting and data-driven decision-making.

• Design and maintain ETL/ELT pipelines using Microsoft Fabric, Spark, and SSIS.

• Build ingestion processes for files, APIs, SaaS platforms, and partner data.

• Implement Lakehouse medallion architecture (Bronze/Silver/Gold).

• Develop and optimize star schema models, dimensions, and fact tables.

• Implement incremental loads, SCD handling, and Delta Lake optimizations.

• Ensure data quality, validation, and governance standards.

• Apply security controls including Row-Level Security and access management.

• Collaborate with BI teams and stakeholders on requirements and KPIs.

• Monitor pipelines, troubleshoot issues, and support CI/CD deployments.

• Maintain technical documentation and data workflows.

• Bachelor's degree in Computer Science, IT, or related field

• 5+ years of data engineering or data warehouse experience

• Strong SQL (T-SQL) and performance tuning skills

• Hands-on with Microsoft Fabric, Delta Lake, and medallion architecture

• Experience with Python/PySpark for transformations

• REST API and file-based integrations

• Knowledge of dimensional modeling (Kimball)

• Experience with Git/Azure DevOps CI/CD

• 3+ years with SSIS/SSMS/SSDT

• Power BI semantic models

• Azure Data Factory, Synapse, or Databricks

• Data governance and lineage tools