Santan Intellect logo

Data and Information Architect

Santan Intellect

8 - 13 years

Chennai

Posted:3 days ago

Job Description

Role: Data and Information Architect

Experience:

Role Summary

onsite in Chennai

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

Skills Required

Data modeling Healthcare Healthcare Domain Data architecture Information architecture Modeling SSIS Architecture

Learn the skills this job asks for

Free courses, interview questions and practice for each skill.

Work Mode

Work from Office

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Santan Intellect logo
Santan Intellect

RecommendedJobs for You

Santan Intellect logo

Chennai

Santan Intellect logo

Chennai