Note: The job is a remote job and is open to candidates in USA. 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
Skills
- 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
Benefits
- Quarterly bonuses
- Progressive PTO
- Medical, dental, vision, life, and disability coverages available
- 401(k) with company match
- Career development and coaching
- Remote work
Company Overview