Consultant - Data Modeler

At HCA Healthcare, Digital Transformation & Innovation brings advanced engineering together with our commitment to the care and improvement of human life. HCA Healthcare - India is helping shape the next generation of healthcare technology through artificial intelligence, modern data platforms, cloud-based services, intelligent automation and secure digital experiences built for real healthcare environments. Our teams solve complex challenges where trust, reliability, privacy and speed matter. We turn data into insights, improve workflows through intelligent products, and develop responsible AI solutions that help clinicians, care teams and operational teams serve patients. From India, you will help move technology beyond experimentation and into production. You will build solutions designed to perform reliably, protect sensitive information and deliver measurable healthcare impact. This is technology with purpose — built to perform, designed for trust and focused on improving healthcare. 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. Major 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. Enter any content that you want to repeat, including other content controls. You can also insert this control around table rows in order to repeat parts of a table. Enter any content that you want to repeat, including other content controls. You can also insert this control around table rows in order to repeat parts of a table. · 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 Or equivalent combination of education and/or experience Licenses, Certifications, & Training: • Choose an item. Preferred Physical Demands Check the frequency of activity required of the employee to perform the essential functions of the job (non-inclusive list). Activity: (Hours / Day) Rarely (Up to 3 Hours) Occasionally (3+ Hours) Frequently (6+ Hours) Routinely (8+ Hours) 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 · Drive Execution and Financial Results : Ability to commit to the success and financial wellbeing of HCA by challenging others to excel and hold themselves and others accountable for achieving results. Required Balancing ☒ ☐ ☐ ☐ Bending ☒ ☐ ☐ ☐ Climbing ☒ ☐ ☐ ☐ Color Vision ☒ ☐ ☐ ☐ Crawling ☒ ☐ ☐ ☐ Driving ☒ ☐ ☐ ☐ Handling ☐ ☐ ☒ ☐ Reaching ☐ ☐ ☒ ☐ Sitting ☐ ☐ ☒ ☐ Standing ☐ ☐ ☒ ☐ Typing ☐ ☐ ☒ ☐ Walking ☐ ☐ ☒ ☐ Work at elevated levels (work at higher levels, on the roof) ☒ ☐ ☐ ☐ Activity: (Hours / Day) Max Weight (In Pounds) Rarely (Up to 3 Hours) Occasionally (3+ Hours) Frequently (6+ Hours) Routinely (8+ Hours) Lift / Carry 10 lbs. or less ☒ ☐ ☐ ☐ Push / Pull 10 lbs. or less ☒ ☐ ☐ ☐ Travel Required Check the frequency of travel required of the employee to perform the essential functions of the job. ☐ No Travel: The job does not require any travel. ☒ Occasional Travel: The job may require travel from time- to-time, but not on a regular basis. ☐ The job may require up to 25% travel. ☐ The job may require up to 50% travel. ☐ The job may require up to 75% travel. ☐ The job may require 76% or more travel. Knowledge, Skills, Abilities, Behaviors: · Extensive experience in designing data models for large-scale systems · Expertise in GCP architecture and BigQuery · Expertise in SQL optimization and data modeling techniques · Ability to write, tune, and interpret SQL queries. · Strong experience with version control systems · Strong ability to present complex technical concepts to leadership · Extensive experience in architecture, construction, and implementation of data-intensive solutions · Strong understanding of metadata management and data cataloging · Adeptness to learn new assignments, technologies and applications quickly and manage multiple assignments simultaneously · Ability to troubleshoot, maintain, reverse engineer and optimize existing ETL pipelines. · Hands-on experience with Python, Dataflow and Cloud Composer · Ability to analyze and interpret complex data, and offer solutions to complex clinical problems. · Ability to work independently on assigned tasks. · Strong written and verbal communication skills including the ability to explain complex technical issues in a way that non-technical people may understand. · Excellent problem-solving and critical thinking skills. · Knowledge of IT governance and operations.