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.
- Satisfactory completion of a background check (including a criminal records check) is required for employment.
- The person holding this position is considered a 'mandated reporter' under the California Child Abuse and Neglect Reporting Act and is required to comply with the requirements set forth in CSU Executive Order 1083 as a condition of employment.
- Applicants for staff and management positions must be authorized to work for any employer in the U.S.
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, 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
