Data and Analytics Engineer

Collectiv • Chicago, IL

3d • Remote

About The Position

The Data & Analytics Engineer is Collectiv’s versatile technical consultant, combining data engineering expertise with advanced Power BI and analytics delivery. The role connects backend data platform work with front-end analytics, taking clients from raw data ingestion through to insight-ready dashboards. It designs and implements lakehouse architectures on Microsoft Fabric and Databricks, builds ELT/ETL pipelines, develops semantic models, and delivers Power BI reports while advising enterprise clients. The engineer translates business requirements into scalable, documented technical solutions and works across Spark transformations and DAX formulas.

The role spans Collectiv’s Data Engineering and Senior Power BI Consultant practices. It includes client-facing delivery and advisory, collaboration with project teams, and contributions to internal standards and knowledge sharing. Success includes trusted client relationships, scalable and secure solutions, enabled business users, and maintaining at least 75% utilization.

Collectiv offers a fully remote work environment with quarterly in-person team experiences, competitive compensation, professional development opportunities, unlimited time off, and a benefits package that includes health insurance coverage for the employee and family, a 401(k) with a 4% match, educational assistance, a tech stipend, and discounts on goods and services.

Requirements

• Bachelor’s degree from an accredited university.
• At least 5 years of combined experience in data engineering, analytics engineering, and/or BI consulting.
• Hands-on production experience with Microsoft Fabric and/or Databricks.
• Advanced Power BI proficiency, including complex data modeling, DAX authoring, and performance optimization.
• Experience with 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, including star schemas, semantic models, and lakehouse patterns.
• Demonstrated ability to integrate diverse data sources into data platforms and BI tools.
• Track record in a client-facing consulting role, working independently and managing stakeholder expectations.
• Strong written and verbal communication skills, with precise, client-ready communication.

Nice To Haves

• Experience migrating or modernizing legacy data warehouses to lakehouse architectures.
• Experience integrating data platforms with downstream applications or external APIs.
• Consulting experience across multiple clients, industries, or verticals.
• Relevant certifications such as Azure Solutions Architect, Azure Data Engineer, Microsoft Fabric (DP-600/DP-700), or Databricks certifications.
• Exposure to advanced analytics use cases such as AI/ML model integration, predictive dashboards, or advanced statistical analysis.
• Experience with both Microsoft Fabric and Databricks.

Responsibilities

• Design and implement data platforms using Microsoft Fabric and Databricks technologies.
• 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 data models, including star schemas, semantic models, and lakehouse patterns.
• Write, optimize, and tune SQL and Spark transformations for large-scale analytical workloads.
• Apply version control, CI/CD concepts, and code review standards to data engineering workflows.
• Design complex Power BI data models and enterprise-grade semantic layers.
• Create interactive reports and dashboards to support client decision-making.
• Develop, optimize, and peer-review DAX formulas for accuracy and performance.
• Integrate diverse data sources into Power BI using SQL for efficient extraction and transformation.
• Ensure data quality, reliability, and usability across the analytics platform.
• Partner with client business teams to enable self-service analytics through trusted datasets and dashboards.
• Gather requirements from client stakeholders, communicate technical concepts, and manage expectations.
• Advise clients on Power BI solutions and data platform decisions, and research emerging tools and trends.
• Contribute technical expertise to Collectiv’s marketing and business development efforts.
• Facilitate training and support client teams through platform adoption and change.
• Build client relationships through clear communication, stakeholder confidence, proactive follow-through, and adding value.
• Collaborate with project managers, architects, and fellow consultants to align technical delivery with project goals.
• Ensure solutions meet performance, scalability, security, and maintainability criteria.
• Contribute to internal documentation, reusable patterns, knowledge sharing, data platform standards, and post-project retrospectives.
• Maintain a minimum 75% utilization rate while balancing client delivery, internal collaboration, and business priorities.
• Unblock teammates and help raise the quality of engagements.

Benefits

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

What This Job Offers

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