Associate Data Architect I

Senior Data Analyst - Healthcare Regulatory & Compliance Analytics Location: Offshore - India Experience: 8-10 Years Domain: Healthcare Payer (Medicare Advantage) Role Summary UST is seeking a Senior Data Analyst to support healthcare regulatory and compliance analytics initiatives for a US-based payer client. The role focuses on SQL development, data quality, reporting automation, Power BI reporting, and regulatory data validation. The candidate will work closely with onshore teams to deliver accurate, auditable, and automated reporting solutions. Key Responsibilities Develop and optimize complex SQL queries, stored procedures, and reporting datasets. Build and maintain ETL/ELT processes, data validations, and reconciliation controls. Support Medicare Advantage regulatory, compliance, and operational reporting. Develop Power BI dashboards, semantic models, DAX measures, and reporting solutions. Perform data quality checks, root-cause analysis, and issue resolution. Manage requirements, testing, documentation, and release activities through Azure DevOps. Collaborate with onshore stakeholders and independently manage offshore deliverables. Required Skills 8-10 years in Data Analytics, BI, or Data Engineering. 3-5 years in Healthcare Payer/Managed Care/Medicare Advantage. Advanced SQL Server and T-SQL expertise. Strong Power BI, DAX, and Power Query experience. Data validation, reconciliation, auditability, and reporting automation. Excellent analytical, documentation, and communication skills. Preferred Skills Medicare Part C/D, Appeals, Grievances, Prior Authorization, CMS reporting. SSIS, Azure Data Factory, Snowflake, Databricks, or Python. Tableau/SSRS to Power BI migration experience. Git/Azure Repos and Agile delivery practices. HIPAA and PHI data governance experience. Success Criteria Accurate and timely reporting delivery with minimal defects. Increased automation and reduced manual effort. Strong ownership, documentation, and audit readiness. Compliance with data governance, privacy, and release standards.