Note: The job is a remote job and is open to candidates in USA. Collectiv is a consulting and strategy firm specializing in analytics, planning, and AI. The Data & Analytics Engineer delivers end-to-end data platform and analytics solutions for enterprise clients, including lakehouse architectures, data pipelines, semantic models, and Power BI reporting, while providing technical consulting and advisory support.
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
- 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
Benefits
- Fully remote work environment with quarterly in-person team experiences
- Clear growth trajectory
- Professional development opportunities
- Unlimited time off
- 100% covered health insurance, encompassing medical, dental, and vision plans for you and your family
- 401(k) with a 4% match
- Educational assistance
- Tech stipend
- Discounts on various goods and services
Company Overview