Data and Analytics Engineer

🔥 1 minute ago

🌽 Illinois – Remote

🌽 Illinois – Remote

⏰ Full Time

🟡 Mid-level

🟠 Senior

📊 Analytics Engineer

👻 Ghost score 13%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Collectiv

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 2021

💼 Consulting

📣 Marketing

🏥 Healthcare

Consulting • Marketing • Healthcare

Collectiv is a leading Microsoft consulting firm specializing in data architecture, analytics, and the integration of AI technologies. They are renowned for their strategic partnerships with organizations to enhance their data initiatives using Microsoft tools such as Azure, Fabric, Power BI, and Copilot. As experts in the Microsoft Data Stack, Collectiv offers a range of services including data strategy, implementation, planning and forecasting, and staff augmentation. Their mission is to streamline data processes and enable effective data-driven decision-making across businesses.

📋 Description

• 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

• 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

• 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