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

Morgner Construction Management Corp.

Field Technician Job at Morgner Construction Management Corp.

We are seeking a dynamic and enthusiastic individual for a Field Technician to assist in overseeing noise, and vibration, pre-construction photo-documentation, and geotechnical instrumentation projects in the Honolulu area. This is a part-time / on-call position. Noise...

Robert Half

3D Graphic Artist Job at Robert Half

*Must have experience in Maya and/or SolidWorks**Contract-to-hire role, ONSITE 5 days/week near Ramsey NJ* Robert Half's client in Northern NJ is seeking a Graphic Designer to join their team. This is a CONTRACT-TO-HIRE opportunity and is ONSITE 5 days/week in Northern...

Laurel Dental Office

ENTRY LEVEL Dental Assistant Job at Laurel Dental Office

 ...We are a rapidly expanding high end dental office looking for a full-time dental assistant with great work ethic to join our team. Competitive pay, great team and doctors, beautiful state-of-the-art facility, family-life atmosphere! If you are energetic love to... 

HRM Enterprises, Inc.

Performance Marketing Manager (Paid Advertising) Job at HRM Enterprises, Inc.

Company Description HRM Enterprises, Inc. is a local, family-owned company established in 1939. With businesses ranging from the largest independent hardware store in the country to a Tripadvisor top-rated restaurant and a dynamic Marketplace, HRM Enterprises has become...

PAIGE

Part-Time Keyholder (Plano) Job at PAIGE

 ...setting ~ Open availability on weekends ~ The availability to work at least 20 hours a week ~ The availability to work up to 3 shifts per week ~ The ability to work during the Vacation Blackout Policy dates ~ The ability to engage and motivate teams, and to...