Note: The job is a remote job and is open to candidates in USA. Collectiv is a boutique consulting and strategy firm specializing in analytics, planning, and AI with Power BI and the Microsoft Data Stack. The Full Stack Data & Analytics Engineer designs data platforms and lakehouse architectures, builds ELT/ETL pipelines and semantic models, delivers Power BI dashboards, and advises enterprise clients on data and analytics solutions.

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

Skills

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

Benefits

• Fully remote work environment with quarterly in-person team experiences
• Clear growth trajectory with professional development opportunities
• Top-shelf benefits package
• Unlimited time off
• 100% covered health insurance, encompassing medical, dental, and vision plans for you and your family
• Competitive 401(k) with a 4% match
• Educational assistance
• Tech stipend
• Discounts on various goods and services
• Remote flexibility

Company Overview