> Markdown version of [/jobs/ext/3535237-enterprise-data-warehouse-edw-architect](https://www.wearedevelopers.com/jobs/ext/3535237-enterprise-data-warehouse-edw-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Enterprise Data Warehouse (EDW) Architect

- **Company:** Unitedhealth Group Inc
- **Location:** Washington, DC, United States (Remote available)
- **Experience:** Expert
- **Salary:** $112,700.0 - $193,200.0
- **Contract:** Permanent contract
- **Skills:** Application Programming Interfaces (APIs), Artificial Intelligence, Business Analytics Applications, Data Analysis, Applications Architecture, Audit Trail, Microsoft Azure, Business Intelligence Development, Cloud Computing, Code Review, Cyber Security, Databases, Continuous Integration, Data Architecture, Information Engineering, Data Integration, Extract Transform Load (ETL), Data Warehousing, Linux, Federal Information Processing Standards (FIPS), Data Flow Control, Job Scheduling, Python (Programming Language), Performance Tuning, Reference Data, Power BI, Cloud Services, SAS (Software), Software Deployment, SQL Databases, Tableau (Software), Teradata SQL, Web Applications, Data Processing, Scripting, Enterprise Software Applications, Azure Data Factory, Sql Optimization, Snowflake, Sap Business Objects, Data Lakes, Information Technology, Deployment Automation, Drilldown, Enterprise Integration, Software Version Control, Databricks
- **Published:** October 2, 2026
- **Apply:** https://www.dice.com/job-detail/8b4f3ede-a3d8-41e8-a736-4f374807430b

## About the Role

* 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 scripting and job orchestration
 * Demonstrated knowledge of HIPAA, PHI, PII, security architecture, and public-sector compliance expectations; advanced degree or relevant architecture, cloud, data, or agile certifications

*All employees working remotely will be required to adhere to UnitedHealth Group's Telecommuter Policy

## Description

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., * 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 DevOps 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, creating clarity across ambiguous scope, legacy constraints, and accelerated timelines

You'll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as provide development for other roles you may be interested in.


## Related Videos

- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [Docker network without Docker](https://www.wearedevelopers.com/videos/1418-docker-network-without-docker)
- [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture)
- [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles)
- [Docker exec without Docker](https://www.wearedevelopers.com/videos/1094-docker-exec-without-docker)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)
- [Best US AI Conferences for CTOs in 2026: Build vs. Buy, Vendor Evaluation, and Peer Intelligence](https://www.wearedevelopers.com/magazine/736-best-us-ai-conferences-for-ctos-in-2026-build-vs-buy-vendor-evaluation-and-peer-intelligence)