EDW Architect Job at Prosum, Los Angeles, CA

UWxXeTlKdjJST2ZmcTY3L1I0QUVYa1NWMHc9PQ==
  • Prosum
  • Los Angeles, CA

Job Description

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

Lunacon Engineering Group

Remote Proposal Writer Job at Lunacon Engineering Group

 ...Position Summary We are seeking a highly skilled Proposal Writer with experience in developing accurate, compelling, and timely...  ...skills Excellent communication and collaboration abilities Travel & Physical Requirements Ability to travel up to 50% for proposal... 

TradeJobsWorkforce

American Airlines Ramp Agent Job at TradeJobsWorkforce

 ...Bring your energy to the role of American Airlines Ramp Agent to perform daily responsibilities with dedication. Provide excellent interactions with customers and colleagues. Stay adaptable in a dynamic, fast-paced environment. Perks include competitive pay, flexible... 

University of Kansas Health System

Patient Dietary Aide - Part Time Job at University of Kansas Health System

 ...Job Description Position Title Patient Dietary Aide - Part Time Indian Creek Main Position Summary / Career Interest: Under the direction of the Dietary Supervisor this position is responsible for preparing meals for patients, visitors and employees. The... 

University Health

Respiratory Therapist Job at University Health

 ...provisions of respiratory related duties in accordance with physician directives.Complies with departmental and University Health's policies and procedures and maintains good public and working relations \n\n EDUCATION/EXPERIENCE \n\n Associates degree with a... 

Tek Spikes

Senior React Native Developer (iOS Mobile Focus) Job at Tek Spikes

 ...Job Description Job Description Job Overview: We are seeking a highly experienced Senior React Native Developer with a strong background in iOS mobile development to join our enterprise mobile application team in Minneapolis, MN . This role is best suited for...