Data Engineer (Azure, Fabric, Databricks)

Collectiv • Chicago, IL

3d • Remote

About The Position

The Data Engineer designs, implements, and supports modern data platforms using Microsoft Fabric and Databricks, emphasizing lakehouse architecture, analytics engineering, and semantic modeling. This client-facing role translates business requirements into scalable technical solutions while following data engineering best practices.

The engineer collaborates with client stakeholders, Collectiv consultants, and cross-functional teams to deliver platforms for reporting, advanced analytics, and self-service BI. The role also involves developing trusted analytics-ready data and models, applying engineering standards, and contributing to reusable patterns and internal knowledge sharing.

Requirements

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

Nice To Haves

• Experience with both Microsoft Fabric and Databricks.
• Experience migrating or modernizing data platforms, such as moving from a legacy data warehouse to a lakehouse.
• Familiarity with Power BI dataset modeling and performance optimization.
• Experience integrating data platforms with downstream applications or APIs.
• Consulting experience with multiple clients or industries.
• Strong written and verbal communication skills.
• Relevant Azure certifications, such as Azure Solutions Architect or Azure Data Engineer; Fabric certifications such as DP-600 or DP-700; or Databricks certifications.

Responsibilities

• Design and implement modern data platforms using Microsoft Fabric components, including OneLake, Lakehouse, Data Factory, and Power BI, and Databricks technologies, including Spark, Delta Lake, and SQL Warehouses.
• Build and optimize data ingestion, transformation, and orchestration pipelines using ELT/ETL best practices.
• Develop scalable lakehouse architectures for analytics, reporting, and downstream data products.
• Translate business and analytical requirements into technical designs and data models.
• Develop and maintain semantic models for performant reporting and self-service analytics.
• Partner with analytics and business teams to deliver trusted datasets and dashboards using Power BI or equivalent tools.
• 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 for performance, scalability, and maintainability.
• Gather requirements from client stakeholders, 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.

Benefits

• Unlimited time off.
• 100% covered health insurance, including medical, dental, and vision plans for the employee and family.
• 401(k) with a 4% match.
• Educational assistance.
• Tech stipend.
• Discounts on various goods and services.
• Professional development opportunities.
• Fully remote work environment with quarterly in-person team experiences.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level