CompassMSP
CompassMSP
CompassMSP je ponudnik upravljanih storitev s sedežem v ZDA, ki podjetjem in reguliranim panogam zagotavlja upravljane IT-storitve, oblačno infrastrukturo, kibernetsko varnost in svetovalno strokovno znanje. Njegove storitve obsegajo v celoti upravljane in soupravljane IT-storitve, podporo za Microsoft 365, strategijo oblaka in migracijo za Azure ter AWS, neprekinjeno delovanje servisnega centra 24/7, varnostno kopiranje in obnovo po nesrečah, poenotene komunikacije, svetovanje vCISO, odzivanje na incidente, zaščito pred izsiljevalskim programjem ter pripravljenost na skladnost z okviri, kot so HIPAA, HITRUST in CMMC. CompassMSP se ukvarja tudi z modernizacijo na področju umetne inteligence in pobudami za varen AI, njegovo nacionalno prisotnost pa podpirajo številne regionalne pisarne.

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.

Opis

  • 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.

Zahteve

  • 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.

Ugodnosti

  • 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

Sorodna delovna mesta

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.

Odpri