Data & Analytics Engineer

Job not on LinkedIn

🔥 0 minutes ago

🇺🇸 United States – Remote

⏰ Full Time

🟡 Mid-level

🟠 Senior

📊 Analytics Engineer

👻 Ghost score 10%

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

CompassMSP

WebsiteLinkedInAll Job Openings

201 - 500 employees

🔒 Cybersecurity

🤝 B2B

💼 Consulting

Cybersecurity • B2B • Consulting

CompassMSP is a U. S. -based managed services provider that delivers managed IT, cloud & infrastructure, and cybersecurity services to business and regulated-industry clients. Their offerings include fully managed and co-managed IT, Microsoft 365 support, cloud strategy and migration (Azure & AWS), 24/7 service desk, data backup and disaster recovery, unified communications/UCaaS, vCISO and security advisory, incident response and ransomware protection, and compliance-readiness services for frameworks such as HIPAA, HITRUST and CMMC. The company also supports AI modernization and secure AI initiatives and maintains a national footprint with multiple regional offices.

📋 Description

• Allocate approximately 60% of work to backend, 30% to front-end and 10% to business systems as needed. • Engineer and maintain the Microsoft Azure internal data platform and lakehouse. • Consolidate reporting onto the lakehouse and data portal. • Retire the legacy SQL Server reporting environment and Power BI by migrating active reports to the governed lakehouse and data portal. • Maintain healthy data pipelines and support the full data path. • Model data and build trusted reports and dashboards. • Build internal applications on the data platform. • Help add an AI layer enabling plain-language questions of the data. • Produce data health reporting. • Collaborate with the Director of Data & Analytics and stakeholders in Service Delivery, Finance, Sales, Client Success and Leadership. • Use AI coding assistants for development, code review, data exploration and documentation while owning the quality and correctness of shipped work.

🎯 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. • Preferred: Experience in an MSP or IT services business, or with ConnectWise, Sage Intacct or HiBob data. • Preferred: Experience with Salesforce, Gong, Cognism or HubSpot, as an admin or as a data source. • Preferred: Power BI depth: DAX, semantic models, the REST and XMLA APIs and usage metrics. • Preferred: Experience decommissioning legacy systems, including finding dependencies, managing stakeholders and archiving. • Preferred: Microsoft Fabric, Azure Container Apps or Docker. • Preferred: Web development (JavaScript, HTML and CSS) and Azure Static Web Apps or App Service. • Preferred: Data quality and observability tooling, such as dbt tests, Great Expectations or custom checks. • Preferred: Building with LLM APIs, retrieval-augmented generation or semantic layers. • Preferred: CI/CD with GitHub Actions.

🏖️ Benefits

• Competitive annual salary • Quarterly Bonuses • Progressive PTO • Medical/Dental/Vision/Life/Disability coverages available • 401k with company match • Career Development and Coaching