Enterprise Data Warehouse; EDW) Architect - OI State Government Solutions - Remote

Improve the lives of others while Caring. Connecting. Growing together.

Job Description
- Enterprise Data Warehouse (EDW) Architect - OI State Government Solutions
- Remote (2385712)

Enterprise Data Warehouse (EDW) Architect - OI State Government Solutions
- Remote - 2385712

Optum Insightis improving the flow of health data and information to create a more connected system. We remove friction and drive alignment between care providers and payers, and ultimately consumers. Our deepexpertisein the industry and innovative technology empower us to help organizations reduce costs while improving risk management,quality and revenue growth. Ready to help us deliver results that improve lives?

Join us to startCaring. Connecting. Growing together.

The Senior Application & Technical Architect will provide hands-on architecture and engineering leadership for enterprise data warehousing, reporting, and analytics modernization. The role is responsible for architecting and delivering scalable reporting and analytics solutions across data integration, application, infrastructure, and cloud platforms, and for leading technical teams through solution design, proof-of-concept, development, testing, implementation, support, and operational efficiency. Experience supporting Medicaid or federal reporting modernization is preferred.

You’llenjoy the flexibility to work remotely
* from anywhere within the U.S. as you take on some tough challenges. For all hires in the Minneapolis or Washington, D.C. area, you will be required to work in the office a minimum of four days per week.

Primary 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
• Design and lead modernization of 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 to unblock the team
• Build proof-of-concepts that compare solution options, document measurable results, and support architecture decisions with the customer and leadership
• Define technical architecture across web/UI, API and service layers, processing engines, databases, orchestration, scheduling, security, identity/access, monitoring, and backup/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 Dev Ops or equivalent – epics and user stories, repositories, branching, pull requests, code review, CI/CD, release traceability, and production deployment – and 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, implementation of roadmaps, estimates, risks, 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 concisely to customer stakeholders and Optum leadership,…