Data Warehouse Engineer
About The Position
Under general supervision of the Manager of Applications Engineering, the Data Warehouse Engineer position is responsible for designing, developing, documenting, and maintaining the University’s enterprise data warehouse. This includes working with campus stakeholders and other data consumers to determine requirements, design solutions, and model data. Primary activities include the design, implementation, testing, documentation and support of data models, programs, data pipelines, and scripts that produce appropriate and useful business intelligence capabilities for the campus community. This role involves developing and supporting methods to integrate data with the campus computing infrastructure, utilizing current technologies and DevOps philosophies. #CalPolyITS This position is eligible for remote work pursuant to Cal Poly’s Telecommuting and Remote Work Guidelines and the CSU policy requiring that all work be performed within the State of California. Information Technology Services (ITS) is a fast-moving team that is responsible for helping Cal Poly achieve academic excellence through developing and implementing learning, teaching, and administrative solutions which leverage technology that align with strategic goals and objectives. With a focus on continuous improvement, ITS fosters innovation, supports continuous learning, and develops people to their full potential. Our team of more than 170 professionals works in a DevOps environment to shape the technology landscape at Cal Poly.
Requirements
- 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.
Responsibilities
- designing
- developing
- documenting
- maintaining the University’s enterprise data warehouse
- working with campus stakeholders and other data consumers to determine requirements, design solutions, and model data
- design, implementation, testing, documentation and support of 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
Benefits
- health insurance
- dental and vision insurance
- retirement participation in the Public Employees' Retirement System
- educational benefits for eligible employees
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
