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

Rx relief

Pharmacist Job at Rx relief

 ...parenteral nutrition and anti-infectives. Why Join Us? Competitive hourly rates at the top of the Atlanta market. Diverse career pathsmove between specialties as you grow. Consistent 40-hour work weeks. Apply with Rx relief today for immediate consideration!... 

Mayo Clinic

Chief Technology Officer / Vice Chair - Enterprise Architecture Job at Mayo Clinic

City Rochester State MN Remote NO Department Information Technology Why Mayo Clinic Mayo Clinic is top-ranked in more specialties than any other care provider according to U.S. News & World Report. As we work together to put the needs of the patient...

mdg | m-design group

Architectural Designer Job at mdg | m-design group

 ...(Project-Based Contractor) Start Date: January 1, 2026 Location: NYC (Hybrid with in-person meetings as needed) No visa sponsorship available Company Description mdg is a design-forward architecture and construction management studio specializing in high-... 

YINAN NEW YORK

Fashion Design & Production Internship Job at YINAN NEW YORK

 ...NYC-BASED ONLY How to Apply: Please email your resume and portfolio to ****@*****.*** with the subject line: [Spring internship_yinan new york] (Applications without this subject line will not be reviewed.) Industry: Retail Apparel and Fashion... 

Guthrie

Respiratory Therapist - Prep/Recovery Unit - Per Diem Job at Guthrie

Position Summary: To perform respiratory therapy treatment modalities, patient assessments, and life support interventions in all treatment areas, including the Intensive Care Unit and Emergency Department. To determine appropriate course of respiratory treatment using...