Associate Data Architect I

UST; Thiruvananthapuram; Remote; INR 1,200,000 - 1,800,000; Full time

Job summary

UST is seeking a Senior Data Analyst to support healthcare regulatory and compliance analytics for a US-based payer client from offshore India. The role emphasizes SQL development, data quality, reporting automation, and Power BI reporting, collaborating with onshore teams to deliver auditable and automated reporting solutions.

The candidate will build ETL/ELT processes, perform data validations, and contribute to regulatory reporting with HIPAA-aligned governance.

Qualifications

• 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.

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.

Skills

SQL Server

Power BI

DAX

Power Query

Data validation

Auditability

Documentation

Communication

Agile delivery

Tools

SSIS

Azure Data Factory

Snowflake

Databricks

Python

Tableau/SSRS to Power BI

Git/Azure Repos

Job description

Role Description 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.

Role Description 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. Skills SQL Server Integration Services, Reporting and Analytics, Medicare Advantage, Microsoft SQL Server, SQL Server Reporting Services, PHI Data Governance