Job Posting
For UCOP internal applicants, please login to the internal candidate gateway at: Jobs at UCOP
UC OFFICE OF THE PRESIDENT
At the University of California (UC), your contributions make a difference. A world leader producing Nobel and Pulitzer prize recipients with over 150 years of groundbreaking research transforming the world. Choose a career where you can leverage your knowledge, skills and aspirations to inspire and support some of the greatest minds in the world, and those who will follow in their footsteps. Working at the University of California is being part of a unique institution, and a vibrant and diverse community. At the University of California, Office of the President, we propel our mission through impactful work locally, in government centers and systemwide. We are passionate people, serving the greater good.
The University of California, one of the largest and most acclaimed institutions of higher learning in the world, is dedicated to excellence in teaching, research and public service. The University of California Office of the President is the headquarters to the 10 campuses, six academic medical centers and three national laboratories and enrolls premier students from California, the nation and the world. Learn more about the UC Office of the President
Department Overview
The department of Institutional Research and Academic Planning (IRAP) is a central service unit of the Office of the President. IRAP provides timely, accurate, consistent and reliable information about UC and the environment in which it operates. Through evidence-based analyses, the department supports and guides enrollment planning, policy creation and revision, program and campus budget reviews, statewide higher education studies and UC operations. IRAP also produces the annual Accountability Report, which assesses UC's activities, achievements and operations through data-driven narratives and visualizations.
Position Summary
The Data Analytics Developer reports to the Director of Data and Analytics and provides direction on the data analytics work of the Data Management team. The Data Management Team is responsible for the technical delivery of multiple robust and dynamic reporting and analytics environments as well as the development and maintenance of data transformation rules and file submission and processing for the UC Data Warehouse (UCDW) and the IRAP Digital Commons. Under the direction of the Director, the incumbent is responsible for applying software concepts and objectives to projects up to and including the most complex with institution-wide scope and little or no precedent. Scope of work includes the analysis, design, implementation, documentation, and maintenance of analytics solutions, data extractions and processing to support mission-critical analyses, reports, visualizations and dashboards that drive key business decisions.
This position is housed at the University of California, Office of the President in the Institutional Research and Academic Planning (IRAP) office. It directly contributes to the ability of administrators and key decision-makers to apply educational data to the improvement of student and institutional outcomes. The Data Analytics Developer designs and implements solutions for analytic product analysis, design, and presentation and directs the selection of tools, methods, techniques, technologies and evaluation criteria to obtain results. As such, this position requires expert programming skills. The successful candidate must develop an in-depth understanding of IRAP's data and technology ecosystem and opportunities for the programmatic development of data/error reporting and analytics across multiple systems and domains. The Data Developer must have sophisticated communication skills and serve as the subject matter expert on behalf of IRAP with a wide range of stakeholders to meet the needs of a complex organization spanning all UC locations.
This position is eligible for a remote work arrangement within the state of California, and with ability to be on-site in Oakland, CA as needed for work related purposes. The selected candidate must reside within the state of California or be willing to relocate.
Key Responsibilities
40% Software application design, development, testing and implementation of profiling reports, analytics and data visualization needs across the UCOP IRAP data infrastructure using appropriate BI tools and techniques up to and including the most complex and advanced. Identify data sources and build necessary queries, views, and/or analytic packages to develop reports, dashboards and/or analytics applications. Apply advanced software concepts to plan, design and modify, debug and deploy systems and analytics that are highly complex and have broad institutional impact. Regularly leads analysis of existing software and security practices to devise innovative solutions, up to and including the most complex.
20% Directs the migration of analytics from one platform to another, code conversion, program documentation, creation of performance and integration testing processes. Initiates, develops and manages reporting and analytics standards including source code control techniques and configuration management design and changes based on best practices while conforming to programming security practices, industry practices, community standards and departmental policies and procedures. Serve as technical lead for reporting and analytic development for multiple development projects of broad scope and impact to the institution.
20% Overall responsibility for monitoring, investigating and troubleshooting advanced error framework infrastructures and creating fit-for-purpose analytics related to data integrity and data quality across multiple data source systems having critical campus and institution-wide impact. Lead on-going data quality assessment efforts by developing products that investigate and evaluate the health of data systems against standards and thresholds. Overall responsibility for enhancements and performance tuning of existing reports and analytic solutions.
20% Overall responsibility for monitoring, investigating and troubleshooting advanced error framework infrastructures and creating fit-for-purpose analytics related to data integrity and data quality across multiple data source systems having critical campus and institution-wide impact. Lead on-going data quality assessment efforts by developing products that investigate and evaluate the health of data systems against standards and thresholds. Overall responsibility for enhancements and performance tuning of existing reports and analytic solutions.
Experience
Required Qualifications
- Minimum 7 years of experience working with users in requirements gathering, developing and implementing analytics solutions and developing documentation.
Skills And Abilities
Required Qualifications
- Significant development experience with at least one of the following technologies: Tableau Desktop, IBM Cognos.
- Advanced knowledge of Tableau Server development and administration.
- Expert knowledge writing complex SQL, PL/SQL queries.
- Expert knowledge with Python, R or similar data analysis tool.
- Experience with Atlassian JIRA for requirements management and bug tracking.
- Expert knowledge of visual analytics and user experience design.
- Experience with text analytics
- Extensive experience working in higher education.
- Advanced understanding of database, data warehousing and ETL/ELT concepts.
- Excellent listening, interpersonal, written, and oral communication skills.
- Expert analytical, conceptual and critical thinking skills.
- Ability to work independently as well as within a team.
Preferred Qualifications
- Experience with machine learning and artificial intelligence.
- Familiarity with higher education policies, procedures, data systems and IT infrastructure.
Education
Required Qualifications
- Bachelor's degree in Information Systems, Computer Science, Engineering or other related area.
Preferred Qualifications
- Advanced degree in related field.
Job Title
Applications Programmer 4
Job Code
000652
Salary Grade
Grade 24
Payscale:
$130,000 - $150,000
The University of California, Office of the President, is required to provide a reasonable estimate of the compensation range for this role. This range takes into account the wide range of factors that are considered in making compensation decisions including but not limited to experience, skills, knowledge, abilities, education, licensure and certifications, and other business and organizational needs. It is not typical for an individual to be offered a salary at or near the top of the range for a position. Salary offers are determined based on final candidate qualifications and experience. The full salary range shows the growth potential for this position and the pay scale is the budgeted salary or hourly range that the University reasonably expects to pay for this position.
Benefits: For information on the comprehensive benefits package offered by the University visit: Benefits of Belonging
ADDITIONAL INFORMATION
This position is eligible for a remote work arrangement within the state of California, and with ability to be on-site in Oakland, CA as needed for work related purposes. The selected candidate must reside within the state of California or be willing to relocate.
HOW TO APPLY
Please be prepared to attach a cover letter and resume with your application.
APPLICATION REVIEW DATE
The first review date for this job is
September 27, 2024. The position will be open until filled.
CONDITIONS OF EMPLOYMENT
Background Check Process: Successful completion of a background check is required for this critical position. Background check process at UCOP
Smoke Free Work Environment: The University of California, Office of the President, is smoke & tobacco-free as of January 1, 2014. UC Smoke & Tobacco Free Policy
As a condition of employment, you will be required to comply with the University of California Policy on Vaccination Programs, as may be amended or revised from time to time. Federal, state, or local public health directives may impose additional requirements.
EEO STATEMENT
The University of California, Office of the President, is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age or protected veteran status. For the University of California’s Affirmative Action Policy please visit: https://policy.ucop.edu/doc/4010393/PPSM-20. For the University of California’s Anti-Discrimination Policy, please visit: https://policy.ucop.edu/doc/1001004/Anti-Discrimination.
The University of California, Office of the President, strives to make this job board accessible to any and all users. If you have comments regarding the accessibility of our website or need assistance completing the application process, please contact us at: Accessibility or email the Human Resource Department at: epost@ucop.edu.
