Azure Fabric & Databricks Data Engineer: Lakehouse

Collectiv; Chicago (IL); Remote; USD 110,000 - 170,000; Full time

Job summary

Collectiv is hiring a Data Engineer to design and implement modern data platforms leveraging Microsoft Fabric and Databricks, with emphasis on lakehouse architecture and analytics engineering.

You will partner with client stakeholders and Collectiv consultants to deliver scalable data solutions for reporting, analytics, and self-service BI, while following best practices in data engineering and CI/CD.

Qualifications

• Bachelor's degree from an accredited university.
• 4+ years of experience in data engineering, analytics engineering, or data platform consulting.
• Hands-on experience with Microsoft Fabric and/or Databricks in production environments (experience with both strongly preferred).
• Strong SQL skills, including performance tuning and optimization.
• Experience designing data models for analytics (star schemas, semantic models, lakehouse patterns).
• Experience working in cloud data platforms (Azure preferred).
• Ability to work independently in a client-facing consulting role.

Responsibilities

• Design and implement modern data platforms leveraging Microsoft Fabric (OneLake, Lakehouse, Data Factory, Power BI) and Databricks (Spark, Delta Lake, SQL Warehouses).
• Build and optimize data ingestion, transformation, and orchestration pipelines using ELT/ETL best practices.
• Develop scalable lakehouse architectures that support analytics, reporting, and downstream data products.
• Translate business and analytical requirements into technical designs and data models.
• Develop and maintain semantic models that enable performant reporting and self-service analytics.
• Partner with analytics and business teams to deliver trusted datasets and dashboards (Power BI or equivalent).
• Ensure data quality, reliability, and usability across the analytics platform.
• Write, optimize, and tune SQL and Spark-based transformations for large-scale analytical workloads.
• Apply version control, CI/CD concepts, and code review standards to data engineering workflows.
• Ensure solutions meet quality criteria related to performance, scalability, and maintainability.
• Work directly with client stakeholders to gather requirements, communicate technical concepts, and manage expectations.
• Collaborate with project managers, architects, and fellow consultants to align technical delivery with project goals.
• Contribute to internal documentation, reusable patterns, and knowledge sharing across Collectiv.

Skills

Data engineering

Analytics engineering

Data platform consulting

Microsoft Fabric

Databricks

SQL

Lakehouse patterns

Azure cloud

Education

Bachelor's degree

Tools

Power BI

Azure Data Factory

Delta Lake

Job description

Collectiv is hiring a Data Engineer to design and implement modern data platforms leveraging Microsoft Fabric and Databricks, with emphasis on lakehouse architecture and analytics engineering.

You will partner with client stakeholders and Collectiv consultants to deliver scalable data solutions for reporting, analytics, and self-service BI, while following best practices in data engineering and CI/CD.