Collectiv Logo

Collectiv

Data and Analytics Engineer

Posted One Month Ago
In-Office
Chicago, IL, USA
Senior level
In-Office
Chicago, IL, USA
Senior level
Design and implement lakehouse architectures, data pipelines, semantic models, and enterprise Power BI dashboards using Microsoft Fabric and Databricks. Optimize SQL, Spark, and DAX workloads while ensuring data quality, scalability, security, and maintainability. Consult with enterprise clients, translate business needs into technical solutions, provide platform guidance and training, manage stakeholders, and contribute to internal engineering standards and reusable practices.
The summary above was generated by AI

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 

  • 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 
  • Develop scalable lakehouse architectures that support analytics, reporting, and downstream data products 
  • 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 

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 
  • 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 
  • Enable self-service analytics by partnering with client business teams to deliver trusted datasets and dashboards 

Client Consulting & Advisory 

  • 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 
  • Act as a core technical asset in Collectiv’s marketing and business development efforts 
  • Facilitate training sessions and support client teams through platform adoption and change 
  • Build strong client relationships through clear communication, confidence with stakeholders, and a warm, personable presence 
  • Take a proactive approach to delivery and client relationships by anticipating needs, following through on commitments, and looking for opportunities to add value 

Engineering Excellence & Collaboration 

  • Collaborate with project managers, architects, and fellow consultants to align technical delivery with project goals 
  • Ensure solutions meet quality criteria related to performance, scalability, security, and maintainability 
  • Contribute to internal documentation, reusable patterns, and knowledge sharing across Collectiv 
  • Participate in post-project retrospectives and contribute to Collectiv’s data platform standards 

Required Qualifications 

  • Bachelor’s degree from an accredited university 
  • 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 
  • 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) 
  • Demonstrated ability to integrate data from diverse sources into both data platforms and BI tools 
  • Proven track record in a client-facing consulting role, working independently and managing stakeholder expectations 
  • Strong written and verbal communication style; data-filled, precise, and client-ready 

Preferred Qualifications 

  • Experience migrating or modernizing legacy data warehouses to lakehouse architectures 
  • Experience integrating data platforms with downstream applications or external APIs 
  • 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 

What Success Looks Like 

  • Clients trust you as their go-to technical advisor across both data platform and analytics decisions 
  • Delivered solutions are scalable, well-documented, secure, and aligned to best practices 
  • Consistently maintain a minimum 75% utilization rate by balancing high-quality client delivery, internal collaboration, and business priorities. 
  • 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 
  • You serve as a force multiplier; unblocking teammates and elevating the quality of every engagement you touch 

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. 

HQ

Collectiv Chicago, Illinois, USA Office

980 N Michigan Ave, 1400, Chicago, IL, United States, 60611

Similar Jobs

6 Days Ago
Easy Apply
Remote or Hybrid
United States
Easy Apply
125K-234K Annually
Senior level
125K-234K Annually
Senior level
Fintech • Mobile • Software • Financial Services
Build and maintain production data pipelines, dbt models, Airflow workflows, and governed datasets supporting People Analytics. Integrate Workday and other HR systems into reliable Snowflake data products, implement data quality monitoring, row-level security, semantic models, and AI agents. Partner with engineers, analysts, data scientists, and business stakeholders to deliver trusted data solutions, communicate technical trade-offs, enforce governance, and mentor other engineers.
Top Skills: Ai AgentsAmazon RedshiftApache AirflowCi/CdDbtEtl/EltGitlabGoogle Cloud PlatformLlmsPythonSnowflakeSQLWorkday
One Month Ago
Easy Apply
Remote or Hybrid
Chicago, IL, USA
Easy Apply
137K-231K Annually
Senior level
137K-231K Annually
Senior level
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Architect and own marketing data infrastructure, including Databricks pipelines, Gold Layer tables, semantic models, and ETL/ELT workflows. Build trusted data products for analytics, automation, and AI agents; translate ambiguous business needs into scalable solutions; lead cross-team initiatives; ensure reliability and data quality; mentor engineers and analysts; and develop, evaluate, and monitor production LLM and agent systems using Python and SQL.
Top Skills: Ai AgentsBigQueryClaude CodeCursorDatabricksDbtEtl/EltLlmsPythonSalesforceSnowflakeSQLStreamlit
7 Days Ago
In-Office
Chicago, IL, USA
90K-125K Annually
Junior
90K-125K Annually
Junior
Financial Services
Build and maintain analytical datasets, dimensional models, Power BI semantic models, and governed data transformations in Microsoft Fabric. Translate business requirements into reliable data products, perform testing and reconciliation, troubleshoot refreshes and deployment issues, and support Git-based development and CI/CD practices. The role requires independent ownership of low- to moderate-complexity engineering work, technical documentation, and collaboration with senior engineers, DataOps, governance teams, consultants, and business stakeholders.
Top Skills: AzureAzure DevopsCi/CdDaxGitGitMicrosoft FabricMicrosoft Fabric Deployment PipelinesPower BIPower QueryPysparkPythonSparkSpark SqlSQL

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account