Solution Architect II

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.

Bachelor’s Degree in Information Systems- Required, 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

HCA Healthcare, offers a total rewards package that supports the health, life, career and retirement of our colleagues. The available plans and programs include:

• 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 (https://careers.hcahealthcare.com/pages/employee-benefits-and-rewards)

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.