Technical Architect

CSpring•Springfield, IL

About The Position

CSpring is seeking a Technical Architect to provide hands-on architecture and engineering leadership for enterprise data warehousing, reporting, and analytics modernization. The role owns end-to-end application and technical architecture for reporting, analytics, data integration, and transaction-based processing across on-premises platforms and future cloud services. It translates business, operational, and regulatory needs into maintainable designs and leads the modernization of legacy ETL, SQL, scripts, and manual processes into Python applications and automation. The Technical Architect provides leadership throughout architecture, development, code review, testing, deployment, performance tuning, and production support. The role defines architecture across user interfaces, APIs and services, processing engines, databases, orchestration, security, monitoring, and recovery; leads BI and analytics delivery; and establishes engineering practices and appropriate AI-enabled automation. It also produces technical and operational documentation, mentors multidisciplinary teams, and presents options, risks, and recommendations to customer stakeholders and Optum leadership.

Requirements

Bachelor’s degree in computer science, engineering, information systems, or a related field, or equivalent professional experience.
10 or more years of information technology experience, including senior-level application, solution, technical, or data architecture for large enterprise systems.
Proven experience architecting enterprise data warehouse, reporting, analytics, and claims or transaction-processing solutions from the ground up, including architecture, infrastructure, design, development, proof-of-concept, testing, implementation, and support.
Hands-on development experience with Python and advanced SQL, including automation, data processing, troubleshooting, and code review.
Experience designing application architecture, including APIs, services, web components, databases, security, identity and access, job scheduling, monitoring, and environment management.
Hands-on BI/reporting experience with BusinessObjects, Power BI, Tableau, SAS, or comparable enterprise reporting tools.
Experience implementing source control, branching, pull requests, CI/CD, and automated deployment in Azure DevOps or a similar platform.
People leadership experience leading BI, data, and engineering staff.
Strong written, verbal, and presentation skills for customer and executive audiences.

Nice To Haves

Healthcare payer, Medicaid, managed care, or health-insurance experience, including claims, adjustments, voids, eligibility, providers, payments, and regulatory reporting data.
Federal reporting experience, especially CMS-64, quarterly expenditure reporting, reconciliation, certification, or related state Medicaid reporting.
On-premises-to-cloud migration experience with Microsoft Azure, Azure Data Factory, Databricks, Data Lake Storage, Snowflake, or comparable cloud data services.
ETL/ELT and data engineering experience with Informatica, Teradata, or comparable enterprise integration and large-scale MPP data warehouse platforms.
Experience applying AI-assisted engineering or automation to code conversion, source-to-target mapping, testing, documentation, and data-quality activities within enterprise governance.
Data modeling across conceptual, logical, and physical models; effective-dated reference data; dimensional models; and transaction lineage.
Experience with Linux/Unix scripting and job orchestration.
Knowledge of HIPAA, PHI, PII, security architecture, and public-sector compliance expectations.
Advanced degree or relevant architecture, cloud, data, or agile certifications.

Responsibilities

Own end-to-end application and technical architecture for reporting, analytics, data integration, and transaction-based processing solutions across on-premises platforms and future cloud services.
Translate business, operational, and regulatory requirements into maintainable system designs, including configurable business rules, effective-dated reference data, traceability, auditability, and reconciliation.
Modernize legacy ETL, SQL logic, Linux/Unix scripts, and manual processing into Python-based applications and automation, using enterprise data platforms efficiently for high-volume processing.
Provide hands-on technical leadership across architecture, development, code review, testing, deployment, performance tuning, and production support.
Build proof-of-concepts comparing solution options, document measurable results, and support architecture decisions with customers and leadership.
Define technical architecture across web/UI, API and service layers, processing engines, databases, orchestration, scheduling, security, identity and access, monitoring, and backup and recovery, in partnership with infrastructure, security, cloud, and data peers.
Lead BI and analytics delivery, including enterprise report design, drill-down and detail reporting, reconciliation, data quality, and modernization of legacy reporting capabilities.
Establish engineering practices using Azure DevOps or an equivalent platform, including epics and user stories, repositories, branching, pull requests, code review, CI/CD, release traceability, and production deployment.
Apply AI and automation with appropriate governance to accelerate analysis, conversion, documentation, and testing.
Produce architecture diagrams, solution designs, technical specifications, dataflow and interface documentation, roadmaps, estimates, risk documentation, and operational support models.
Lead and mentor architects, data engineers, ETL and BI developers, modelers, analysts, and testers; build backup coverage and develop team capability.
Present architecture, options, risks, and recommendations to customer stakeholders and Optum leadership, creating clarity across ambiguous scope, legacy constraints, and accelerated timelines.