Analytics Engineer

Role Overview

We are seeking an experienced Analytics Engineer to bridge the gap between data engineering and business intelligence. This role is critical for designing SQL models, building Power BI semantic layers, supporting data pipelines, and partnering directly with stakeholders.

• Data Modeling & SQL: Design and maintain views, staging tables, and fact/dimension models in Azure SQL. Implement complex logic including deduplication, status routing, and multi-source reconciliation using CTEs and window functions.
• Semantic Models & Reporting: Build Power BI semantic models from scratch, define DAX measures (CALCULATE, filter context), configure security roles, and create dashboards for company-wide reporting.
• Pipeline Support: Collaborate with Senior Management to monitor Azure Data Factory pipelines. Perform troubleshooting on refresh failures and make minor modifications to support evolving business requirements.
• Business Partnership: Work closely with SMEs to translate complex rules (commission structures, revenue recognition) into accurate data models.
• Documentation & Standards: Maintain clear documentation for lineage and ownership. Evolve team standards for naming conventions and DAX styles.