Data & Analytics Engineer

CompassMSP is seeking a Data & Analytics Engineer to run and extend its Azure-based data platform and consolidate reporting onto its lakehouse. The role includes maintaining pipelines, modeling data, building reports and internal apps, and supporting an AI layer for data questions.

Responsibilities:

• 60% Backend / 30% Front-end / 10% Business Systems as needed
• Data platform engineering
• Migration & Sunsetting
• Data health reporting
• Reporting, internal apps & AI

Requirements:

• 3+ years in data engineering, analytics engineering or a similar role
• Strong SQL, including T-SQL. You can read and refactor stored procedures, views and SQL Agent jobs
• Strong Python for data work, with experience in DuckDB, Spark, pandas or similar
• Hands-on experience with a cloud data platform, ideally Azure, and with Delta Lake or similar table formats
• Solid data modeling: dimensional models, medallion architecture, slowly changing dimensions and conformed metrics
• Experience building ELT pipelines from REST APIs and SaaS systems
• A track record of migrating reports or data workloads between platforms, with a disciplined reconciliation and sign-off process
• Experience building reports and dashboards for business users, and turning loose questions into precise metrics
• Comfortable with Git, pull requests and code review
• The instinct to reconcile a number before you trust it
• Experience in an MSP or IT services business, or with ConnectWise, Sage Intacct or HiBob data
• Experience with Salesforce, Gong, Cognism or HubSpot, as an admin or as a data source
• Power BI depth: DAX, semantic models, the REST and XMLA APIs and usage metrics
• Experience decommissioning legacy systems, including finding dependencies, managing stakeholders and archiving
• Microsoft Fabric, Azure Container Apps or Docker
• Web development (JavaScript, HTML and CSS) and Azure Static Web Apps or App Service
• Data quality and observability tooling, such as dbt tests, Great Expectations or custom checks
• Building with LLM APIs, retrieval-augmented generation or semantic layers
• CI/CD with GitHub Actions