EDW Technical Architect (36022)

Myticas Consulting

Illinois

Remote

USD 83,000 - 99,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Clover Consulting is seeking an Enterprise Data Warehouse Technical Architect for a 12+ month contract. The role focuses on hands-on architecture and leadership for data warehousing, reporting, and analytics modernization, with cloud and on-premise deployments.

Responsibilities include end-to-end architecture, modernization of ETL/SQL, and guiding teams through design, testing, and deployment. Experience with Medicaid or federal reporting is preferred.

Qualifications

  • Bachelor’s degree in Computer Science, Engineering, Information Systems, or related field, or equivalent professional experience.
  • 10+ years of IT experience with senior-level architecture for large enterprise systems.
  • Proven experience building enterprise data warehouse, reporting, analytics, and claims/transaction processing solutions.
  • Hands-on Python and advanced SQL development, automation, data processing, and code review.
  • Experience designing APIs, services, web components, databases, security, identity/access, scheduling, monitoring, and environment mgmt.
  • BI/reporting experience with enterprise tools (Power BI, Tableau, SAS, etc.).
  • Experience implementing source control, branching, CI/CD, and automated deployments in Azure DevOps or similar.
  • People leadership in BI, data, and engineering teams; strong communication for executive audiences.

Responsibilities

  • Own end-to-end architecture for reporting, analytics, data integration, and processing solutions across on-prem and cloud.
  • Translate requirements into maintainable system designs with traceability and governance.
  • Modernize legacy ETL and SQL logic into Python-based applications and automated workflows.
  • Provide hands-on technical leadership: architecture reviews, testing, deployment, and production support.
  • Build PoCs to compare options and document measurable results for stakeholders.
  • Define architecture across UI, APIs, processing engines, and data platforms in partnership with infra and security teams.
  • Lead BI delivery including enterprise report design and data quality improvements.
  • Establish engineering practices with CI/CD, epics, stories, and release traceability.
  • Mentor architects and engineers; ensure backup coverage and team capability.
  • Present options, risks, and recommendations clearly to customers and leadership.

Skills

Python
Advanced SQL
BI reporting
Leadership
Architectural design

Education

Bachelor’s degree or higher

Tools

Azure DevOps
Power BI
Tableau
Informatica
Databricks
Snowflake

Job description

Clover Consulting has a direct client in Springfield, IL in need of an Enterprise Data Warehouse Technical Architect for a 12+ months contract. Job details are below.

Role:

EDW Technical Architect

Location:

Remote - occasional travel to Illinois possible

Term:

12+ months contract, extensions possible

Rate:

$60 W2 - $72 C2C

Position Summary

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.

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, 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.
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.
  • Applying AI‑assisted engineering or automation to code conversion, source‑to‑target mapping, testing, documentation, and data‑quality activities within enterprise governance.
  • 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.
  • Knowledge of HIPAA, PHI, PII, security architecture, and public‑sector compliance expectations; advanced degree or relevant architecture, cloud, data, or agile certifications.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

EDW Technical Architect
EDW Technical Architect

Myticas Consulting Inc. • Springfield (IL)

Remote
USD 83,000 - 99,000
EDW Senior Healthcare Business/Data Analyst (Medicaid Reporting)
EDW Senior Healthcare Business/Data Analyst (Medicaid Reporting)

Myticas Consulting Inc. • Springfield (IL)

Remote
USD 108,000 - 129,000
Remote EDW Architect — Cloud Data & Analytics
Remote EDW Architect — Cloud Data & Analytics

Myticas Consulting Inc. • Springfield (IL)

Remote
USD 83,000 - 99,000
EDW BI Data Analytics Developer
EDW BI Data Analytics Developer

Myticas Consulting Inc. • Springfield (IL)

Remote
USD 56,000 - 66,000
Remote EDW Architect: Data & Analytics Leadership
Remote EDW Architect: Data & Analytics Leadership

Myticas Consulting • Illinois

Remote
USD 83,000 - 99,000
EDW Health Data Modeler (36023)
EDW Health Data Modeler (36023)

Myticas Consulting • Illinois

Remote
USD 77,000 - 91,000
EDW Health Data Modeler
EDW Health Data Modeler

Myticas Consulting Inc. • Springfield (IL)

Remote
USD 116,000 - 137,000
EDW Medicaid SME (36025)
EDW Medicaid SME (36025)

Myticas Consulting • Illinois

Remote
USD 83,000 - 99,000
Data Engineer - ETL/Python Developer
Data Engineer - ETL/Python Developer

Myticas Consulting Inc. • Springfield (IL)

Remote
USD 77,000 - 91,000
EDW Medicaid SME (Federal Policy & Reporting)
EDW Medicaid SME (Federal Policy & Reporting)

Myticas Consulting Inc. • Springfield (IL)

Remote
USD 83,000 - 99,000