Senior Application & Technical Architect -Data Warehouse- 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 project leadership, creating clarity across ambiguous scope, legacy constraints, and accelerated timelines.

Required Qualifications

• Healthcare payer, Medicaid, managed care, or health-insurance experience, including claims, adjustments, voids, eligibility, providers, payments, and regulatory reporting data.