Data Engineer (Azure, Fabric, Databricks) (Remote)

Role Overview

The 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 Responsibilities

Client Delivery & Solution Design

  • Design 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 practices
  • Develop scalable lakehouse architectures that support analytics, reporting, and downstream data products
  • Translate business and analytical requirements into technical designs and data models

Analytics & BI Enablement

  • Develop and maintain semantic models that enable performant reporting and self-service analytics
  • Partner with analytics and business teams to deliver trusted datasets and dashboards (Power BI or equivalent)
  • Ensure data quality, reliability, and usability across the analytics platform

Engineering Best Practices

  • 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 data engineering workflows
  • Ensure solutions meet quality criteria related to performance, scalability, and maintainability

Consulting & Collaboration

  • Work directly with client stakeholders to gather requirements, communicate technical concepts, and manage expectations
  • Collaborate with project managers, architects, and fellow consultants to align technical delivery with project goals
  • Contribute to internal documentation, reusable patterns, and knowledge sharing across Collectiv

Required Qualifications

  • Bachelor's degree from an accredited university
  • 4+ years of experience in data engineering, analytics engineering, or data platform consulting
  • Hands-on experience with Microsoft Fabric and/or Databricks in production environments (experience with both strongly preferred)
  • Strong SQL skills, including performance tuning and optimization
  • Experience 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 role

Preferred Qualifications

  • Experience migrating or modernizing data platforms (e.g., legacy DW to lakehouse)
  • Familiarity with Power BI dataset modeling and performance optimization
  • Experience integrating data platforms with downstream applications or APIs
  • Consulting experience with multiple clients or industries
  • Strong written and verbal communication skills
  • Relevant Azure certifications (e.g., Azure Solutions Architect, Azure Data Engineer), Fabric (DP-600, DP-700) certifications, and Databricks certifications are highly desirable

What Success Looks Like in This Role

  • Clients trust you as a technical advisor for their data platform decisions
  • Delivered solutions are scalable, well-documented, and aligned to best practices
  • Business users are enabled through reliable data models and analytics-ready datasets
  • You actively contribute to Collectiv's data platform standards and consulting excellence

Join 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.


Remote

Skills:
Analysis Skills, Application Programming Interface (API), Architectural Analysis, Artificial Intelligence (AI), Best Practices, Business Intelligence, Channel Strategies, Cloud Computing, Code Reviews, Communication Skills, Consulting, Continuous Deployment/Delivery, Continuous Integration, Cross-Functional, Customer Relations, Customer/Client Research, Data Analysis, Data Migration, Data Modeling, Data Quality, Data Sets, Database Extract Transform and Load (ETL), Documentation, Educational Technology, Microsoft Product Family, Microsoft Windows Azure, Multiplatform/Cross-Platform, Performance Modeling, Performance Tuning/Optimization, Power BI, Presentation/Verbal Skills, Production Systems, Reporting Dashboards, Requirements Management, SQL (Structured Query Language), Scalable System Development, Source Code/Configuration Management (SCM), Star Schema, Technical Delivery, Technical Support, Technical/Engineering Design, Training Data Sets, Usability Engineering, Warehousing, Work From Home, Writing Skills


undefined:
Collectiv



Back to blog

Other Jobs To Apply

DC Warehouse Supervisor

Customer Chat Assistant - Easy Remote Jobs No Experience Required

Remote Hospice Triage RN - FT Baylor Shift (Sat, Sun & Monday)

Remote Appointment Setter

Warehouse Associate II (Part-Time)

Remote Entry-Level Virtual Data Entry Specialist

Data Entry - Typist Part-Time - Work

Warehouse Supervisor - Receiving and Inventory Lead - Southern Methodist Univ.

(Entry Level / No Experience) Data Entry Remote Jobs - Part Time

Housekeeping Attendant

Remote Customer Service Representative Needed: Earn 19 Per Hour

In House Sales Manager Remote HGV East

Remote Work From Home Data Entry Jobs $1400 Weekly

Data Entry Clerk Work From Home - Part-Time Focus Group Participants (Up To $750/Week)

Amazon Customer Service - Work From Home $16-$24/hr

Entry-Level Drilling Floorhand: Start Your Rig Career

Amazon Physical Stores Needs Amazon Hub Locker+ Customer Service

Watch Netflix (Tagger): $12-$46

Front Office Assistant

Amazon Picker Packer

Female VSL / On-Camera Video Creator for B2B Marketing Company

Warehouse Associate (PT or FT Available)

Amazon Customer Service Representative (Remote)

Remote Travel Agent (Flexible Schedule | Training Provided)

amazon flex $15+/ Hour (Sign on Bonus)!

Call Center Agent (PT or FT - 100% Work From Home)

Airport Cabin High Lift Driver - JFK

Part-Time Remote Transcription Jobs for Beginners

Amazon Delivery Driver

Administrative Assistant - Data Entry (Remote)

OR Terminal Cleaning Attendant / Environmental Services / FT / 2nd and 3rd Shift

Part-Time Amazon Bulk Delivery Driver – Riverside CA | Part Time

Watch Netflix (Tagger): $12-$46

Virtual Receptionist

Sr Program Manager, M&A People

Remote IPU Technician — Overnight Data Entry Pro

Work From Home Amazon Customer Service Job – Part-Time – No Experience Needed

Quality Assurance Engineer, Mechatronics & Sustainable Packaging

Nurse - Remote - LPN/LVN - Compact licensure required

Warehouse Receiving Dock Supervisor

Dallas Hiring:Part-Time Weekend Warehouse Package Handler

Corporate System Administrator

Cybersecurity - Entry Level Training Program

Entry‑Level Remote Live Chat Agent – No Experience Required, Earn Up to $35/hr, Strong Writing & Communication Skills

Entry-Level Customer Service Representative (Remote)

Sr. Technical Account Manager - Enterprise, Amazon Leo

Hybrid/Remote Cyber Security Specialist – Threat & IAM

WTX - FLOORHAND I

Customer Service Rep (100% Work From Home)

Rancho Cordova AWS Customer Support Associate(Full-time)-Amazon Web