Remote Data Engineering Jobs in Chicago, IL (NOW HIRING)

Role Overview

The Data Engineer is responsible for designing, implementing, and supporting modern data platforms using Microsoft Fabric and Databricks, with a strong emphasis on lakehouse architecture, analytics engineering, and semantic modeling. This role is client-facing and requires translating business requirements into scalable technical solutions while adhering to data engineering best practices.

You will collaborate with client stakeholders, Collectiv consultants, and cross-functional teams to deliver data platforms that support reporting, advanced analytics, and self-service BI.

Key Responsibilities

Client Delivery & Solution Design

• 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

Analytics & BI Enablement

• 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

Engineering Best Practices

• 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

Consulting & Collaboration

• 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

Required 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

Preferred Qualifications

• Experience migrating or modernizing data platforms (e.g., legacy DW to 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 (e.g., Azure Solutions Architect, Azure Data Engineer), Fabric (DP-600, DP-700) certifications, and Databricks certifications are highly desirable

What Success Looks Like in This Role

• Clients trust you as a technical advisor for their data platform decisions
• Delivered solutions are scalable, well-documented, and aligned to best practices
• Business users are enabled through reliable data models and analytics-ready datasets
• You actively contribute to Collectiv's data platform standards and consulting excellence

Join Collectiv for a rewarding career in a fully remote work environment with quarterly in person team experiences and a competitive compensation. We provide a clear growth trajectory with professional development opportunities and a top-shelf benefits package. Enjoy unlimited time off and 100% covered health insurance, encompassing medical, dental, and vision plans for you and your family. Our comprehensive offerings, from a competitive 401(k) with a 4% match to educational assistance, tech stipend, and discounts on various goods and services, demonstrate our commitment to your well-being and success. At Collectiv, your career thrives with a perfect blend of remote flexibility, growth potential, and unparalleled benefits prioritizing your financial, physical, and emotional well-being.

Collectiv is the leading boutique consulting and strategy firm specializing in Analytics, Planning and AI with Power BI and the Microsoft Data Stack.

Our mission at Collectiv is simple: We help enterprises make better decisions.

Our Core Values:

Growth Mindset - Bring solutions, not problems.

Excel with Humility - Be humbly brilliant.

Communicate Actively and Empathetically - Listen, ask, understand, help.

Work Hard, Play Hard - Results are proportional to effort.

Keep Calm and Carry On - Stay cool, calm and Collectiv.