About the role
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 neededData platform engineeringMigration & SunsettingData health reportingReporting, internal apps & AI Qualifications 3+ years in data engineering, analytics engineering or a similar roleStrong SQL, including T-SQL. You can read and refactor stored procedures, views and SQL Agent jobsStrong Python for data work, with experience in DuckDB, Spark, pandas or similarHands-on experience with a cloud data platform, ideally Azure, and with Delta Lake or similar table formatsSolid data modeling: dimensional models, medallion architecture, slowly changing dimensions and conformed metricsExperience building ELT pipelines from REST APIs and SaaS sy
Skills
- Microsoft Azure
- Data Lake
- SQL
- T-SQL
- Python
- Apache Spark
- Pandas
- Databricks
- Database Design
- ETL
- REST APIs