Data and Information Architect

Santan Intellect

Chennai

On-site

INR 3,200,000 - 5,200,000

Full time

7 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Santan Intellect seeks an experienced Data and Information Architect to be onsite in Chennai, designing enterprise data architecture for US Healthcare clients. The role blends hands-on SQL/MSBI expertise with architecture, modeling, and governance to build scalable platforms for Claims, Membership, Provider, Clinical, and Financial data while ensuring HIPAA compliance and reporting accuracy.

You will be the onsite architecture owner in Chennai, working directly with US stakeholders and leading

Qualifications

  • Bachelor's or Master's degree in CS/IT or a related field.
  • 8+ years of SQL Server, ETL, reporting experience; 3+ years in US healthcare data architecture.

Responsibilities

  • Own end-to-end Data Architecture from Chennai office—DW, Data Lake, ODS, data marts for US healthcare.
  • Define enterprise data models for Claims, Eligibility, Membership, Provider, Clinical data.
  • Design data integration using SSIS, SQL Server, and modern ETL/ELT patterns.
  • Define data standards, lineage, metadata management, naming conventions.
  • Architect solutions for large-scale, high-volume batch processing.
  • Lead onsite architecture reviews and mentor developers.
  • Ensure HIPAA, HITRUST, CMS compliance in data storage, masking and auditing.
  • Collaborate with US stakeholders and offshore data team; create architecture diagrams and blueprints.

Skills

SQL Server
MySQL
T-SQL
SSIS
SSRS
MSBI
Data Modeling
Data Vault
Erwin
ER Studio
HL7
FHIR
HIPAA
ETL/ELT
Power BI

Education

Bachelor's / Master's in Computer Science, IT, or related field

Tools

Power BI
Azure Data Factory
Azure Synapse
Databricks
Snowflake
JasperReports
iReport
SQL Agent
Control-M
Autosys

Job description

Role: Data and Information Architect

Experience: 8+ Years
Location: Chennai, Tamil Nadu, India - Onsite
Domain: US Healthcare
Background: SQL Server, SSIS, SSRS, MSBI

Role Summary

We are looking for a Data and Information Architect to work onsite in Chennai and design enterprise data architecture for US Healthcare clients. The role blends hands-on SQL / MSBI expertise with architecture, modeling, and governance - building scalable platforms for Claims, Membership, Provider, Clinical, and Financial data while ensuring HIPAA compliance and reporting accuracy.

You will be the onsite architecture owner in Chennai, working directly with US-based stakeholders, and leading the offshore data engineering team.

Key Responsibilities
1. Data Architecture & Design - Onsite Ownership
  • Own end-to-end Data Architecture from Chennai office - Data Warehouse, Data Lake / Lakehouse, ODS, Data Marts for US Healthcare
  • Define Enterprise Data Model - Conceptual / Logical / Physical models for Claims, Eligibility, Membership, Provider, Encounter, Clinical
  • Design data integration architecture using SSIS, SQL Server, and modern ETL/ELT patterns
  • Define data standards, naming conventions, data lineage, and metadata management
  • Architect solutions for large-scale, high-volume batch processing
2. US Healthcare Domain
  • Work with HIPAA, PHI/PII, HL7, FHIR, EDI X12 (837P/I, 835, 834, 270/271), ICD-10, CPT, HCPCS, NDC, HEDIS, CMS
  • Design solutions for Claims Adjudication, Enrollment, Provider Network, Utilization Management, Risk Adjustment (HCC), Quality Measures
  • Ensure HIPAA, HITRUST, and CMS compliance in data storage, access, masking, and auditing
3. ETL / Data Integration - SSIS & SQL
  • Architect and review complex SSIS packages, Stored Procedures, and data pipelines for Claims and Clinical data
  • Design Data Validation, Reconciliation, and Data Quality frameworks - claim counts, paid amounts, member counts, source-to-target balancing
  • Optimize SQL Server performance - Indexing, Partitioning, Query Tuning for multi-million row datasets
  • Design Job Monitoring, Scheduling, Error Handling, and Automation for daily / weekly / monthly healthcare cycles
4. Reporting & Analytics Architecture
  • Architect reporting solutions using SSRS, Power BI, iReport for operational, financial, and regulatory reporting
  • Define semantic models, KPIs - PMPM, Utilization Rate, Denial Rate, Readmission Rate, STAR Ratings, HEDIS Compliance
  • Design governed data marts and self-service BI for business users
  • Ensure report accuracy through reconciliation and audit trails
5. Data Governance, Security & Production Support
  • Define Data Governance - Data Ownership, Data Quality, Master Data Management (MDM) for Member / Provider / Payer
  • Design role-based access, data masking, encryption, and audit logging for PHI data
  • Provide L3 architectural support for production issues - performance, data discrepancies, job failures
  • Lead Root Cause Analysis and implement long-term fixes
6. Onsite Leadership & Stakeholder Management
  • Work onsite in Chennai as Lead Architect, leading design reviews, architecture boards, and mentoring developers
  • Collaborate daily with US Product Owners, Business Analysts, Compliance, and QA teams
  • Create Architecture Diagrams, HLD/LLD, Data Flow Diagrams, and Solution Blueprints
  • Coordinate onsite-offshore delivery and ensure SLA adherence
Technical Skills Required
Core:
  • SQL Server, MySQL, T-SQL - Advanced Stored Procedures, Performance Tuning
  • SSIS - Enterprise ETL Design, SSRS - Report Development, MSBI Stack
  • Data Modeling - Erwin / ER Studio / Visio, Dimensional Modeling, Data Vault
Healthcare:
  • HL7, FHIR, EDI X12, ICD-10, CPT, HCPCS
  • Claims, Membership, Provider, Clinical Data
  • HIPAA, HEDIS, CMS, Risk Adjustment
Good to Have:
  • Azure Data Factory, Azure Synapse, Databricks, Snowflake, Power BI
  • Python, HTML, iReport / JasperReports
  • Job Scheduling - SQL Agent, Control-M, Autosys
  • Production Support (L2/L3), Data Validation & Reconciliation
Qualifications
  • Bachelor's / Master's in Computer Science, IT, or related field
  • 8+ years in SQL Server, ETL, Reporting, with 3+ years in US Healthcare data architecture
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Architect
Data Architect

enGen Global • Chennai

On-site
INR 1,500,000 - 2,100,000
Advisor / Senior Advisor - Data Architect
Advisor / Senior Advisor - Data Architect

enGen Global • Hyderabad, Chennai

On-site
INR 3,500,000 - 5,500,000
Data Delivery Leads / Data Architects - Manager Healthcare/Pharma/Life
Data Delivery Leads / Data Architects - Manager Healthcare/Pharma/Life

PwC • Kolkata, Hyderabad, Bengaluru

Hybrid
INR 1,800,000 - 3,200,000
Architect - Data
Architect - Data

Quantiphi Analytics Solutions Private Limited • Mumbai

Hybrid
INR 2,000,000 - 2,800,000
Senior Consultant - Data Integration Developer
Senior Consultant - Data Integration Developer

enGen Global • Chennai

On-site
INR 1,200,000 - 2,200,000
Data Engineer
Data Engineer

Mango Sciences India • Mumbai, Delhi, Bengaluru

Remote
INR 2,400,000 - 4,200,000
Solution Architect - Healthcare
Solution Architect - Healthcare

Genzeon • Hyderabad

On-site
INR 3,500,000 - 7,000,000
Solution Architect - Healthcare
Solution Architect - Healthcare

Genzeon Global • Hyderabad

On-site
INR 3,500,000 - 6,000,000
3877036-Assistant Manager
3877036-Assistant Manager

ExlService Holdings, Inc. • Chennai

On-site
INR 1,500,000 - 2,500,000
Senior - Data Engineer
Senior - Data Engineer

HCA Healthcare, Inc. • Hyderabad

On-site
INR 1,500,000 - 2,100,000