EDW Architect
Job Title: EDW Architect Salary Range: $120,000 – $150,000 About the Role 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. Key Responsibilities • 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. Required Qualifications • 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 Nice to Have • 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 & NoSQL • Big Data platforms Apply tot his job