Remote EDW Architect — Cloud Data & Analytics

Myticas Consulting Inc.; Springfield (IL); Remote; USD 83,000 - 99,000; Full time

Job summary

Clover Consulting seeks an Enterprise Data Warehouse Technical Architect for a 12+ month contract, remote with occasional travel to Illinois. The role leads architecture for data warehousing, reporting, and analytics modernization, spanning on‑premise and cloud platforms.

The position requires hands‑on leadership, strong SQL/Python skills, and experience implementing modern data solutions. Medicaid or federal reporting background is a plus.

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.

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 – epics and user stories, repositories, branching, pull requests, 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.

Skills

Python

Advanced SQL

BI tools

Azure DevOps

Leadership

Data warehousing

ETL/ELT

Architecture

APIs/services

Education

Bachelor's degree in Computer Science

Tools

Power BI

Tableau

BusinessObjects

SAS

Informatica

Azure DevOps

Databricks

Teradata

Job description

Clover Consulting seeks an Enterprise Data Warehouse Technical Architect for a 12+ month contract, remote with occasional travel to Illinois. The role leads architecture for data warehousing, reporting, and analytics modernization, spanning on‑premise and cloud platforms.

The position requires hands‑on leadership, strong SQL/Python skills, and experience implementing modern data solutions. Medicaid or federal reporting background is a plus.