DATA ANALYTICS DEVELOPER Location:
Oakland Job ID:
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 PresidentDEPARTMENT 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 Infrastructure, Reporting 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.Responsibilities
<table border='0' cellpadding='0' cellspacing='0' style='border-collapse:collapse; margin-left:-.2in'>
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 new solutions, up to and including the most complex.
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.
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.
Overall responsibility for proper configuration of production and non-production reporting and analytic environments, including the management of updates and patches to keep software platforms current, and provides on-going production support. Develops end-user training and materials. Conducts training sessions as necessary. May lead a team of reporting and analytic development professionals. Required Qualifications
- At least 8 years of experience writing complex SQL, PL/SQL queries.
- At least 7 years of experience working with users in requirements gathering, developing and implementing analytics solutions and developing documentation.
- At least 7 years of development experience with at least one of the following technologies: Tableau Desktop, IBM Cognos.
- At least 7 years of Tableau Server development and administration.
- 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
- 4 or more years of experience working in higher education.
- Advanced understanding of database, data warehousing and ETL/ELT concepts.
- Has excellent listening, interpersonal, written, and oral communication skills.
- Excellent interpersonal and communication skills.
- Expert analytical, conceptual and problem solving skills.
- Ability to work independently as well as within a team.
- Experience with machine learning and artificial intelligence.
- Familiarity with UCOP and IRAP policies, procedures, data systems and IT infrastructure.
- Advanced degree in related field.
SPECIAL CONDITIONSSALARY AND BENEFITS
- B.S. in Information Systems, Computer Science, engineering or other technical areas which provide analysis and programming or equivalent experience.
Salary: $137,000 - $159,500
commensurate with experience.
Benefits: For information on the comprehensive benefits package offered by the University visit: Benefits of BelongingADDITIONAL INFORMATIONHOW 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 1, 2021. 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 PolicyEEO 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. EEO/AA Employer UC Nondiscrimination Policy
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: email@example.com
*LI-SG1 To apply, visit https://careerspub.universityofcalifornia.edu/psp/ucop/EMPLOYEE/HRMS/c/HRS_HRAM.HRS_APP_SCHJOB.GBL?Page=HRS_APP_JBPST&Action=U&FOCUS=Applicant&SiteId=19&JobOpeningId=22408&PostingSeq=1