Solution Architect II

HCA Healthcare · Nashville, TN · 1 wk ago

On-siteHealthcareFull-time

Job Summary and Qualifications

The Solution Architect II in HIM Technologies department is technically focused, business-facing position 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.

Qualifications

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