Data Warehouse Engineer

Job Summary

Under general supervision of the Manager of Applications Engineering the Data Warehouse Engineer position is responsible for designing developing documenting and maintaining the Universitys 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 Polys Telecommuting and Remote Work Guidelines and the CSU policy requiring that all work be performed within the State of California.

Department Summary

Key Qualifications

• Demonstrated experience building required infrastructure for optimal extraction transformation and loading of data from various data sources using AWS-specificandgeneralrelational databasetechnologies.

• Demonstrated experience designingbuildingand optimizingdata 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).

Education and Experience

Equivalent to a bachelors 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.

Salary and Benefits

Anticipated Hiring Range: $98436 - $119988 Per Year

Classification Range: $87408 - $127332 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

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 20000 top-tier students come to San Luis Obispo to put knowledge into action taking their learning outside the classroom as they prepare for careers in engineering agriculture science business humanities and the built environment. Cal Polys hands-on philosophy small class sizes and close student-faculty mentorships result in graduates ready from day one to impact their communities California and the world. For more information visit .

Equal Opportunity and Excellence in Education and Employment

This position is open and available to all regardless of race sex color ethnicity or national origin. Consistent with California law and federal civil rights laws Cal Poly provides equal opportunity in education and employment without unlawful discrimination or preferential treatment based on race sex color ethnicity or national origin. Our commitment to equal opportunity means ensuring that every student and employee has access to the resources and support they need to thrive and succeed in a university environment and in their communities. Cal Poly complies with Title VI of the Civil Rights Act of 1964 Title IX of the Education Amendments of 1972 the Americans with Disabilities Act (ADA) Section 504 of the Rehabilitation Act the California Equity in Higher Education Act Californias Proposition 209 (Art. I Section 31 of the California Constitution) other applicable state and federal anti-discrimination laws and CSUs Nondiscrimination Policy. We prohibit discriminatory preferential treatment segregation based on race or any other protected status and all forms of discrimination harassment and retaliation in all university programs policies and practices.

Cal Poly is a diverse community of individuals who represent many perspectives beliefs and identities committed to fostering an inclusive respectful and intellectually vibrant environment. We cultivate a culture of open dialogue mutual respect and belonging to support educational excellence and student success. Through academic programs student organizations and activities faculty initiatives and community partnerships we encourage meaningful engagement with diverse perspectives. As a higher education institution we are dedicated to advancing knowledge and empowering individuals to reach their full potential by prioritizing inclusive curriculum development faculty and staff training student mentorship and comprehensive support programs. At Cal Poly excellence is built on merit talent diversity accessibility and equal opportunity for all.

Supplemental Information

Satisfactory completion of a background check (including a criminal records check) is required for employment. Cal Poly will make a conditional offer of employment which may be rescinded if the background check reveals disqualifying information and/or it is discovered that the candidate knowingly withheld or falsified employees who are offered positions on campus will be required to undergo a background check for any position where a background check is required by law or that Cal Poly has designated as to satisfactorily complete the background check may affect the continued employment of a current CSUemployee who was conditionally offered the position.

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.

Cal Poly San Luis Obispo is not a sponsoring agency for staff or management positions. Applicants for staff and management positions must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

Positions are posted for a minimum of 14 calendar days.