Senior Data & Analytics Engineer (Power BI & Lakehouse)

Visa Hunt; United States; On-site; USD 110,000 - 170,000; Full time

Benefits offered by this job

Unlimited time off

100% health insurance coverage

401(k) with 4% match

Educational assistance

Tech stipend

Discounts on goods and services

Job summary

Collectiv is seeking a Data & Analytics Engineer to serve as a versatile technical consultant, bridging backend data platforms with front-end analytics using Power BI. You will design lakehouse architectures on Microsoft Fabric and Databricks, build scalable ELT/ETL pipelines, and deliver complex Power BI reports for enterprise clients.

The role requires translating ambiguous business needs into scalable, well-documented solutions, with hands-on Spark and DAX optimization.

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

• Design and implement modern data platforms leveraging Microsoft Fabric and Databricks.
• 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).
• 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.
• 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.
• Collaborate with client stakeholders to gather requirements, communicate technical concepts, and manage expectations.

Skills

Data engineering

Analytics engineering

BI consulting

Power BI

SQL

Spark

Data modeling

Lakehouse

ETL/ELT

Education

Bachelor’s degree

Tools

Microsoft Fabric

Databricks

Power BI

SQL

Job description

Collectiv is seeking a Data & Analytics Engineer to serve as a versatile technical consultant, bridging backend data platforms with front-end analytics using Power BI. You will design lakehouse architectures on Microsoft Fabric and Databricks, build scalable ELT/ETL pipelines, and deliver complex Power BI reports for enterprise clients.

The role requires translating ambiguous business needs into scalable, well-documented solutions, with hands-on Spark and DAX optimization.