Technical Architect

Posted 10hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Technical Architect modernizing enterprise data warehouses, reporting, and analytics for CSpring, a data strategy and analytics consulting firm. Leading Python, SQL, BI, cloud, and engineering modernization.

Responsibilities:

  • Own end-to-end application and technical architecture for reporting, analytics, data integration, and transaction-based processing solutions
  • Translate business, operational, and regulatory requirements into maintainable system designs
  • Design and lead modernization of legacy ETL, SQL logic, Linux/Unix scripts, and manual processing into Python-based applications and automation
  • Provide hands-on technical leadership across architecture, development, code review, testing, deployment, performance tuning, and production support
  • Build proof-of-concepts comparing solution options and document measurable results
  • Define technical architecture across web/UI, API and service layers, processing engines, databases, orchestration, scheduling, security, identity/access, monitoring, and backup/recovery
  • Lead BI and analytics delivery, including enterprise report design, drill-down and detail reporting, reconciliation, data quality, and legacy reporting modernization
  • Establish engineering practices using Azure DevOps or equivalent, including epics, 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, risks, and operational support models
  • Lead and mentor architects, data engineers, ETL and BI developers, modelers, analysts, and testers
  • Present architecture, options, risks, and recommendations to customer stakeholders and Optum leadership

Requirements:

  • Bachelor’s degree in computer science, engineering, information systems, or related field, or equivalent professional experience
  • 10+ years of information technology experience
  • Senior-level application, solution, technical, or data architecture experience for large enterprise systems
  • Experience architecting enterprise data warehouse, reporting, analytics, and claims or transaction-processing solutions from the ground up
  • Hands-on development experience with Python and advanced SQL
  • Experience with automation, data processing, troubleshooting, and code review
  • Experience designing application architecture including APIs, services, web components, databases, security, identity/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
  • Healthcare payer, Medicaid, managed care, or health-insurance experience is a bonus
  • Federal reporting experience, especially CMS-64, quarterly expenditure reporting, reconciliation, certification, or related state Medicaid reporting, is a bonus
  • On-premises to cloud migration experience with Microsoft Azure, Azure Data Factory, Databricks, Data Lake Storage, Snowflake, or comparable cloud data services is a bonus
  • ETL/ELT and data engineering experience with Informatica, Teradata, or comparable enterprise integration and large-scale MPP data warehouse platforms is a bonus
  • Experience applying AI-assisted engineering or automation to code conversion, source-to-target mapping, testing, documentation, and data-quality activities within enterprise governance is a bonus
  • Data modeling across conceptual, logical, and physical models, effective-dated reference data, dimensional models, and transaction lineage is a bonus
  • Linux/Unix scripting and job orchestration experience is a bonus
  • Knowledge of HIPAA, PHI, PII, security architecture, and public-sector compliance expectations is a bonus
  • Advanced degree or relevant architecture, cloud, data, or agile certifications is a bonus

Benefits:

  • Purposeful projects improving systems that serve real people
  • People-first culture with support, autonomy, and community
  • Growth opportunities
  • Meaningful work and purpose
  • Collaborative work environment
  • Hands-on strategic work and client workshops
  • Opportunity to influence architecture, delivery, and solution decisions