> Markdown version of [/jobs/ext/146777-azure-data-reporting-architect](https://www.wearedevelopers.com/jobs/ext/146777-azure-data-reporting-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Azure Data & Reporting Architect - **Company:** Compass Inc - **Location:** United States (Remote available) - **Experience:** Expert - **Salary:** $130,000.0 - $145,000.0 - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Computing Platforms, Data Mart, Health Information Management, Healthcare Effectiveness Data and Information Set, Intrusion Detection Systems, SQL Azure, Power BI, Standard Sql, SQL Databases, Azure Data Factory, Data Layers - **Published:** May 20, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=786a852215aa4df6 ## About the Role Do you have experience in Schema design?, Required * Demonstrated experience designing reporting data models and curated datasets that support enterprise dashboards and repeatable KPI reporting for healthcare domains (medical claims, pharmacy claims, eligibility/enrollment, provider, quality/HEDIS, finance reconciliation). * Strong SQL and data modeling skills; ability to translate business requirements into durable model structures and governed metric definitions. * Azure data platform familiarity sufficient to align model strategy with platform design (ADF pipelines, storage patterns, and SQL-based warehouse structures). * Ability to communicate model logic to both technical and non-technical stakeholders. * Must be able to work for any employer in the U.S. * Must reside in the United States or its territories. Preferred * Power BI modeling/semantic model discipline and performance-oriented modeling with governed measures. * Experience integrating advanced analytics outputs into reporting (predictions/risk scores/anomaly signals) in partnership with analytics stakeholders. * Comfort using AI-assisted development tools with strong validation discipline and HIPAA-minded handling of sensitive data., * Power BI: 5 years (Preferred) * Health information management: 5 years (Required) * SQL: 5 years (Preferred) ## Description The Azure Data & Reporting Architect provides strategic management of Compass Rose's reporting data models-curated data marts, semantic layers, governed metric definitions, and standardized reporting structures that enable consistent, high-trust analytics for executive, clinical, operational, and financial decision-making. This role manages the reporting foundation that sits on top of the Azure data environment and ensures reporting outputs are traceable, reproducible, and scalable across key healthcare domains. Data Domains You Will Support * Medical claims data (professional/institutional, inpatient/outpatient, diagnosis, procedure, revenue codes) * Pharmacy claims data (NCPDP records, formulary status, rebates, pricing, utilization) * Eligibility and enrollment data (834 feeds, coverage periods, retroactive terminations) * Provider and network data (provider IDs, network participation, reimbursement attributes) * Quality measures (e.g., HEDIS value sets, measure calculations) * Financial reconciliation files (invoices, payment registers, admin fee summaries) What You Will Do (Key Responsibilities) * Define and maintain the enterprise reporting model strategy (reporting schemas, curated marts, standardized structures) to support dashboards, scorecards, and operational reporting. * Establish and govern semantic model patterns (curated datasets, metric logic, dimensions/measures) to keep reporting consistent across teams and use cases. * Develop and maintain metric definitions and KPI governance (source mapping, calculation rules, refresh expectations, and "definition of done"). * Lead the design of data marts enabling executive dashboards and exception-based reporting workflows (including board-level visibility into operational trends). * Build validation expectations (reconciliation checks, consistency rules, lineage documentation) to strengthen trust and reproducibility; maintain audit-ready traceability from source to reporting outputs. * Provide architectural oversight so ingestion and transformation pipelines align with reporting model strategy; partner with platform/operations resources responsible for ADF, Storage, and Azure SQL. * Guide how curated datasets and semantic layers are exposed to BI tools so Power BI dashboards rely on governed, performant model structures rather than duplicated report logic. * Use AI-assisted techniques to accelerate drafting of SQL/model logic, documentation, and test routines where appropriate, with disciplined human review for accuracy and compliance. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Hacking MSSQL on Cloud. All of them. How I became sysadmin on Azure, AWS, GCP and Alibaba.](https://www.wearedevelopers.com/videos/100339-hacking-mssql-on-cloud-all-of-them-how-i-became-sysadmin-on-azure-aws-gcp-and-alibaba) - [Automated MS SQL Server database deployments with dacpacs and Azure DevOps](https://www.wearedevelopers.com/videos/334-automated-ms-sql-server-database-deployments-with-dacpacs-and-azure-devops) - [Azure-Well Architected Framework - designing mission critical workloads in practice](https://www.wearedevelopers.com/videos/1529-azure-well-architected-framework-designing-mission-critical-workloads-in-practice) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) ## Related Articles - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)