Remote Data & Analytics Engineer: Lakehouse + Power BI

Collectiv; Chicago (IL); Remote; USD 150,000 - 190,000; Full time

Job summary

Collectiv is seeking a versatile Full Stack Data & Analytics Engineer to bridge data platform work with advanced Power BI analytics. You’ll design lakehouse architectures on Fabric and Databricks, build ELT/ETL pipelines, and deliver enterprise-grade Power BI reports while advising clients directly.

You’ll translate business needs into scalable data models, craft DAX for performance, and ensure data quality across analytics platforms, collaborating with teams and stakeholders to exceed client

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

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
• 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

Skills

Power BI

SQL

Databricks

Data modeling

DAX

CI/CD

Client-facing

Communication

Education

Bachelor’s degree

Tools

Microsoft Fabric

Databricks

Power BI

Job description

Collectiv is seeking a versatile Full Stack Data & Analytics Engineer to bridge data platform work with advanced Power BI analytics. You’ll design lakehouse architectures on Fabric and Databricks, build ELT/ETL pipelines, and deliver enterprise-grade Power BI reports while advising clients directly.

You’ll translate business needs into scalable data models, craft DAX for performance, and ensure data quality across analytics platforms, collaborating with teams and stakeholders to exceed client