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

Miaou

Freelance Graphic Designer Job at Miaou

Miaou is looking for a freelance Social & Digital Graphic Designer to support the brand across social, digital campaigns, and eCommerce. This role is ideal for a visually driven designer with a strong fashion POV and experience creating social-first, performance-minded...

US Tech Solutions

Team and Project Coordinator Job at US Tech Solutions

 ...globally focused team by managing budgets, coordinating meetings and events, and streamlining...  ...financials, internal communications, and project schedules run smoothly, contributing to...  ...discretion, sound judgment, and capacity to work in complex, high-profile settings... 

Propel Recruitment LLC

Administrative Assistant Job at Propel Recruitment LLC

 ...Administrative Assistant Real Estate / Property Management Location: On-Site | Waterfront - Oakland, CA Assignment Type: Temporary with potential for Direct Hire Compensation: $25$30/hour (based on experience) Overview A well-established real estate... 

HONOUR LANE SHIPPING LTD

President / CEO - Group North America Job at HONOUR LANE SHIPPING LTD

Position Overview We are seeking a dynamic, visionary President & CEO to oversee the companys North American operations and its subsidiary, reporting to the Executive Committee of the Group. This role holds full P&L accountability for both entities and end-to-end responsibility...

LA Fitness

Certified Pilates Instructor Job at LA Fitness

 ...educating others on the benefits of Pilates. Duties - Instruct Pilates classes for groups of varying skill levels - Develop personalized Pilates programs based on clients' needs and goals - Educate clients on proper body mechanics and alignment during exercises...