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 development5+ years of experience in Enterprise Information Architecture5+ years designing data infrastructure components3+ years of recent hands-on expertise with :AWS (including Redshift)OracleProgramming with database services for enterprise data management and analyticsStrong proficiency in data modeling (conceptual, logical, and physical)Deep understanding of relational and non-relational database systemsNice to Have
Experience with Electronic Health Record (EHR) systems and related data architectureHands-on experience with tools and technologies such as :OLAPHadoop / ClouderaTalendRDBMS & NoSQLBig Data platforms