Remote EDW Architect for Data Modernization & Analytics

Myticas Consulting Inc.; Illinois; Remote; USD 83,000 - 99,000; Full time

Job summary

Clover Consulting is seeking an Enterprise Data Warehouse Technical Architect to lead architecture and engineering for enterprise data warehousing, reporting, and analytics modernization. You will architect solutions across data integration, applications, infrastructure, and cloud platforms while guiding technical teams through design, PoC, development, testing, implementation, support, and operations.

Medicaid/federal reporting experience is preferred.

Qualifications

• Bachelor’s degree in computer science, engineering, information systems, or related field, or equivalent experience.
• 10+ years IT experience including senior-level architecture for large enterprises.
• Proven experience architecting enterprise data warehouse and analytics solutions.
• Hands-on Python and advanced SQL development and automation.
• Experience designing APIs, services, security, monitoring, and CI/CD.
• BI/reporting experience with enterprise tools (Power BI/Tableau/SAS).

Responsibilities

• Own end-to-end data architecture for reporting and analytics across on-prem and cloud.
• Translate requirements into maintainable designs with traceability and auditability.
• Lead modernization of ETL/SQL scripts and Python-based automation.
• Provide hands-on leadership across architecture, development, testing, and deployment.
• Develop PoCs to compare options and document measurable results for stakeholders.
• Define architecture across UI/API, processing engines, databases, security, and monitoring.
• Lead BI and analytics delivery including enterprise report design and data quality.
• Establish engineering practices with Azure DevOps – epics, CI/CD, release traceability.
• Mentor architects, data engineers, ETL/BI developers; build team capability.
• Present architecture options, risks, and recommendations to leadership.

Skills

Python

Advanced SQL

BI tools

Azure DevOps

Architecture leadership

Data warehousing

Education

Bachelor’s degree in CS/related field

Tools

Power BI

Tableau

BigQuery/Snowflake

Job description

Clover Consulting is seeking an Enterprise Data Warehouse Technical Architect to lead architecture and engineering for enterprise data warehousing, reporting, and analytics modernization. You will architect solutions across data integration, applications, infrastructure, and cloud platforms while guiding technical teams through design, PoC, development, testing, implementation, support, and operations.

Medicaid/federal reporting experience is preferred.