Data Analytics Developer - Information Technology Services

Job Summary

Under general supervision of the, Manager of Enterprise Operations, this position is responsible for the operation, reliability, and delivery of campus data platforms and analytics services. Primary activities include improving, monitoring, and maintaining data warehouse delivery services. In addition, this position will develop and maintain database views for existing data, execute manual processes, and deliver ad hoc data requests from campus data stores, utilizing standard methodologies, current technologies and Dev Ops 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.

Department Summary

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.
Key Qualifications

• Demonstrated skill using databases/query languages to store, manipulate, and retrieve data (e.g., MySQL, Oracle, MSSQL, Postgre
  
  SQL, Aurora, or Redshift)
• Experience using data visualization and reporting tools (e.g., Oracle Analytics Cloud, Tableau, Power BI).
• Demonstrated knowledge of scalable data warehousing, ETL pipelines, and schema modeling.
• Demonstrated ability to identify and implement critical maintenance fixes and to isolate and correct malfunctions, including interface problems.
• Experience with monitoring, maintaining, and improving data warehouse and data lake operations in AWS tools and services.

Education and Experience

• Equivalent to a bachelor's degree in a related field and two 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: $98,808 - $102,792 Per Year

Classification Range: $77,904 - $113,496 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 20,000 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 Poly's 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 calpoly.edu .

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, California's Proposition 209 (Art.

I, Section 31 of the California Constitution), other applicable state and federal anti-discrimination laws, and CSU's Nondiscrimination Policy. We prohibit discriminatory preferential…