Role OverviewThe Data Engineer is responsible for designing, implementing, and supporting modern data platforms using Microsoft Fabric and Databricks, with a strong emphasis on lakehouse architecture, analytics engineering, and semantic modeling.

This role is client-facing and requires translating business

requirements

into scalable technical solutions while adhering to data engineering best practices.

You will collaborate with client stakeholders, Collectiv consultants, and cross-functional teams to deliver data platforms that support reporting, advanced analytics, and self-service BI. Key ResponsibilitiesClient Delivery Solution DesignDesign and implement modern data platforms leveraging Microsoft Fabric (OneLake, Lakehouse, Data Factory, Power BI) and Databricks (Spark, Delta Lake, SQL Warehouses)Build and optimize data ingestion, transformation, and orchestration pipelines using ELT/ETL best practicesDevelop scalable lakehouse architectures that support analytics, reporting, and downstream data productsTranslate business and analytical

requirements

into technical designs and data modelsAnalytics BI EnablementDevelop and maintain semantic models that enable performant reporting and self-service analyticsPartner with analytics and business teams to deliver trusted datasets and dashboards (Power BI or equivalent)Ensure data quality, reliability, and usability across the analytics platformEngineering Best PracticesWrite, optimize, and tune SQL and Spark-based transformations for large-scale analytical workloadsApply version control, CI/CD concepts, and code review standards to data engineering workflowsEnsure solutions meet quality criteria related to performance, scalability, and maintainabilityConsulting CollaborationWork directly with client stakeholders to gather

requirements

, communicate technical concepts, and manage expectationsCollaborate with project managers, architects, and fellow consultants to align technical delivery with project goalsContribute to internal documentation, reusable patterns, and knowledge sharing across CollectivRequired

Qualifications

Bachelor's degree from an accredited university4+ years of experience in data engineering, analytics engineering, or data platform consultingHands-on experience with Microsoft Fabric and/or Databricks in production environments (experience with both strongly preferred)Strong SQL skills, including performance tuning and optimizationExperience designing data models for analytics (star schemas, semantic models, lakehouse patterns)Experience working in cloud data platforms (Azure preferred)Ability to work independently in a client-facing consulting rolePreferred

Qualifications

Experience migrating or modernizing data platforms (e. g. , legacy DW to lakehouse)Familiarity with Power BI dataset modeling and performance optimizationExperience integrating data platforms with downstream applications or APIsConsulting experience with multiple clients or industriesStrong written and verbal communication skillsRelevant Azure certifications (e. g. , Azure Solutions Architect, Azure Data Engineer), Fabric (DP-600, DP-700) certifications, and Databricks certifications are highly desirableWhat Success Looks Like in This RoleClients trust you as a technical advisor for their data platform decisionsDelivered solutions are scalable, well-documented, and aligned to best practicesBusiness users are enabled through reliable data models and analytics-ready datasetsYou actively contribute to Collectiv’s data platform standards and consulting excellenceJoin Collectiv for a rewarding career in a fully remote work environment with quarterly in person team experiences and a 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.

Our Core Values: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.