> Markdown version of [/jobs/ext/2079531-solution-architect-ii](https://www.wearedevelopers.com/jobs/ext/2079531-solution-architect-ii). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Solution Architect II - **Company:** HCA Healthcare Inc. - **Location:** Nashville, TN, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Data Analysis, Business Logic, Batch Processing, BigQuery, Information Systems, Databases, Data Validation, Data Dictionary, Information Engineering, Data Integration, Extract Transform Load (ETL), Data Mapping, Data Mart, Data Transformation, Data Migration, Data Systems, Data Warehousing, Database Queries, Database Schema, Document-Oriented Databases, Github, Job Scheduling, Python (Programming Language), PostgreSQL, Microsoft SQL Server, Operational Data Store, Object-Oriented Software Development, Operational Databases, Performance Tuning, Windows PowerShell, Standard Sql, SQL Stored Procedures, SQL Databases, SQL Server Integration Services, Systems Architecture, Systems Integration, Teradata SQL, Enterprise Data Management, Data Logging, Software Repository, Data Lakes, Data Management, Software Version Control, Data Pipelines - **Published:** August 16, 2026 - **Apply:** https://dejobs.org/x/x/65FB2C7661684E05B4E80E2928C2A53F/job/ ## About the Role 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 ## Description 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. ## Related Videos - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [7 Important Tips That Every Software Developer Should Know](https://www.wearedevelopers.com/magazine/101-7-important-tips-that-every-software-developer-should-know) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)