Solution Architect II

HCA Healthcare; Nashville (TN); On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

Medical benefits

Vision and dental coverage

401(k) with company match

Tuition assistance

Employee stock purchase plan

Job summary

HCA Healthcare is seeking a Solution Architect II in Nashville to lead data solutions across enterprise systems. The role partners with business leaders and ITG to design, document, implement, and support ETL, data mapping, and reporting platforms.

You will work with offshore teams while maintaining clear onshore guidance and accountability. The position emphasizes data quality, governance, and scalable architecture, requiring strong SQL, ETL, and data modeling skills, with collaboration across

Qualifications

• Bachelor's Degree in Information Systems is required.
• 3+ years in data engineering, ETL/ELT, or data warehousing.
• Strong SQL across SQL Server, Teradata, PostgreSQL, BigQuery, or similar platforms with complex queries.
• Experience extracting and migrating data from Teradata, SQL Server, file-based sources, and GCP Datamarts into GCP-based data platforms.
• Experience with batch processing, job scheduling, error handling, logging, data validation, and production support.
• Strong analytical, troubleshooting, and communication skills with ability to work with technical and business teams.

Responsibilities

• Partner with business leaders, product management, and ITG partners during core business hours to understand goals and data needs.
• Lead discovery sessions to clarify problems and document data flows and integration needs.
• Translate business requirements into actionable technical specifications and ETL designs.
• Serve as onshore liaison between US stakeholders and global execution teams to ensure clear communication of requirements.
• Create ready-to-build blueprints and handoff docs for offshore teams to reduce ambiguity and accelerate delivery.
• Design and support data, reporting, automation, and integration solutions to improve efficiency and data availability.
• Write and review SQL, stored procedures, and data transformation logic to support operations and reporting.
• Evaluate requests and recommend scalable, secure data and integration solutions aligned with enterprise standards.
• Lead solution design discussions to ensure requirements are achievable and aligned with goals.
• Serve as onshore escalation point for business logic and production support.

Skills

ETL/ELT

Data warehousing

SQL

Python

Data modeling

Stakeholder mgmt

Education

Bachelor's Degree in Information Systems

Tools

SSIS

GCP Datamarts

Teradata

SQL Server

Job description

Experience the HCA Healthcare difference where colleagues are trusted, valued members of our healthcare team. Grow your career with an organization committed to delivering respectful, compassionate care, and where the unique and intrinsic worth of each individual is recognized. Submit your application for the opportunity below: Solution Architect II

Job Summary And Qualifications

The Solution Architect II in HIM Technologies department is technically focused, business-facing position is responsible for partnering directly with business customers, Product Management, department leaders, global execution teams, and ITG partners to design, document, implement, support, and maintain data, reporting, automation, integration, workflow, and ETL solutions across the enterprise.

The Solution Architect II serves as an onshore technical and business solution liaison between US stakeholders and global execution teams. This role is responsible for understanding business goals, operational workflows, regulatory and customer expectations, data needs, reporting requirements, and integration challenges, then translating those needs into clear technical blueprints, ETL strategies, data mappings, data models, source-to-target specifications, and implementation-ready solution designs.

The Solution Architect II can quickly learn and make use of existing solutions as well as research and implement new technologies based on identified areas for improvement. They have an in-depth understanding of the services provided and direction of business and can develop relationships throughout the organization to assist in accomplishing its goals for the company.

The Solution Architect II main function is to provide consulting-level technical leadership and business solution expertise during the discovery, design, development, implementation, support, and maintenance of business-critical data solutions and internally developed applications. This role will help business by providing real-time, onshore engagement during core business hours while ensuring offshore execution teams receive complete, accurate, and technically sound specifications for delivery.

Major Responsibilities

• Partner directly with Business Leaders, Product Management, department leaders, and ITG partners during core business hours to understand business goals, operational workflows, data needs, reporting requirements, integration needs, customer pain points, and technical challenges.
• Lead business and technical discovery sessions to clarify business problems, define current-state and future-state workflows, document data flows, identify integration needs, and determine appropriate ETL, reporting, database, and cloud-based solution approaches.
• Translate complex and sometimes ambiguous business requirements into actionable technical specifications, ETL strategies, data mappings, data models, source-to-target documentation, process flows, acceptance criteria, and implementation-ready design artifacts.
• Serve as the primary onshore technical liaison between US business stakeholders and GLOBAL execution teams, ensuring business intent, data rules, workflow context, technical requirements, and solution designs are accurately communicated and preserved through delivery.
• Create ready-to-build technical blueprints and handoff documentation for offshore engineering teams to reduce ambiguity, minimize rework, avoid time-zone delays, and accelerate delivery velocity.
• Design and support data, reporting, automation, and integration solutions that reduce manual processes, improve organizational efficiency, increase data availability, improve data accuracy, and support Parallon HIM operational goals.
• Design, develop, test, review, and support ETL processes, data extracts, integrations, database objects, reporting datasets, scripts, and automation processes using appropriate technologies and tools.
• Write and review SQL, stored procedures, scripts, data transformation logic, data validation logic, and reconciliation processes to support operational, reporting, and integration needs.
• Evaluate business requests and recommend scalable, supportable, secure, and efficient data, reporting, workflow, and integration solutions aligned with enterprise standards and Parallon HIM business priorities.
• Lead solution design discussions with business and technical partners to ensure requirements are clear, complete, achievable, technically sound, and aligned to organizational goals.
• Serve as an onshore escalation point for business logic, legacy system knowledge, Parallon HIM workflow interpretation, data interpretation, ETL design, data mapping, and production support needs.
• Support root-cause analysis and resolution of data pipeline, integration, reporting, workflow, and production support issues impacting Parallon HIM stakeholders.
• Ensure effective documentation of business requirements, technical designs, data mappings, source-to-target specifications, data dictionaries, process flows, support runbooks, and operational procedures.
• Partner with Product Management to ensure technical delivery aligns with business priorities, product roadmaps, stakeholder commitments, customer expectations, and operational outcomes.
• Research, investigate, and recommend new technologies, tools, and approaches that improve data solution delivery, operational efficiency, technical quality, data accuracy, and customer experience.
• Mentor team members, support offshore execution teams, and provide technical guidance on complex data, integration, reporting, business workflow, and ETL solution delivery.

What qualifications you will need:

EDUCATION

• Bachelor's Degree in Information Systems- Required

Experience

• 3 or more years of experience in data engineering, ETL/ELT development, data warehousing, data integration, or supporting enterprise data platforms, data marts, data lakes, or operational data stores-Required
• Strong hands-on experience designing, developing, maintaining, and troubleshooting production data pipelines using SQL, Python, PowerShell, SSIS, and other ETL/ELT technologies - Required
• Strong SQL experience across SQL Server, Teradata, PostgreSQL, BigQuery, or similar platforms, including complex queries, joins, aggregations, stored procedures, views, functions, performance tuning, and source-to-target validation - Required
• Experience extracting, integrating, and migrating data from Teradata, SQL Server, file-based sources, GCP Datamarts, and other enterprise data sources into GCP-based data platforms - Required
• Experience with batch processing, job scheduling, dependency management, error handling, logging, alerting, data validation, reconciliation, data quality checks, and production support for critical business operations - Required
• Strong analytical, troubleshooting, problem-solving, written communication, and verbal communication skills, with the ability to work independently and collaboratively with technical and business teams - Required

Other Skills & Abilities

• Understanding of HCA Healthcare’s IT organization and its business functions - Preferred
• Ability to determine best practices and articulate authoritative direction - Required
• Knowledge of system architecture - Required
• Knowledge of agile and lean development workflows and the ability to execute within them - Required
• Ability to build relationships, communicate effectively both formally and informally, and advocate for automation across the company - Required
• Ability to determine alignment of new technologies to HCA Healthcare’s strategic roadmap - Preferred
• Ability to teach other team members and other external individuals - Required
• Skill in Utilizing GitHub repositories as code repositories and version control - Required
• Ability to become a trusted advisor, lead projects and programs, be a catalyst for change, drive collaboration among the automation community, and be a thought leader at HCA Healthcare - Required
• Skill in using scripts to execute processes - Required
• Skill in using object-oriented programming - Required

TRAVEL

The job may require travel from time- to-time, but not on a regular basis.

Benefits

• Comprehensive benefits for medical, prescription drug, dental, vision, behavioral health and telemedicine services
• Wellbeing support, including free counseling and referral services
• Time away from work programs for paid time off, paid family leave, long- and short-term disability coverage and leaves of absence
• Savings and retirement resources, including a 401(k) Plan with a 100% match on 3% to 9% of pay (based on years of service), Employee Stock Purchase Plan, flexible spending accounts, preferred banking partnerships, retirement readiness tools, rollover support and financial wellbeing counseling
• Education support through tuition assistance, student loan assistance, certification support, dependent scholarships and a partnership with Galen College of Nursing
• Additional benefits for fertility and family building, adoption assistance, life insurance, supplemental health protection plans, auto and home insurance, legal counseling, identity theft protection and consumer discounts

Learn More About Employee Benefits

Note: Eligibility for benefits may vary by location.

HCA Healthcare has been recognized as one of the World's Most Ethical Companies® by the Ethisphere Institute more than ten times. In recent years, HCA Healthcare spent an estimated $3.7 billion in cost for the delivery of charitable care, uninsured discounts, and other uncompensated expenses.

"There is so much good to do in the world and so many different ways to do it."- Dr. Thomas Frist, Sr.

HCA Healthcare Co-Founder

We are an equal opportunity employer. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.