Data Architect – Data Warehouse/Analytics (Remote)

Data Architect // Senior Application & Technical Architect – Data Warehouse/Analytics (Remote)

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.

Required Qualifications

• Bachelor’s degree in computer science, engineering, information systems, or related field, or equivalent professional experience.
• 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 strong written, verbal, and presentation skills for customer and executive audiences.