Enterprise Data Warehouse (EDW) Architect - OI State Government Solutions - Remote
- Pay
- $112,700 – $193,200 per year
- Location
- Schaumburg, IL (Remote)
- Job type
- Full-time
- Level
- Lead / Staff
- Experience
- 10+ years
- Listed
- Today
Skills & highlights for this role
- Enterprise data warehouse architecture
- Reporting and analytics solution design
- Python
- Advanced SQL
- Application architecture including APIs, services, databases, security, and job scheduling
- BI/reporting tools (BusinessObjects, Power BI, Tableau, SAS)
- Source control, branching, pull requests, CI/CD, and automated deployment in Azure DevOps or similar
- People leadership of BI, data, and engineering staff
- Written, verbal, and presentation communication
Also useful
- Healthcare payer, Medicaid, managed care, or health insurance data experience
- CMS-64 and federal/state Medicaid reporting
- On-premises to cloud migration (Azure, Azure Data Factory, Databricks, Data Lake Storage, Snowflake)
- Informatica and Teradata
- AI-assisted engineering for code conversion, testing, and documentation
- Data modeling (conceptual, logical, physical, dimensional) and effective-dated reference data
- Linux/Unix scripting
How well does your resume fit this job?
Upload your resume to see your score for this UnitedHealth Group role, what matches, what's missing, and your best other matches.
Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.
About the role
Optum Insight is 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 deep expertise in 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 start
Caring. 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'll enjoy 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
Required Qualifications
- 10+ 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 - 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/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, with solid written, verbal, and presentation skills for customer and executive audiences
Preferred Qualifications
- 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
- Experience with data modeling across conceptual, logical, and physical models, effective-dated reference data, dimensional models, and transaction lineage; experience with Linux/Unix scri
From UnitedHealth Group's careers page, first listed on Rolev.ai on November 20, 2026. Rolev.ai is not the employer.
How Rolev.ai helps with this application
Rolev.ai is a job search and application tool for US job seekers. For this Enterprise Data Warehouse (EDW) Architect - OI State Government Solutions - Remote role at UnitedHealth Group, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.
See how you fit
Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.
Tailor without inventing
Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.
Draft the full kit
Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.
1-Click Extension Autofill
The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.
Common questions
What is the salary for the Enterprise Data Warehouse (EDW) Architect - OI State Government Solutions - Remote role at UnitedHealth Group?
The Enterprise Data Warehouse (EDW) Architect - OI State Government Solutions - Remote posting at UnitedHealth Group states compensation of $112,700 – $193,200 per year. It is listed as a full-time position. Final pay may depend on location, experience, and interview evaluation on UnitedHealth Group's official career site.
Where is the Enterprise Data Warehouse (EDW) Architect - OI State Government Solutions - Remote job at UnitedHealth Group located?
Yes, this Enterprise Data Warehouse (EDW) Architect - OI State Government Solutions - Remote opening at UnitedHealth Group is listed as Schaumburg, IL (Remote). Always check UnitedHealth Group's application page for specific state eligibility or relocation policies.
What qualifications are required for Enterprise Data Warehouse (EDW) Architect - OI State Government Solutions - Remote at UnitedHealth Group?
For the Enterprise Data Warehouse (EDW) Architect - OI State Government Solutions - Remote role, UnitedHealth Group highlights 10+ years of relevant experience; experience with Enterprise data warehouse architecture, Reporting and analytics solution design, Python, Advanced SQL, Application architecture including APIs, services, databases, security, and job scheduling, BI/reporting tools (BusinessObjects, Power BI, Tableau, SAS). Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.
How do I apply for the Enterprise Data Warehouse (EDW) Architect - OI State Government Solutions - Remote position at UnitedHealth Group?
This listing links directly to UnitedHealth Group's application page. You can apply directly on UnitedHealth Group's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.