17 Nov
|
Santan Intellect
|
Chennai
17 Nov
Santan Intellect
Chennai
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 contemporary 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
📌 Data and Information Architect (Chennai)
🏢 Santan Intellect
📍 Chennai