Cal Poly, San Luis Obispo
Data Warehouse Engineer
Department: ITS - App Dev & Info Mgmt (135100)
College/Division: Academic Affairs
Salary Range: $4,372 - $9,683 per month. (Anticipated hiring range: $6,956 - $9,667 per month)
***THIS POSITION IS OPEN UNTIL FILLED***
Cal Poly offers an exciting opportunity to be a part of our unique "learn by doing" campus community and make an impact on the more than 20,000 students it serves. Nestled in the foothills of California's Central Coast, Cal Poly provides employees with first-class benefits and a fun, creative environment where a healthy work-life balance is deeply valued.
Information Technology Services (ITS) makes it easier for students, faculty, and staff to learn, research, teach, and work by providing great service and innovative information technology solutions. Our team of more than 100 professionals works in a highly collaborative environment, using Agile methods and Lean principles to shape the technology landscape of Cal Poly. As part of our vibrant campus culture, members of ITS work with talented Cal Poly employees and students to take on impactful, cutting-edge projects and provide day-to-day support to our customers. ITS values professional development and provides individual and organization-wide education and training opportunities for our employees.
We're currently seeking bright, collaborative, and motivated individuals to fill up to two (2) Data Warehouse Engineer positions to join our Application Development & Information Management group. This group provides the campus with a variety of services including the support for an enterprise data warehouse along with developing dynamic and interactive dashboards and reports for the campus.
The Data Warehouse Engineer supports the University enterprise data warehouse, 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 and scripts that produce appropriate and useful business intelligence capabilities for the campus community.
Minimum Qualifications (Staff Only):
Bachelor's Degree and two years of relevant experience (additional qualifying experience may be substituted for up to two years of required education on a year-for-year basis)
Demonstrated experience designing, developing and supporting solutions to flow data from source systems into the data warehouse and to extract data from the warehouse to end-user facing applications.
Demonstrated experience designing, developing and supporting data-driven applications.
Demonstrated experience with SQL and a modern structured programming language.
Demonstrated experience working with large enterprise databases and datasets.
Thorough working knowledge of software development life cycle (SDLC), structured programming and object oriented design and development techniques, and change management.
Thorough working knowledge of testing practices and application debugging and troubleshooting procedures.
Demonstrated ability to identify and implement critical maintenance fixes and to isolate and correct malfunctions, including interface problems.
Ability to identify, assess impact, and develop recovery strategies and documentation for application or system failures.
Working knowledge of common software application packages and tools for performance monitoring and issues tracking.
Demonstrated experience with Linux and UNIX operating systems.
Demonstrated ability to research and evaluate new technologies and software to meet user needs.
Demonstrated ability to work with technical and non-technical staff to identify user requirements and translate them into technology-based solutions.
Ability to use creative problem-solving skills and apply effective technical solutions.
Ability to apply campus information security policy and standards to develop specific security requirements. Ability to apply security models and frameworks to ensure appropriate database security is maintained.
Excellent verbal and written communication skills, including the ability to prepare and deliver formal and informal documentation, presentations, and training to a variety of end users.
Excellent organizational and time management skills with the ability to set own priorities to coordinate multiple assignments with fluctuating and time-sensitive deadlines.
Ability to foster and maintain positive and professional working relationships; ability to effectively handle interpersonal interactions at all levels and respond appropriately to conflicts and problems.
Ability to provide lead work direction and train others.
Interest and ability to maintain and enhance technical currency.
General knowledge of requirements for accessibility and other regulatory compliance.
Degree in computer science or related field.
Demonstrated experience with Oracle database and query tuning.
Demonstrated experience with agile data warehouse development.
Demonstrated experience with data warehouse development tools such as Oracle Data Integrator (ODI), Oracle Warehouse Builder (OWB), Informatica, Cognos, Redshift etc.
***THIS POSITION IS OPEN UNTIL FILLED***
This position classification has been defined as exempt and is not subject to the overtime provisions of the Fair Labor Standards Act (FLSA).
Must be able to adjust working hours to meet special jobs. Must be able to work occasional overtime or holidays on an as-needed basis.
May be called back periodically to perform work as needed on an emergency basis.
Must be able to rotate evening, weekend, and holiday "on-call" hours, and be reached in support of production processing.
Must be willing to travel and attend training programs off-site.
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.
Retired CalPERS members selected for this vacancy must request and be approved for reinstatement from retirement prior to the start date. Employment of retired CalPERS members will typically be for 90 days or less and must be for work requiring specialized skills or for a bona fide emergency to prevent stoppage of business.
May be required to complete a Supplemental Employment Application Questionnaire, which contains questions pertaining to conviction history, and submit it when requested by Cal Poly. This disclosure is confidential and will not necessarily preclude applicants from employment.
A background check (including a criminal records check) must be completed satisfactorily before any candidate can be offered a position with the CSU. Failure to satisfactorily complete the background check may affect the application status of applicants or continued employment of current CSU employees who apply for the position.
Please note: Current 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 sensitive. Sensitive positions are those requiring heightened scrutiny of individuals holding the position based on potential for harm to children, concerns for the safety and security of people, animals, or property, or heightened risk of financial loss to Cal Poly or individuals in the university community.
Review Begin Date:
Requisition Number: 104302
To Apply: All applicants must apply online at: https://www.calpolyjobs.org.
Cal Poly is a nationally ranked, four-year, comprehensive public university. Founded in 1901, the 6,000-acre campus is nestled in the foothills of San Luis Obispo, along California's scenic central coast and midway between Los Angeles and San Francisco. With a budget of $168.5 million, the university has a student enrollment exceeding 17,000 students and employs more than 2,000 faculty and staff members. Cal Poly is part of the 23-campus California State University system.
At California Polytechnic State University, San Luis Obispo, we believe that cultivating an environment that embraces and promotes diversity is fundamental to the success of our students, our employees and our community. Bringing people together from different backgrounds, experiences and value systems fosters the innovative and creative thinking that exemplifies Cal Poly's values of free inquiry, cultural and intellectual diversity, mutual respect, civic engagement, and social and environmental responsibility.
Cal Poly's commitment to diversity informs our efforts in recruitment, hiring and retention. California Polytechnic State University is an affirmative action/equal opportunity employer.
Copyright 2015 Jobelephant.com Inc. All rights reserved.
Posted by the FREE value-added recruitment advertising agency