Data & Analytics Engineer

🔥 0 minutes 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 supporting analytics, reporting, and downstream data products • Translate business and analytical requirements into technical data models, including star schemas, semantic models, and 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 data engineering workflows • Design and implement complex Power BI data models and enterprise-grade semantic layers • Create interactive reports and dashboards that drive measurable client decisions • Develop, optimize, and peer-review DAX formulas for accuracy and performance • Integrate diverse data sources into Power BI using SQL for efficient extraction and transformation • Ensure data quality, reliability, and usability across the analytics platform • Enable self-service analytics by delivering trusted datasets and dashboards with client business teams • 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 asset • 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 to align technical delivery with project goals • Ensure solutions meet performance, scalability, security, and maintainability standards • Contribute to documentation, reusable patterns, knowledge sharing, data platform standards, and post-project retrospectives • 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 client-facing consulting experience, 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 • Preferred: relevant certifications such as 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 for you and your family, including medical, dental, and vision plans • Competitive 401(k) with a 4% match • Educational assistance • Tech stipend • Discounts on various goods and services