CompassMSP
CompassMSP
CompassMSP este un furnizor de servicii gestionate din SUA, care deservește companii și industrii reglementate prin expertiză în servicii IT gestionate, infrastructură cloud, securitate cibernetică și consultanță. Serviciile sale includ IT complet gestionat și IT co-gestionat, asistență pentru Microsoft 365, strategie și migrare în cloud pentru Azure și AWS, operațiuni ale unui birou de service disponibil 24/7, backup și recuperare în caz de dezastru, comunicații unificate, consultanță vCISO, răspuns la incidente, protecție împotriva ransomware-ului și pregătire pentru conformitatea cu cadre precum HIPAA, HITRUST și CMMC. CompassMSP lucrează, de asemenea, la modernizarea AI și la inițiative de AI securizat, având o prezență națională susținută de mai multe birouri regionale.

Remote Data Analytics Engineer

Build and maintain CompassMSP’s Azure lakehouse and data portal for MSP operations, while moving reporting from legacy SQL Server and Power BI. The role also covers data pipelines, dashboards, internal applications, and AI capabilities.

Descriere

  • Direct roughly 60% of your work to backend development, 30% to front-end development, and 10% to business systems as needed.
  • Build and maintain CompassMSP’s internal data platform and lakehouse in Microsoft Azure.
  • Bring reporting together in the lakehouse and data portal.
  • Move active reports to the governed lakehouse and data portal as you phase out legacy SQL Server reporting and Power BI.
  • Keep data pipelines healthy and support the end-to-end data flow.
  • Create data models, reports, and dashboards that business users can trust.
  • Develop internal applications on the data platform.
  • Help build an AI layer that lets users ask questions about data in plain language.
  • Create reports on data health.
  • Work with the Director of Data & Analytics and colleagues across Service Delivery, Finance, Sales, Client Success, and Leadership.
  • Use AI coding assistants for development, code review, data exploration, and documentation, while taking responsibility for the quality and accuracy of your work.

Cerințe

  • At least 3 years of experience in data engineering, analytics engineering, or a related role.
  • Strong SQL skills, including T-SQL, with the ability to read and refactor stored procedures, views, and SQL Agent jobs.
  • Strong Python skills for data work and experience with DuckDB, Spark, pandas, or similar tools.
  • Hands-on experience with a cloud data platform, preferably Azure, and Delta Lake or a similar table format.
  • Sound data modeling skills, including dimensional models, medallion architecture, slowly changing dimensions, and conformed metrics.
  • Experience building ELT pipelines from REST APIs and SaaS systems.
  • Experience migrating reports or data workloads between platforms, with a structured process for reconciliation and sign-off.
  • Experience creating reports and dashboards for business users and turning broad questions into precise metrics.
  • Comfort using Git, pull requests, and code review.
  • A habit of reconciling figures before relying on them.
  • Preferred: Experience in an MSP or IT services company, or with ConnectWise, Sage Intacct, or HiBob data.
  • Preferred: Experience administering or using data from Salesforce, Gong, Cognism, or HubSpot.
  • Preferred: In-depth Power BI experience, including DAX, semantic models, REST and XMLA APIs, and usage metrics.
  • Preferred: Experience retiring legacy systems, including mapping dependencies, coordinating stakeholders, and archiving.
  • Preferred: Experience with Microsoft Fabric, Azure Container Apps, or Docker.
  • Preferred: Web development experience with JavaScript, HTML, and CSS, plus Azure Static Web Apps or App Service.
  • Preferred: Experience with data quality and observability tools such as dbt tests, Great Expectations, or custom checks.
  • Preferred: Experience building with LLM APIs, retrieval-augmented generation, or semantic layers.
  • Preferred: Experience with CI/CD using GitHub Actions.

Beneficii

  • Competitive annual salary
  • Quarterly bonuses
  • Progressive paid time off
  • Medical, dental, vision, life, and disability coverage available
  • 401(k) with company match
  • Career development and coaching

Locuri de muncă similare

Horace Mann

Director of Analytics Engineering

Horace Mann

Lead analytics engineering for Horace Mann’s Life & Retirement business, shaping its enterprise data warehouse and governed data products. Build cloud data capabilities, guide technical strategy, and develop high-performing teams.

Deschide
Fortitude Re

Senior Associate, Data Solutions Engineering

Fortitude Re

Build and improve data pipelines, architectures, and automated solutions at Fortitude Re, a global reinsurance provider. The role focuses on data flow, governance, and reliable delivery for downstream teams.

Deschide