2Business Intelligence Specialist (BUS INTEL SPEC 3)

Under general direction, provide database administration support, report development, and analytical support to the Office of Research. Member of a multi-function team supporting the processing of and reporting on data related to proposal and award management, research compliance and reporting, and other subjects managed by the Office of Research IT team. This data and reporting supports the Office of Research and the campus's institutional effectiveness, planning, decision making, and policy formation.

The incumbent will be responsible for working with team members supporting, designing, and implementing processes and procedures to acquire, process and store data into databases supporting the units reporting and integration needs. Responsible for assisting team with data analysis and dissemination of data in a usable and appropriate format for its intended use. Responsible for working with team members, business users, management and executive leadership to design and implement reports using a wide variety of technologies.

Advocate for and implement best practice approaches in data collection, data analysis, data governance and reporting. Advocate for standardization to achieve reduced complexity and increased efficiency for OR and the campus where needed and appropriate. Maintain system of documentation containing data dictionaries, design documentation, and technical documentation related to all work and data that is the responsibility of the unit. Maintain confidentiality with issues and materials reviewed and/or managed and exercise a high level of discretion and judgement in dealing effectively with all parties.

Work with team project management and supervisor to effectively manage project tasks and timelines. Research, prepare and present project information, the unit's work and other topics to clients via demonstrations, written documentation, and other methods.

Apply By Date: January 2, 2025

Qualifications

Minimum Qualifications

For full consideration, applicants are encouraged to upload license, certification and/or educational degree if required of the position.

• Extensive experience performing quantitative data analysis for multiple audiences with different knowledge levels and business needs.
• Extensive experience making use of relational databases and using standard features such as SQL, stored procedures, and functions to manage and prepare data as needed for reporting, data management or other needs.
• Experience writing and deploying dashboards and reporting using Tableau
• Knowledge and experience with MS-Office and related products - in particular Access and Excel. Experience creating reports that output to excel. Experience extracting and reporting on data from access databases, text files in a variety of formats including CSV. Experience using Microsoft's SSMS.
• Analytical skills to extract, integrate, compile and analyze large data sets from diverse sources.
• Writing editing and proofing skills to generate correspondence, documentation, reports and other documents that reflect the high standards and professionalism of the unit and Office of Research.
• Organization and time management skills to coordinate multiple projects and tasks simultaneously in an environment where priorities and deadlines can and do change based on business priorities and needs.

Preferred Qualifications

• 5 - 10 years of work experience demonstrating knowledge of quantitative research methods and technical skills developing and supporting business reporting for a large organization.
• BS or higher degree in economics, mathematics, statistics, business or a related field.
• Experience working at a large public research university, preferably within the context of grant management, compliance or other area related to research administration.
• Experience interpreting campus policy and procedures governing research administration.
• Experience with MS SQL Server such as job scheduling and execution, common table expressions (CTE), query optimization, T-SQL stored procedures and queries.
• Experience writing and deploying jobs using Microsoft's SSIS or similar product.
• Experience with a variety of relational database systems such as Oracle, MS SQL Server, Postgres, etc.
• Experience with database systems such as MongoDB or other no-sql database.

Key Responsibilities

• 30% - DATA MANAGEMENT AND ANALYSIS
• 30% - REPORTING
• 20% - REPORTING/DATABASE PROGRAMMING
• 20% - ADMINISTRATION SUPPORT

Department Overview

The Office of Research (OR) is charged with advancing the research mission of the campus, which includes services and resources that enhance research and other creative endeavors, relationships with government and industry, policy compliance, and oversight of an infrastructure of organized research. The OR oversees over 22 organized research units, special research programs and projects, and central facilities with approximately 1,119 employees, $137 million in annual expenditures across multiple fund sources, and annual recharge income activity of $22 million. The OR also administers the campus' research support programs of approximately $2.7 million annually. The central administration units of OR (Business and Finance, Human Resources, Innovation Access, Institutional Review Board, Interdisciplinary Research Support, Marketing and Communications, OR Technology, Office of Corporate Relations, Research Compliance and Integrity and Sponsored Programs) are comprised of approximately 167 employees.

Position Information

• Salary or Pay Range: $82,900.00 - $152,900.00 /annual
• Salary Frequency: Monthly
• Salary Grade: 23
• UC Job Title: BUS INTEL SPEC 3
• Number of Positions: 1
• Appointment Type: Career
• Percentage of Time: 100%
• Shift Hours: Manager will advise
• Location: Remote
• Union Representation: No
• Benefits Eligible: Yes
• Hybrid/Remote/On-Site: Remote

Benefits

Outstanding benefits and perks are among the many rewards of working for the University of California. UC Davis offers a full range of benefits, resources and programs to help you bring your best self to work, as well as to help you and your family achieve your health, wellness, financial and career goals. Learn more about the benefits and eligibility rules by visiting Benefits Summary for UC Davis Health Employees or Benefits Summary for UC Davis Employees and our Benefits Page.

If you are represented by a union, benefits are negotiated between the University of California (UC) and your union and finalized in a contract. Read your bargaining unit's employment contract, stay abreast of current negotiations and learn about collective bargaining at UC: https://ucnet.universityofcalifornia.edu/labor/bargaining-units/index.html

• High quality and low-cost medical plans to choose from to fit your family's needs
• For eligible roles, UC pays for Dental and Vision insurance premiums for you and your family
• Extensive leave benefits including Pregnancy and Parental Leave, Family & Medical Leave
• Paid Holidays annually as stipulated in the UC Davis Policies or Collective Bargaining Agreement
• Paid Time Off/Vacation/Sick Time as stipulated in the UC Davis Policies or Collective Bargaining Agreement
• Continuing Education (CE) allowance and Education Reimbursement Program as stipulated in the UC Davis Policies or Collective Bargaining Agreement
• Access to free professional development courses and learning opportunities for personal and professional growth
• WorkLife and Wellness programs and resources
• On-site Employee Assistance Program including access to free mental health services
• Supplemental insurance offered including additional life, short/long term disability, pet insurance and legal coverage
• Public Service Loan Forgiveness (PSFL) Qualified Employer & Student Loan Repayment Assistance Program for qualified roles
• Retirement benefit options for eligible roles including Pension and other Retirement Saving Plans. More information on our retirement benefits can be found here
• UC Davis cares about building a community, which is why we provide resources to enhance diversity, equity and inclusion as well as Employee Resource Groups (ERGs) to support our staff

Work Environment

• Work occasional evenings and weekends to avoid end-user downtime and to meet deadlines.
• Employee is personally responsible for following safety guidelines and procedures.
• The Smoke and Tobacco Free Environment policy is intended to provide a healthier, safer, and more productive work and learning environment for the entire UC community. The University of California prohibits smoking and tobacco use at all University owned or leased properties, or facilities operated by UC staff or faculty. Smoking and tobacco use are strictly prohibited in indoor and outdoor spaces, parking lots, residential space, and University vehicles. https://ucdavispolicy.ellucid.com/documents/view/271

Special Requirements - Please contact your recruiter with questions regarding which activities apply by position

• This is a critical position, as defined by UC policy and local procedures, and as such, employment is contingent upon clearing a criminal background check(s) and may include drug screening, medical evaluation clearance, and functional capacity assessment. To learn more about our background check program, visit: https://hr.ucdavis.edu/departments/recruitment/ucd/selection/background-checks

Misconduct Disclosure Requirement: As a condition of employment, the final candidate who accepts a conditional offer of employment will be required to disclose if they have been subject to any final administrative or judicial decisions within the last seven years determining that they committed any misconduct; received notice of any allegations or are currently the subject of any administrative or disciplinary proceedings involving misconduct; have left a position after receiving notice of allegations or while under investigation in an administrative or disciplinary proceeding involving misconduct; or have filed an appeal of a finding of misconduct with a previous employer.

Diversity, Equity, Inclusion and Belonging

At UC Davis, we're solving life's most urgent challenges to bring a fuller, healthier, and more resilient world within reach. We grow from every challenge we take on and we don't just maintain - we improve. We recognize that creating an inclusive and intellectually vibrant organization means understanding and valuing both our individual differences and our common ground. The most comprehensive solutions come from the most diverse minds, and you belong here. As you consider joining UC Davis, please explore our Principles of Community, our Clinical Strategic Plan and strategic vision for research and education, and our latest efforts to outgrow the expected. The University of California, Davis 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.

Because we want you to be seen, our recruiting process at UC Davis fosters authenticity, diversity, and inclusion. Studies have shown that some people may not apply to jobs unless they meet every single qualification. Each unique role at UC Davis has a set of requirements and you could be perfect for this role, or you could be perfect for the next role! Don't meet all the requirements? We still encourage you to apply! #YouBelongHere