Data Warehouse Engineer jobs in United States
cer-icon
Apply on Employer Site
company-logo

California Polytechnic State University-San Luis Obispo · 14 hours ago

Data Warehouse Engineer

California Polytechnic State University-San Luis Obispo is a nationally-ranked public university known for its Learn by Doing philosophy. The Data Warehouse Engineer position involves designing, developing, documenting, and maintaining the University’s enterprise data warehouse, while collaborating with stakeholders to determine requirements and model data.

Higher Education
badNo H1Bnote

Responsibilities

Designing, developing, documenting, and maintaining the University’s enterprise data warehouse
Working with campus stakeholders and other data consumers to determine requirements, design solutions, and model data
Designing, implementing, testing, documenting and supporting data models, programs, data pipelines, and scripts that produce appropriate and useful business intelligence capabilities for the campus community
Developing and supporting methods to integrate data with the campus computing infrastructure, utilizing current technologies and DevOps philosophies

Qualification

AWSData warehouse designData pipeline optimizationDatabase/query languagesPython

Required

Demonstrated experience building required infrastructure for optimal extraction, transformation and loading of data from various data sources using AWS-specific and general relational database technologies
Demonstrated experience designing, building and optimizing data sets, data pipelines and architectures
Demonstrated experience designing, developing and supporting data warehouse star schema models and applications
Demonstrated skills using database/query languages to store, manipulate, and retrieve data (e.g., MySQL, Oracle, MSSQL, PostgreSQL, or Aurora)
Demonstrated programming skills using modern languages (e.g., Python)
Equivalent to a bachelor's degree in a related field and four years of relevant experience
Additional experience which demonstrates acquired and successfully applied knowledge and abilities shown above may be substituted for the required education on a year-for-year basis
An advanced degree in a related field may be substituted for the required experience on a year-for-year basis

Benefits

Health, dental and vision insurance
Retirement participation in the Public Employees' Retirement System
Educational benefits for eligible employees

Company

California Polytechnic State University-San Luis Obispo

twittertwittertwitter
company-logo
Founded in 1901, California Polytechnic State University (Cal Poly) is one of five comprehensive polytechnic universities in the U.S.

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Christina Diaz
Executive Assistant, Office of the Vice President, University Development & Foundation CEO
linkedin
leader-logo
Megan Miyamoto
Chief Marketing Officer of the Cal Poly Marching Band
linkedin
Company data provided by crunchbase