EDW Architect

Job Title

EDW Architect

$ - $

$120,000 – $150,000

We are looking for a highly experienced and technically skilled Enterprise Data Warehouse (EDW) Architect to lead the design, development, and optimization of data infrastructure across our enterprise. This is a critical, hands‑on role that will drive our data architecture strategy, enabling advanced analytics, reporting, and business intelligence across departments.

The ideal candidate brings a deep background in data modeling, enterprise architecture, and cloud‑based data platforms—especially AWS
, Oracle
, and Redshift
—along with a passion for building scalable, high‑performance systems.

• Architect and maintain the enterprise data warehouse to support analytics, reporting, and operational needs.
• Design robust, scalable data infrastructure components and ETL/ELT processes.
• Develop and implement enterprise information architecture strategies to ensure data consistency, availability, and performance.
• Lead end‑to‑end data lifecycle management including ingestion, transformation, storage, and access.
• Collaborate with data engineers, analysts, and business stakeholders to understand requirements and deliver actionable solutions.
• Ensure compliance with data governance and security protocols.
• Provide technical leadership and mentorship to data engineering teams.

• Bachelor’s degree in Computer Science, Information Systems, or related field
• (20+ years of relevant experience accepted in lieu of degree)
• 16+ years of experience in programming, data modeling, and enterprise data warehouse development
• 5+ years of experience in Enterprise Information Architecture
• 5+ years designing data infrastructure components
• 3+ years of recent hands‑on expertise with AWS (including Redshift),
  Oracle
  , programming with database services for enterprise data management and analytics, strong proficiency in data modeling (conceptual, logical, and physical), deep understanding of relational and non‑relational database systems

• Experience with Electronic Health Record (EHR) systems and related data architecture
• Hands‑on experience with tools and technologies such as OLAP, Hadoop / Cloudera, Talend, RDBMS & No
  
  SQL

Mid‑Senior level

Full-time

Information Technology

Hospitals and Health Care

• Medical insurance
• Vision insurance
• 401(k)
• Paid maternity leave
• Child care support
• Paid paternity leave
• Student loan assistance
• Disability insurance
• Tuition assistance