Jobs by Fastorial
Back to all jobs

Data and Information Architect

0 views
Santan IntellectChennaiOnsite

8-13 years

Posted 6 days ago

  • Azure
  • MySQL
  • Python
  • SQL Server

About the Role

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 and 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 and 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, and Physical models for Claims, Eligibility, Membership, Provider, Encounter, Clinical data.
  • 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 and 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, and monthly healthcare cycles.

4. Reporting and Analytics Architecture

  • Architect reporting solutions using SSRS, Power BI, and 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 and 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 and 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.

Requirements

  • Bachelor's or Master's in Computer Science, IT, or related field.
  • 8+ years in SQL Server, ETL, and Reporting, with 3+ years in US Healthcare data architecture.
  • Core expertise in 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.
  • Knowledge of US Healthcare standards: HL7, FHIR, EDI X12, ICD-10, CPT, HCPCS, Claims, Membership, Provider, Clinical data, HIPAA, HEDIS, CMS, Risk Adjustment.

Nice 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 and Reconciliation.