Consultant - Data Modeler

HCA Healthcare - India; Hyderabad; On-site; INR 1,500,000 - 2,600,000; Full time

Job summary

HCA Healthcare - India is seeking an experienced Data Modeler to design and implement scalable data models on Google Cloud, transforming raw data into actionable insights and aligning with enterprise goals.

The role requires mastery of logical data modeling, data governance, and collaboration with Data Product Owners and data engineers to deliver robust, secure architectures that support analytics, ML, and enterprise data management.

Qualifications

• Bachelor's degree in Computer Science or a related field.
• Master's degree in Computer Science or related field preferred.
• 7+ years of experience in data management, data products, or analytics.

Responsibilities

• Architect and oversee enterprise-wide data modeling initiatives.
• Lead the development of scalable data models for enterprise applications.
• Develop and enforce data modeling standards and frameworks for the organization.
• Work with stakeholders to implement data governance and security controls.
• Perform advanced data analysis to inform design decisions and ensure alignment with business needs.
• Collaborate with data engineers to implement complex models.
• Define data transformation requirements and implement efficient solutions.
• Oversee cloud data architecture across multiple business domains.

Skills

Data Modeling

SQL

Cloud Architecture

Data Governance

ETL/ELT

Google Cloud

Data Analysis

Data Warehousing

Security & Compliance

Stakeholder Collaboration

Education

Bachelor's degree in Computer Science

Master's degree in CS or related field

Tools

BigQuery

Looker

Informatica

ETL Tools

Airflow

Job description

Job Description:

General Position Information

Reports directly to (Title): Manager

Matrix reports to (Title): As applicable based on functional alignment

Direct Reports: No

Position Summary

HCA Healthcare is looking for an experienced and innovative Data Modeler to lead the design and implementation of scalable, secure, and high-performance data products on Google Cloud. In this role, you will be at the forefront of transforming raw data into actionable insights by creating robust architectures that integrate seamlessly into our enterprise ecosystem.

The Data Modeler will play a critical role in bridging the gap between business needs and technical solutions. You will work closely with Data Product Owners to understand product requirements, ensure alignment with business goals, and design solutions that meet operational and analytical needs.

This position requires a deep understanding of the architecture of business data source systems, their structures, communication protocols, and interfaces. The ideal candidate will demonstrate a mastery of data analysis, logical data modeling, and the ability to identify opportunities for data reuse and transformation. You will design data architectures that address gaps, optimize performance, and enforce enterprise standards in cybersecurity, governance, and compliance.

As a key contributor to HCA’s data strategy, you will also develop and maintain a comprehensive data architecture roadmap, ensuring alignment with business priorities and evolving technology trends. By integrating advanced analytics and machine learning capabilities, you will help HCA Healthcare maximize the value of its data to improve clinical outcomes and operational efficiency.

Responsibilities

Data Analysis & Logical Modeling

• Architect and oversee enterprise-wide data modeling initiatives
• Lead the development of scalable data models for enterprise applications
• Develop and enforce best practices for schema evolution and data interoperability
• Define data modeling standards and frameworks for the organization
• Work with stakeholders to implement data governance and security controls
• Perform advanced data analysis to inform design decisions and ensure alignment with business needs.
• Create logical data models or object models of moderate complexity to address business challenges.
• Develop data modeling automation frameworks to enhance consistency
• Implement advanced metadata management and data quality monitoring
• Define data transformation requirements and implement efficient solutions.
• Implement enterprise data management practices, standards, and frameworks for Data Integration
• Ensure data governance and security best practices are followed
• Participate in code reviews and provide feedback on SQL queries and ETL pipelines
• Build automated validation processes for data integrity checks

Collaboration with Data Product Owners

• Partner with Data Product Owners to gather and refine requirements for data products.
• Work with senior leaders to define enterprise data strategy
• Translate business needs into technical designs that align with organizational goals.
• Drive adoption of standardized data modeling frameworks
• Conduct stakeholder meetings to review and validate data models
• Work closely with data engineers to implement complex models
• Advocate for data quality and integrity across all projects

Business System Architecture Knowledge

• Demonstrate expertise in core business applications and support systems.
• Understand and apply communication protocols and interfaces used by business systems to enable efficient data integration.
• Ensure high availability and scalability in data models
• Evaluate the adoption of modern data storage and processing paradigms
• Oversee cloud data architecture across multiple business domains
• Evaluate and recommend new data modeling tools and technologies
• Optimize cloud data structures for performance and scalability.
• Translate project-specific requirements into a cloud structure that meets those requirements, as well as taking into account the project’s resource use and scalability requirements.

Identifying & Addressing Data Gaps

• Assess and identify gaps in data architecture, systems, and workflows.
• Optimize data models for performance.
• Establish guidelines for schema evolution and data interoperability
• Recommend and implement changes to improve data quality, accessibility, and consistency.

Data Product Design & Integration

• Design schemas and structures for data products that are robust, scalable, and secure.
• Integrate data products with business systems, workflows, and analytical tools.
• Ensure data products are optimized for machine learning, real-time analytics, and other advanced use cases.
• Work closely with individuals across the technology organizations to help promote awareness of the data architecture and ensure that enterprise assets of competence are leveraged.
• Identify the best cloud architecture options to help the firm accomplish its strategic goals.
• Good understanding of cloud computing concepts

Enterprise Standards & Governance

• Maintain and enforce enterprise data architecture guidelines, including data governance, cybersecurity, metadata management, and auditability.
• Define best practices for schema versioning and evolution
• Establish enterprise data governance policies
• Work with security teams to define data access control policies
• Collaborate with governance teams to enhance metadata management
• Enforce enterprise-wide data modeling standards
• Collaborate across various verticals to ensure compliance and data quality.

Strategic Roadmapping

• Work with senior member of the team and establish data architecture roadmap aligned with HCA’s strategic priorities.
• Continuously evolve the architecture to address emerging technologies and business requirements.

Other

• Performs other duties as assigned
• Practices and adheres to the “Code of Conduct” philosophy and “Mission and Value Statement.”

Education & Experience

• Bachelor's degree Computer Science or a related field - Required
• Master's degree Computer Science or a related field. - Preferred
• 7+ years of experience in data management, data products, or analytics. - Required

Knowledge, Skills, Abilities, Behaviors

• Service and Quality Excellence: Ability to demonstrate an uncompromising commitment to delivering exceptional care to create an unmatched value proposition for our patients. - Required
• Honor our Mission and Values: Ability to build trust and act with authenticity to cultivate a culture of integrity, inclusion, and mutual respect. - Required
• Effective Decision Making: Ability to make timely, informed decisions that are in the best interest of our patients, employees, providers, community and HCA. - Required
• Attain and Leverage Strategic Relationships: Ability to develop and strengthen collaborative relationships with both internal and external stakeholders to advance the care of our patients and the growth of HCA. - Required
• Lead and Develop Others: Ability to lead others to accomplish organizational goals and objectives; provide meaningful coaching and mentoring to increase the capabilities of individuals and teams and drive employee engagement. - Required
• Communicate with Impact: Ability to deliver information in a clear, concise, and compelling manner to effectively engage others and achieve desired results. - Required
• Achieve Success through Change: Ability to identify opportunities for improvement and innovation, remove barriers and resistance, and enable desired behaviors. - Required

Requirements: