EDW Architect Job at Prosum, Los Angeles, CA

UjZvMC9oVHRPZCt5N1FveXV3MFd2cHE4
  • Prosum
  • Los Angeles, CA

Job Description

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

Job Tags

Similar Jobs

Yoh, A Day & Zimmermann Company

**W2 ONLY** Senior Angular Java Full Stack Developer (TRUE 50/50) - HYBRID Job at Yoh, A Day & Zimmermann Company

 ...****@*****.*** Bhagyashree Yewle, Principal Lead Recruiter- YOH SPG IMMEDIATE INTERVIEWS // Senior Angular Java Full Stack Developer (TRUE 50/50) - HYBRID Location: Hybrid Onsitein the office Monday through Friday every alternate week is MUST. Onsite... 

Global Connect Technologies

Functional Safety Engineer Job at Global Connect Technologies

 ...Job Title: Functional Safety Engineer (FSE) Location: Johnson Creek, WI Duration: Long Term Job Summary: We are seeking a Senior Functional Safety Engineer to lead and drive functional safety activities for Electric Vehicle (EV) and Autonomous Driving (AD)... 

The Austin Company

Architectural Intern - Summer 2026 Job at The Austin Company

 ...proposal to the architectural, engineering, construction and marketing professionals in the office. By the end of the summer internship, students gain an understanding for the project cycle. Essential Functions Reasonable accommodations may be made to enable... 

Altea Healthcare

Physician Assistant Certified***PRN***Multi Sites*** Job at Altea Healthcare

 ...Physician Assistant (PA-C) Post-Acute Care Location: Rolla, Missouri, Town and Country, Missouri, St. Louis, Missouri, and St. Charles, Missouri Compensation: $420 - $520 per day + Uncapped Bonus Potential Job Type: Part-time ***Current and active DEA... 

eNNOVATION Brands

Ecommerce Creative Strategist (LA - Hybrid) Job at eNNOVATION Brands

 ...with innovation. Our mission is to design the least damaging hair tools on the market, paired with advanced treatments that directly target thinning, weak, and brittle hair helping millions of women restore their confidence and hair health. Looking ahead, our...