Data Warehouse Engineer - Information Technology Services

Unit 9 - CSUEU - Technical Support Services 1

Time Basis

• Full Time 1

• Remote in-state eligible (long distance work arrangement outside business location) 1

Apply now Job no: 555105
Work type:
Staff
Location:
Cal Poly - San Luis Obispo Campus
Categories:
Unit 9 - CSUEU - Technical Support Services, Probationary, Full Time, Information Systems & Technology, Remote in-state eligible (long distance work arrangement outside business location) Position Description

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 Dev Ops philosophies. #CalPolyITS

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 Dev Ops environment to shape the technology landscape at Cal Poly.

• 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, Postgre
  
  SQL, 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.

Anticipated Hiring Range: $98,436 - $119,988 Per Year

Classification Range: $87,408 - $127,332 Per Year

Factors in determining the appropriate compensation for a role include experience, skills, knowledge, abilities, education, licensure and certifications, and other business and organizational needs. The Anticipated Hiring Range referenced in the job posting is the budgeted salary or hourly range that the University reasonably expects to pay for this position. The Classification Range may be broader than what the University anticipates paying for this position, based on internal equity, budget, and collective bargaining agreements (when applicable).

Cal Poly offers a best-in-class benefits program, including health, dental and vision insurance, retirement participation in the Public Employees' Retirement System, and educational benefits for eligible employees. See our benefits website for additional information.

Cal Poly is a nationally-ranked public university located in San Luis Obispo, California, and known for its Learn by Doing philosophy. Each year more than 20,000 top-tier students come to San Luis Obispo to put knowledge…