Data and Analytics Engineer

Collectiv is a consulting firm specializing in analytics, planning, and AI with Power BI and the Microsoft Data Stack. The Data & Analytics Engineer designs data platforms and pipelines, develops semantic models and Power BI reports, and advises enterprise clients on technical solutions and analytics delivery.

Responsibilities:

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

Requirements:

• 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
• 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
• both strongly preferred
• 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