Senior Technical Lead
Infinite Computer Solutions · Bengaluru · onsite · Posted 52d ago
Not disclosed5–10 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
Job Description
Job Summary
We are seeking an experienced Data Modeler with strong expertise in the Healthcare Payer domain to design, develop, and maintain enterprise data models that support business intelligence, analytics, regulatory reporting, and operational systems. The ideal candidate will have deep knowledge of healthcare payer data, including claims, membership, providers, benefits, enrollment, and care management, along with strong data modeling and database design skills.
The Data Modeler will collaborate with business stakeholders, data architects, data engineers, and application teams to create scalable conceptual, logical, and physical data models aligned with enterprise data standards.
Key Responsibilities
- Design conceptual, logical, and physical data models for enterprise data platforms.
- Analyze business requirements and translate them into efficient data models.
- Develop and maintain enterprise data dictionaries, metadata, and data lineage.
- Model healthcare payer subject areas including:
- Member/Enrollment
- Claims (Medical, Pharmacy, Dental)
- Provider
- Benefits
- Eligibility
- Authorization
- Care Management
- Customer Service
- Finance
- Premium Billing
- Ensure data models support operational systems, data warehouses, data lakes, and cloud platforms.
- Collaborate with ETL/ELT developers to ensure proper implementation of data models.
- Establish naming conventions, modeling standards, and governance practices.
- Perform impact analysis for data model changes.
- Optimize models for performance, scalability, and maintainability.
- Support data quality, master data management (MDM), and metadata management initiatives.
- Participate in architecture reviews and solution design discussions.
- Document business rules, relationships, and data definitions.
- Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.
- 5+ years of experience in data modeling.
- 3+ years of experience in the Healthcare Payer industry.
- Strong understanding of healthcare payer business processes.
- Experience with conceptual, logical, and physical data modeling.
- Strong SQL skills.
- Experience designing normalized and dimensional data models.
- Experience with relational databases such as Oracle, SQL Server, PostgreSQL, or DB2.
- Experience with cloud data platforms such as Snowflake, Azure Synapse, AWS Redshift, or Google BigQuery.
- Knowledge of data warehousing concepts and ETL processes.
- Familiarity with Agile/Scrum methodologies.
- Experience with Healthcare Data Models such as:
- Claims Processing
- Enrollment Systems
- Provider Management
- Utilization Management
- Care Management
- Experience with healthcare interoperability standards:
- HL7
- FHIR
- X12 EDI (837, 835, 834, 270/271, 276/277)
- Knowledge of regulatory requirements including:
- HIPAA
- CMS
- HEDIS
- NCQA
- Medicare
- Medicaid
- ACA
- Experience with Data Vault, Kimball, or Inmon methodologies.
- Experience working with Master Data Management (MDM).
- Knowledge of Data Governance frameworks.
- Data Modeling Tools
- ERwin Data Modeler
- ER/Studio
- SAP PowerDesigner
- Oracle SQL Developer Data Modeler
- Databases
- Oracle
- SQL Server
- PostgreSQL
- DB2
- MySQL
- Cloud Platforms
- AWS
- Azure
- Google Cloud Platform
- Data Warehouse
- Snowflake
- Redshift
- Synapse
- BigQuery
- ETL Tools
- Informatica
- Talend
- SSIS
- DataStage
- dbt
- Query Languages
- SQL
- PL/SQL
- Version Control
- Git
- Azure DevOps
The candidate should have experience with:
- Member enrollment and eligibility
- Provider networks and credentialing
- Medical claims processing
- Pharmacy claims
- Benefits administration
- Prior authorization
- Appeals and grievances
- Care management
- Risk adjustment
- Premium billing
- Value-based care
- Medicare Advantage
- Medicaid Managed Care
- Commercial Health Plans
- HEDIS quality reporting
- CMS reporting
- HIPAA compliance
- Certified Data Management Professional (CDMP)
- Azure Data Engineer Associate
- AWS Certified Data Analytics
- Snowflake SnowPro Certification
- Healthcare certifications are a plus.
- Excellent analytical and problem-solving skills.
- Strong communication and stakeholder management.
- Ability to work cross-functionally with business and technical teams.
- Strong documentation skills.
- Ability to manage multiple priorities in a fast-paced environment.
- Enterprise Data Modeling
- Dimensional Modeling
- Data Warehouse Design
- Healthcare Payer Data Architecture
- Metadata Management
- Data Governance
- SQL Optimization
- Cloud Data Platforms
- Data Integration
- Business Analysis
- Regulatory Compliance
- Data Quality
Sourced from foundit
Skills
relational databasesMetadata ManagementCloud Data PlatformsSQLData WarehousingData GovernanceETLData Modeling
About Infinite Computer Solutions
Infinite Computer Solutions
IT Services & Consulting
15k+
employees
2001
25 years old
Bangalore / Bengaluru, Karnataka
India
About
A global leader in IT and digital engineering services, emphasizing cloud and AI to deliver impactful solutions across various sectors.
Industries
IT Services & ConsultingSoftware Product
Employee ratings
2,096 reviews
3.2/ 5
Culture
3.0
Career growth
2.8
Work-life
3.3
Employees rate it well for
Work Life Balance214Salary198Senior Management188Work Culture165Job Security159
Find them on