Solution​/Data Architect

Solution / Data Architect Role Type

Contract

ONSITE

12-15

Own end-to-end application and technical architecture for reporting, analytics, data integration, and transaction-based processing solutions across legacy on-premises platforms and future cloud services.

Lead the Federal Reporting / CMS-64 modernization from current-state discovery through target architecture, proof-of-concept, implementation, testing, deployment, operational readiness, and knowledge transfer.

Translate federal reporting and Medicaid claims requirements into maintainable system designs, including configurable business rules, effective-dated reference data, transaction traceability, auditability, reconciliation, and regulatory outputs.

Design and evaluate modernization approaches for converting Informatica workflows, SQL logic, Linux/Unix scripts, and manual processing into Python-based applications and automation while using Teradata efficiently for high-volume processing.

Provide hands‑on leadership for complex technical tasks. Develop or review Python, SQL, Informatica, ETL/ELT, API, web, configuration, data‑processing, and automation components as needed to unblock the team.

Design proof‑of‑concepts that compare solution options, document measurable results, and support architecture decisions with the customer and leadership.

Define technical system architecture across web/UI, API and service layers, processing engines, databases, orchestration, scheduling, security, identity/access, logging, monitoring, backup/recovery, and disaster recovery.

Partner with infrastructure, security, UI, database, cloud, engineering, BI, QA, product, and business architects to review designs and confirm capacity, scalability, licensing, configuration, deployment, and support ownership.

Guide BI and federal reporting delivery, including report design, drill‑down/detail reporting, reconciliation, data quality, and migration or modernization of legacy Business Objects or equivalent reporting capabilities.

Establish and reinforce engineering practices using Azure Dev Ops or equivalent tools for epics, features, user stories, repositories, branching, pull requests, code review, versioning, CI/CD, release traceability, and production deployment.

Use AI and automation appropriately to accelerate code analysis, source-to-target mapping, documentation, testing, migration assessment, data‑quality validation, and repetitive engineering work, with required governance and human review.

Produce architecture diagrams, solution designs, technical specifications, interface and data‑flow documentation, infrastructure requirements, implementation roadmaps, estimates, risks, dependencies, and operational support models.

Provide architecture governance, peer reviews, technical standards, and practical troubleshooting for performance issues, production problems, design decisions, and cross‑system dependencies.

Lead and mentor architects, data engineers, ETL developers, BI developers, modelers, analysts, testers, and administrators. Build backup coverage, transfer knowledge, and develop team capability.

Present architecture, options, risks, status, and recommendations concisely to customer stakeholders and Optum leadership, and facilitate decisions across technical and business teams.

Finalize the current‑state inventory and target solution for CMS-64 federal reporting, including claims preparation, transformation, split/manufactured transactions, staging, summary/detail tables, reconciliation, certification, and output generation.

Design a governed reference‑data capability for rates, codes, conditions, file layouts,…