Apply

Ready to go for it?

AI Apply speeds things up—apply directly if you prefer.

FREE ACCESS
5,000–10,000 jobs/day
Scoutfield Logo

See all jobs on Scoutfield

Search thousands of fresh jobs every day.

Discover
  • Fresh listings
  • Fast filters
  • No subscription required
Create a free account and start exploring right away.
Collectiv

Data and Analytics Engineer

Collectiv

. Design and implement modern data platforms using Microsoft Fabric and Databricks .

Posted 10/18/2026full-timeRemote • Illinois • United StatesMid-LevelSeniorWebsite

Core Competencies

Role fit
Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and implementing modern data platforms using Microsoft Fabric and Databricks, with advanced proficiency in Power BI for data modeling and analytics. Capable of translating business requirements into technical solutions while ensuring data quality and performance optimization.

Highest-signal resume keywords
Microsoft FabricDatabricksPower BI Data ModelingSQL Performance TuningData Engineering

ATS Keywords

Tailor your resume
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills
Data IngestionData TransformationELT/ETL Best PracticesDAX AuthoringLakehouse ArchitectureAnalytics Data ModelsVersion ControlCI/CD ConceptsSQLData Quality Assurance
Soft Skills
Client Relationship ManagementStakeholder CommunicationTraining FacilitationCollaborationProblem Solving
Tools & Technologies
Power BIAzure Solutions ArchitectAzure Data EngineerAPIsData Warehousing
Certifications & Qualifications
Azure Solutions ArchitectAzure Data EngineerMicrosoft Fabric (DP-600/DP-700)Databricks Certifications
Industry Keywords
Analytics EngineeringBI ConsultingData PlatformsData QualityPerformance Optimization

Tech Stack

Tools & technologies
AzureETLSparkSQL

About the role

Key responsibilities & impact
  • Design and implement modern data platforms using Microsoft Fabric and Databricks
  • Build and optimize data ingestion, transformation, and orchestration pipelines using ELT/ETL best practices
  • Develop scalable lakehouse architectures for analytics, reporting, and downstream data products
  • Translate business and analytical requirements into technical data models
  • Write, optimize, and tune SQL and Spark transformations for large-scale analytical workloads
  • Apply version control, CI/CD concepts, and code review standards to data engineering workflows
  • Design complex Power BI data models and enterprise-grade semantic layers
  • Create interactive reports and dashboards that drive client decisions
  • Develop, optimize, and peer-review DAX formulas
  • Integrate diverse data sources into Power BI
  • Ensure data quality, reliability, and usability across the analytics platform
  • Enable self-service analytics through trusted datasets and dashboards
  • Gather requirements from client stakeholders, communicate technical concepts, and manage expectations
  • Advise clients on Power BI solutions and data platform decisions
  • Research emerging tools and trends
  • Support marketing and business development efforts as a technical expert
  • Facilitate training and support platform adoption and change
  • Build strong client relationships and proactively identify opportunities to add value
  • Collaborate with project managers, architects, and consultants
  • Ensure solutions meet performance, scalability, security, and maintainability standards
  • Contribute to documentation, reusable patterns, knowledge sharing, retrospectives, and data platform standards
  • Maintain a minimum 75% utilization rate

Requirements

What you’ll need
  • 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, including star schemas, semantic models, and lakehouse patterns
  • Ability to integrate data from diverse sources into 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
  • Preferred: experience migrating or modernizing legacy data warehouses to lakehouse architectures
  • Preferred: experience integrating data platforms with downstream applications or external APIs
  • Preferred: consulting experience spanning multiple clients, industries, or verticals
  • Relevant certifications preferred: Azure Solutions Architect, Azure Data Engineer, Microsoft Fabric (DP-600/DP-700), or Databricks certifications
  • Preferred: exposure to advanced analytics use cases, including AI/ML model integration, predictive dashboards, or advanced statistical analysis

Benefits

Comp & perks
  • Fully remote work environment
  • Quarterly in-person team experiences
  • Competitive compensation
  • Professional development opportunities
  • Top-shelf benefits package
  • Unlimited time off
  • 100% covered health insurance, including 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