Data Engineer (Azure, Fabric, Databricks)

Collectiv • Chicago, IL

1d • Remote

About The Position

The Data Engineer designs, implements, and supports modern data platforms using Microsoft Fabric and Databricks, with an emphasis on lakehouse architecture, analytics engineering, and semantic modeling. This client-facing consulting role translates business requirements into scalable technical solutions and applies data engineering best practices. The engineer works with client stakeholders, Collectiv consultants, and cross-functional teams to deliver platforms supporting reporting, advanced analytics, and self-service BI.

The role includes building data ingestion, transformation, and orchestration pipelines; developing lakehouse architectures and analytics models; enabling performant reporting and self-service analytics; and ensuring data quality, reliability, and usability. The engineer also contributes to engineering standards, documentation, reusable patterns, and knowledge sharing.

Collectiv describes itself as a boutique consulting and strategy firm specializing in Analytics, Planning, and AI with Power BI and the Microsoft Data Stack. The position is fully remote, with quarterly in-person team experiences. The company offers a clear growth trajectory, professional development opportunities, and a benefits package.

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 experience with Microsoft Fabric and/or Databricks in production environments.
• 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 with both is strongly preferred.
• 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; and Databricks certifications.

Responsibilities

• Design and implement modern data platforms using Microsoft Fabric, including OneLake, Lakehouse, Data Factory, and Power BI, and Databricks, 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 that support 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.
• Work with client stakeholders to gather requirements, explain technical concepts, and manage expectations.
• Collaborate with project managers, architects, and 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.
• Quarterly in-person team experiences.

What This Job Offers

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