Remote EDW Architect: Data & Analytics Leadership

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Remote EDW Architect — Cloud Data & Analytics
Remote EDW Architect — Cloud Data & Analytics

Myticas Consulting Inc. • Springfield (IL)

Remote
USD 83,000 - 99,000
EDW Technical Architect (36022)
EDW Technical Architect (36022)

Myticas Consulting • Illinois

Remote
USD 83,000 - 99,000
EDW Technical Architect
EDW Technical Architect

Myticas Consulting Inc. • Springfield (IL)

Remote
USD 83,000 - 99,000
Remote EDW Architect — Data Modernization & Analytics Lead
Remote EDW Architect — Data Modernization & Analytics Lead

Optum • Schaumburg (IL)

Remote
USD 113,000 - 193,000
Senior EDW Data Analyst - Medicaid Reporting (Remote)
Senior EDW Data Analyst - Medicaid Reporting (Remote)

Myticas Consulting Inc. • Springfield (IL)

Remote
USD 108,000 - 129,000
EDW BI Data Analytics Developer
EDW BI Data Analytics Developer

Myticas Consulting Inc. • Springfield (IL)

Remote
USD 56,000 - 66,000
Senior Health Data Modeler – Remote EDW
Senior Health Data Modeler – Remote EDW

Myticas Consulting Inc. • Springfield (IL)

Remote
USD 116,000 - 137,000
Remote EDW Medicaid SME | Federal Reporting & Policy Lead
Remote EDW Medicaid SME | Federal Reporting & Policy Lead

Myticas Consulting • Illinois

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 BI Analytics Developer | Tableau & Power BI
Remote EDW BI Analytics Developer | Tableau & Power BI

Myticas Consulting Inc. • Springfield (IL)

Remote
USD 56,000 - 66,000