UnitedHealth Group Inc. logo

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

UnitedHealth Group Inc.
  • Schaumburg, IL
  • Remote
  • $112,700–$193,200 Per Year
  • Autofill and Review
2 days ago

Job Description

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 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.

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 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

Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. In addition to your salary, we offer benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with us, you'll find a far-reaching choice of benefits and incentives. The salary for this role will range from $112,700 - $193,200 annually based on full-time employment. We comply with all minimum wage laws as applicable.

Application Deadline: This will be posted for a minimum of 2 business days or until a sufficient candidate pool has been collected. Job posting may come down early due to volume of applicants.

At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone-of every race, gender, sexuality, age, location and income-deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes - an enterprise priority reflected in our mission.

UnitedHealth Group is an Equal Employment Opportunity employer under applicable law and qualified applicants will receive consideration for employment without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, or protected veteran status, or any other characteristic protected by local, state, or federal laws, rules, or regulations.

UnitedHealth Group is a drug - free workplace. Candidates are required to pass a drug test before beginning employment.

Numbers & Facts

LocationSchaumburg, IL (
Remote
)
IndustryHealthcare Services
Salary$112,700–$193,200 Per Year
Company Size10,000 employees or more
Year Founded1977
Websitehttp://careers.unitedhealthgroup.com/

About Company

UnitedHealth Group is a health care and well-being company that’s dedicated to improving the health outcomes of millions worldwide. We are comprised of two distinct and complementary businesses, UnitedHealthcare and Optum, working to build a better health system for all. Here, your contributions matter as they will help transform health care for years to come. Make an impact with a diverse team that shares your passion for helping others.

What we do

Gain insights on how we work to help people live healthier lives and help make the health system work better for everyone by watching this video.

https://www.youtube.com/watch?v=5PbNyi2IDkY

Caring. Connecting. Growing together.

Being a part of UnitedHealth Group means working to improve health outcomes for everyone, including yourself. Here is how:

• Caring. Your total health and well-being are important to us. Whatever matters most to you — we have resources to help you be your best at work and at home. The benefits range from free Peloton courses to financial counseling. Learn more about what we offer.

• Connecting. We recognize our collective power to make an impact across our communities because we believe the health of any society is measured by the overall health of its people. Learn more about our culture.

• Growing together. UnitedHealth Group is full of inspiring career stories, and we offer a lifetime of opportunities. Discover all the ways you can learn, grow and develop.

Skills

  • Analysis Skillsunmatched
  • Application Integrationunmatched
  • Application Programming Interface (API)unmatched
  • Architectural Designunmatched
  • Artificial Intelligence (AI)unmatched
  • Automationunmatched
  • Business Intelligenceunmatched
  • Business Operationsunmatched
  • Claims Processingunmatched
  • Cloud Architectureunmatched
  • Cloud Computingunmatched
  • Code Reviewsunmatched
  • Content Management Systems (CMS)unmatched
  • Continuous Deployment/Deliveryunmatched
  • Continuous Integrationunmatched
  • Cost Controlunmatched
  • Data Lakeunmatched
  • Data Modelingunmatched
  • Data Processingunmatched
  • Data Qualityunmatched
  • Data Recoveryunmatched
  • Data Storageunmatched
  • Data Warehousingunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • DevOpsunmatched
  • Dimensional Modelingunmatched
  • Documentationunmatched
  • Engineeringunmatched
  • Enterprise Architectureunmatched
  • Environmental Managementunmatched
  • Environmental Monitoringunmatched
  • HIPAA (Health Insurance Portability and Accountability Act)unmatched
  • Health Insuranceunmatched
  • Healthcareunmatched
  • Identify Issuesunmatched
  • Informaticaunmatched
  • Information Technology & Information Systemsunmatched
  • Information/Data Security (InfoSec)unmatched
  • Leadershipunmatched
  • Linux Operating Systemunmatched
  • Managed Careunmatched
  • Medicaidunmatched
  • Mentoringunmatched
  • Microsoft Windows Azureunmatched
  • NCR Teradataunmatched
  • Operational Supportunmatched
  • Performance Tuning/Optimizationunmatched
  • Power BIunmatched
  • Presentation/Verbal Skillsunmatched
  • Production Supportunmatched
  • Proof of Conceptunmatched
  • Python Programming/Scripting Languageunmatched
  • Reconciliationunmatched
  • Regulatory Reportsunmatched
  • Regulatory Requirementsunmatched
  • Reporting Skillsunmatched
  • Revenue Growthunmatched
  • Risk Managementunmatched
  • SAP BusinessObjectsunmatched
  • SQL (Structured Query Language)unmatched
  • Security Architectureunmatched
  • Snowflake Schemaunmatched
  • Software Designunmatched
  • Source Code/Configuration Management (SCM)unmatched
  • State Governmentunmatched
  • Statistical Analysis System (SAS)unmatched
  • System Architectureunmatched
  • Tableauunmatched
  • Team Lead/Managerunmatched
  • Technical Leadershipunmatched
  • Technical/Engineering Designunmatched
  • Test Plan/Scheduleunmatched
  • Testingunmatched
  • Traceabilityunmatched
  • Transaction Processing/Managementunmatched
  • Unix Shell Programmingunmatched
  • User Interface/Experience (UI/UX)unmatched
  • Work From Homeunmatched
  • Writing Skillsunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder