Data & Analytics Engineer

• 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

• 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

• Clients trust you as their go-to technical advisor across both data platform and analytics decisions
• Delivered solutions are scalable, well-documented, secure, and aligned to best practices
• Consistently maintain a minimum 75% utilization rate by balancing high-quality client delivery, internal collaboration, and business priorities.
• Business users are fully enabled through reliable semantic models and analytics-ready datasets
• Power BI reports you build are cited by clients as transformative to their decision-making process
• You actively contribute to Collectiv’s data platform standards and continuously raise the bar for consulting excellence
• You serve as a force multiplier; unblocking teammates and elevating the quality of every engagement you touch

Join Collectiv for a rewarding career in a fully remote work environment with quarterly in-person team experiences and competitive compensation.

We provide a clear growth trajectory with professional development opportunities and a top-shelf benefits package.

Enjoy unlimited time off and 100% covered health insurance, encompassing medical, dental, and vision plans for you and your family.

Our comprehensive offerings, from a competitive 401(k) with a 4% match to educational assistance, tech stipend, and discounts on various goods and services, demonstrate our commitment to your well-being and success.

At Collectiv, your career thrives with a perfect blend of remote flexibility, growth potential, and unparalleled benefits prioritizing your financial, physical, and emotional well-being.

Collectiv is the leading boutique consulting and strategy firm specializing in Analytics, Planning and AI with Power BI and the Microsoft Data Stack.

Our mission at Collectiv is simple: We help enterprises make better decisions.

Growth Mindset – Bring solutions, not problems.

Excel with Humility – Be humbly brilliant.

Communicate Actively and Empathetically – Listen, ask, understand, help.

Work Hard, Play Hard – Results are proportional to effort.

Keep Calm and Carry On – Stay cool, calm and Collectiv.

Collectiv is the leading boutique consulting and strategy firm specializing in Analytics, Planning, and AI with Power BI and the Microsoft Data Stack.

Our mission: We help enterprises make better decisions.