Pay
$127K–$189K is typical
The middle half of what similar US postings state. This one doesn’t list pay.
From 2,448 postings in the last year. Stated ranges, not salaries paid.
Reads like a Data Engineer role: pipelines and data infrastructure.
Chicago, IL
Live, first seen by us 34 days agoWork setup in the employer’s posting: RemoteFrom the employer’s posting
Employment type in the employer’s posting: Full-TimeFrom the employer’s posting
The Data & Analytics Engineer is Collectiv’s most versatile technical consultant, combining deep data engineering expertise with advanced Power BI and analytics delivery capabilities.
You design and implement modern lakehouse architectures on Microsoft Fabric and Databricks, build performant ELT/ETL pipelines, develop rich semantic models, and deliver complex Power BI reports, all while acting as a trusted technical advisor to enterprise clients.
Design and implement data platforms on Microsoft Fabric and Databricks
Build and optimize ELT/ETL ingestion and transformation pipelines
Design complex Power BI semantic models and enterprise-grade data models
Develop, optimize, and peer-review DAX formulas
Create interactive Power BI reports and dashboards for client decisions
The Data & Analytics Engineer is Collectiv’s most versatile technical consultant, combining deep data engineering expertise with advanced Power BI and analytics delivery capabilities. This role closes the gap between backend data platform work and front-end analytics, enabling a single consultant to take a client from raw data ingestion through to polished, insight-ready dashboards.
You design and implement modern lakehouse architectures on Microsoft Fabric and Databricks, build performant ELT/ETL pipelines, develop rich semantic models, and deliver complex Power BI reports, all while acting as a trusted technical advisor to enterprise clients. You thrive on translating ambiguous business requirements into scalable, well-documented technical solutions and are equally comfortable deep in Spark transformations or fine-tuning DAX formulas.
Design and implement modern data platforms leveraging Microsoft Fabric (OneLake, Lakehouse, Data Factory) and Databricks (Spark, Delta Lake, SQL Warehouses)
Build and optimize data ingestion, transformation, and orchestration pipelines using ELT/ETL best practices
Design and implement complex data models utilizing Power BI, including enterprise-grade semantic layer development
Develop, optimize, and peer-review DAX formulas for accuracy and performance at scale
Create visually compelling, interactive reports and dashboards that drive measurable client decisions
Bachelor’s degree from an accredited university
Strong SQL skills, including performance tuning and analytical query design
5+ years of combined experience in data engineering, analytics engineering, and/or BI consulting
Experience designing analytics data models (star schemas, semantic models, lakehouse patterns)
Demonstrated ability to integrate data from diverse sources into both data platforms and BI tools
Experience migrating or modernizing legacy data warehouses to lakehouse architectures
Experience integrating data platforms with downstream applications or external APIs
Required Qualifications - Bachelor’s degree from an accredited university - 5+ years of combined experience in data engineering, analytics engineering, and/or BI consulting
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
$127K–$189K is typical
The middle half of what similar US postings state. This one doesn’t list pay.
From 2,448 postings in the last year. Stated ranges, not salaries paid.
Day 34
Similar jobs usually come down between day 6 and day 56.
From 14,771 similar postings that came down. Coming down is not always a hire.
3 open jobs
Open jobs by the week we first saw them, last 12 weeks.
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
Data Platform & Lakehouse Engineering - Design and implement modern data platforms leveraging Microsoft Fabric (OneLake, Lakehouse, Data Factory) and Databricks (Spark, Delta Lake, SQL Warehouses) - Build and optimize data ingestion, transformation, and orchestration pipelines using ELT/ETL best practices
- Translate business and analytical requirements into technical data models (star schemas, semantic models, lakehouse patterns) - 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 all data engineering workflows
- Develop, optimize, and peer-review DAX formulas for accuracy and performance at scale - Integrate data from diverse sources into Power BI, leveraging SQL skills for efficient extraction and transformation - Ensure data quality, reliability, and usability across the analytics platform
- Power BI dataset modeling at enterprise scale and embedding/API scenarios - Strong SQL skills, including performance tuning and analytical query design - Experience designing analytics data models (star schemas, semantic models, lakehouse patterns)
- Consulting experience spanning multiple clients, industries, or verticals - Relevant certifications: Azure Solutions Architect, Azure Data Engineer, Microsoft Fabric (DP-600/DP-700), Databricks certifications - Exposure to advanced analytics use cases: AI/ML model integration, predictive dashboards, or advanced statistical analysis
The Data & Analytics Engineer is Collectiv’s most versatile technical consultant, combining deep data engineering expertise with advanced Power BI and analytics delivery capabilities. This role closes the gap between backend data platform work and front-end analytics, enabling a single consultant to take a client from raw data ingestion through to polished, insight-ready dashboards. You design and implement modern lakehouse architectures on Microsoft Fabric and Databricks, build performant ELT/ETL pipelines, develop rich semantic models, and deliver complex Power BI reports, all while acting as a trusted technical advisor to enterprise clients. You thrive on translating ambiguous business requirements into scalable, well-documented technical solutions and are equally comfortable deep in Spark transformations or fine-tuning DAX formulas. This role sits at the intersection of Collectiv’s Data Engineering and Senior Power BI Consultant practices and is designed for experienced professionals who refuse to choose a lane.
- 5+ years of combined experience in data engineering, analytics engineering, and/or BI consulting - Hands-on production experience with Microsoft Fabric and/or Databricks (both strongly preferred) - Advanced proficiency in Power BI, including complex data modeling, DAX authoring, and performance optimization
Role Overview The Data & Analytics Engineer is Collectiv’s most versatile technical consultant, combining deep data engineering expertise with advanced Power BI and analytics delivery capabilities. This role closes the gap between backend data platform work and front-end analytics, enabling a single consultant to take a client from raw data ingestion through to polished, insight-ready dashboards. You design and implement modern lakehouse architectures on Microsoft Fabric and Databricks, build performant ELT/ETL pipelines, develop rich semantic models, and deliver complex Power BI reports, all while acting as a trusted technical advisor to enterprise clients. You thrive on translating ambiguous business requirements into scalable, well-documented technical solutions and are equally comfortable deep in Spark transformations or fine-tuning DAX formulas.
You design and implement modern lakehouse architectures on Microsoft Fabric and Databricks, build performant ELT/ETL pipelines, develop rich semantic models, and deliver complex Power BI reports, all while acting as a trusted technical advisor to enterprise clients. You thrive on translating ambiguous business requirements into scalable, well-documented technical solutions and are equally comfortable deep in Spark transformations or fine-tuning DAX formulas. This role sits at the intersection of Collectiv’s Data Engineering and Senior Power BI Consultant practices and is designed for experienced professionals who refuse to choose a lane. Key Responsibilities
- Apply version control, CI/CD concepts, and code review standards to all data engineering workflows Power BI & Analytics Delivery - Design and implement complex data models utilizing Power BI, including enterprise-grade semantic layer development
Power BI & Analytics Delivery - Design and implement complex data models utilizing Power BI, including enterprise-grade semantic layer development - Create visually compelling, interactive reports and dashboards that drive measurable client decisions
- Work directly with client stakeholders to gather requirements, communicate technical concepts, and manage expectations - Provide expert guidance on Power BI solutions and data platform decisions; ensure precision in all data discussions - Conduct in-depth research on emerging tools and trends to keep clients ahead of the curve
- Hands-on production experience with Microsoft Fabric and/or Databricks (both strongly preferred) - Advanced proficiency in Power BI, including complex data modeling, DAX authoring, and performance optimization - Power BI dataset modeling at enterprise scale and embedding/API scenarios
- Advanced proficiency in Power BI, including complex data modeling, DAX authoring, and performance optimization - Power BI dataset modeling at enterprise scale and embedding/API scenarios - Strong SQL skills, including performance tuning and analytical query design
- Business users are fully enabled through reliable semantic models and analytics-ready datasets - Power BI reports you build are cited by clients as transformative to their decision-making process - You actively contribute to Collectiv’s data platform standards and continuously raise the bar for consulting excellence
Join Collectiv for a rewarding career in a fully remote work environment with quarterly in-person team experiences and 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.
Keep Calm and Carry On – Stay cool, calm and Collectiv. 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: We help enterprises make better decisions.
Complete your application on collectiv.breezy.hr. The employer’s form will show what is required.
Already applied? Track this application
Role Overview
The Data & Analytics Engineer is Collectiv’s most versatile technical consultant, combining deep data engineering expertise with advanced Power BI and analytics delivery capabilities. This role closes the gap between backend data platform work and front-end analytics, enabling a single consultant to take a client from raw data ingestion through to polished, insight-ready dashboards.
You design and implement modern lakehouse architectures on Microsoft Fabric and Databricks, build performant ELT/ETL pipelines, develop rich semantic models, and deliver complex Power BI reports, all while acting as a trusted technical advisor to enterprise clients. You thrive on translating ambiguous business requirements into scalable, well-documented technical solutions and are equally comfortable deep in Spark transformations or fine-tuning DAX formulas.
This role sits at the intersection of Collectiv’s Data Engineering and Senior Power BI Consultant practices and is designed for experienced professionals who refuse to choose a lane.
Key Responsibilities
Data Platform & Lakehouse Engineering
Power BI & Analytics Delivery
Client Consulting & Advisory
Engineering Excellence & Collaboration
Required Qualifications
Preferred Qualifications
What Success Looks Like
Why Collectiv
Join Collectiv for a rewarding career in a fully remote work environment with quarterly in-person team experiences and 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.
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: We help enterprises make better decisions.
New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
We file this job under Data Engineer, by the work the posting describes.
Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.
Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.
An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.
The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.
Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
No pay amount identified in the saved description.
Chicago, IL
Why Collectiv Join Collectiv for a rewarding career in a fully remote work environment with quarterly in-person team experiences and 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.
No clear work-authorization passage found. Eligibility is unconfirmed.