Job Listings

Data Solutions, Analyst

Company:
The University of Arizona
Job Location:
Tucson, Arizona
Category:
Programmer/Analyst

Posting Number: req10017

Department: ALVSCE Administration

Location: Main Campus

Address: Tucson, AZ USA

Position Highlights

The Data Solutions Analyst is part of the Planning, Consulting, and Data Solutions Team (PCDST) in the Division Business Services (DBS) office of the Division of Agriculture, Life and Veterinary Sciences, and Cooperative Extension (ALVSCE), which is comprised of three colleges. The Team operates in a strategic partnership with Division leadership across mission areas in support of decision-making processes, including those in financial, academic, personnel, and research planning, amongst other areas.
The Team is responsible to support the Division's Strategic Plan, Division-level activity-based financial planning, and Arizona Board of Regents (ABOR) metrics along with playing a pivotal role in the analysis, development, maintenance, documentation, and improvement of administrative/business processes required for reporting to ALVSCE leadership, department heads, business managers, federal agencies, and other external entities.
The Planning, Consulting & Data Solutions Team (PCDST) is crucial in ALVSCE to achieving goals and missions while progressing the Division to be increasingly more collaborative, pro-active, knowledgeable, and nimble with client-oriented and innovative approaches to analyses and product deliveries. The Data Solutions Analyst is expected to deliver effective and efficient solutions as well as help explain the "why" and "how" with data so that meaningful and actionable forecasts and predictions can occur, not simply providing data descriptions of the past or current states.

Outstanding UA benefits include health, dental, and vision insurance plans; life insurance and disability programs; paid vacation, sick leave, and holidays; UA/ASU/NAU tuition reduction for the employee and qualified family members; state and optional retirement plans; access to UA recreation and cultural activities; and more!

The University of Arizona has been recognized for our innovative work-life programs. For more information about working at the University of Arizona and relocations services, please click here.

Duties & Responsibilities

While this is a higher-level position that requires appropriate aptitude and background, candidates do not need to exhibit performance in all of the following duties, and this position will be part of a team that is expected to cross-train and continually learn from each other. 

Analysis - Descriptive, Predictive, and Meaningful

  • Provide predictive and/or nuanced modeling and recommendations for administrators to understand relationships and assess "what-if" scenarios for strategic financial, academic, personnel, and research planning.
  • Collect, analyze, and manipulate data to discover meaning and insight. Examine past performance and identify patterns by evaluating trends to facilitate decision making, planning, and improve processes.
  • Develop final products/tools, visualizations, or reports that effectively and meaningfully communicate with and support decision makers.
  • The PCDST analyst ensures that often complex, disparate, and large data sets are integrated and accurate (correctness), precise (consistency), and complete for each deliverable.
  • Provide regular reporting, including for: NIFA, NIH, Program Review, RCM/AIB, ABOR, All Funds, Faculty Review, Market Analysis, Promotion and Tenure, etc.

User-Centric Solutions

  • Create and develop innovative tools across multiple platforms to solve existing issues and improve current processes, both technically and organizationally, and help progress the Division and its efforts to pursue its Instruction, Research, and Land Grant missions. These solutions include the creation of dashboards, web applications, and utilization of SaaS systems using varied products and platforms. Such tools are leveraged for process improvement and increasing overall efficiency of operations. The creation of such deliverables requires interactions with all levels of employees in the organization, from general end-users to executive leadership.
  • Seek advice, input, and involvement from all levels of ALVSCE employees to continually refine analyses and data gathering processes for effectiveness and efficiency. This includes improving current efforts so they can be consolidated, more efficient, more communicative, and employ the best and most practical qualitative and quantitative methods, both technical and statistical.
  • Improve programmatic, system, or business processes for optimized workflow and efficiency.
  • In order to provide user-centric solutions, the PCDST analyst actively researches new technology tools and platforms (e.g., Tableau, MS Power BI, MS Power Apps, MS Forms, MS Flow, MS Visual Studio Code, Drupal, Planner, Smartsheet, Qualtrics, STATA, SAS, SPSS) to implement and provide a tailored experience to end-users.

Data and Database Management

  • Maintain Division/College database server (MS SQL Server) with merged data from different resources. Effectively work with Division/College IT team to ensure data security.
  • Implement ETL (Extract, Transform, and Load) and data warehouse modeling techniques to optimally organize and structure data in the Division database server.
  • Develop automated/scheduled processes to retrieve and update data as well as examine data accuracy and consistency.
  • Gather, analyze, and document processes to utilize the University's central information warehouse and business intelligence using SQL and other methods.
  • Combine local data sets with the institutional data sets (e.g., local surveys, local lookup tables, etc.) to support Division/department-level definition and metrics, often de/normalizing data sets and ensuring an optimized database infrastructure for expedient and nimble/fluid deliverables.

Recommendations and Decision Support

  • Offer advice and expertise to end-users and stakeholders to further the vision and goals of the ALVSCE in the mission areas of Instruction, Research, and Extension (Land Grant). The PCDST analyst operates in alignment with the university and college/division strategic plan with knowledge of policies to facilitate decision-making. 
  • Understand the sensitivities that exist with data and exercise discretion, confidentiality, and safeguards.

Knowledge, Skills, and Abilities

  • Knowledge and familiarity with enterprise systems that manage personnel, student, financial, research and/or other organizational data.
  • Ability to create meaningful and customer-oriented reports, effective and actionable analyses/models, and impactful visualizations/presentations.
  • Advanced knowledge of spreadsheet, dashboard, or statistical software (such as Excel, Oracle BI, SPSS, SAS, R, STATA, Power BI, Qualtrics, PowerPoint, or Tableau).
  • Demonstrated customer focus through establishment of strong customer relationships and the creation of processes and products from a customer's perspective.
  • Knowledge of database technologies such as SQL, creating queries, working with spreadsheets, administering databases, etc.
  • Strong verbal and written communications skills, including the ability to effectively translate technical information for general and targeted audiences.
  • Ability to provide information, guidance, and strategic insight with tact and diplomacy to a diverse and varied range of employees at many different experience levels.
  • Life-long learner who thrives in fast-paced dynamic team environment.

Minimum Qualifications

  • Bachelor's degree in a field that includes analytical, statistical, or technical components, such as the following fields: Management Information Systems, Business/Data Analytics, Computer Science, Engineering, Economics, Chemistry, or Cognitive Science
  • Eight years of experience in business management, business analysis, systems analysis, financial analysis, Institutional Research, statistics, economics, database management, assessment, and/or applications development

Preferred Qualifications

  • Advanced experience with features of Microsoft Excel in particular, such as advanced use of formulas, pivot tables, Visual Basic, macros, and complex graphing, to build workbooks to assist customers who are familiar with and use the software on a day-to-day basis.
  • Experience with guidelines and policies across subject areas (such as accounting, finances, human resources, academics), preferably in Higher Education and at the University of Arizona.
  • Experience with practical business and workflow modeling, including utilization of guiding principles, especially for effectively communicating technical and organizational processes.
  • Advanced experience with database technologies employing SQL, particularly for Microsoft SQL Server and Oracle databases, including developing queries, scripts, and stored procedures.
  • Experience with administering Microsoft SQL Server (e.g., creating users, roles, schemas, and instances).
  • Experience with statistics, including offering predictive and prescriptive analytics.
  • Experience with tools for building interactive reports such as Microsoft SQL Server Reporting Services and Oracle Business Intelligence Enterprise Edition (OBIEE) or Oracle Analytics Cloud or Oracle Analytics Server (OAS).
  • Experience in implementation of various database methodologies and design guidelines.
  • Experience with web development.
  • Experience with a range of analysis processes from extracting data to integrating, layering, and performing statistical and other advanced analysis in order to build compelling visualizations and interpretations that can be easily communicated with target audiences.
  • Experience with the enterprise systems that University of Arizona uses:
    o    UAccess Employee (Oracle PeopleSoft)
    o    UAccess Student (Oracle PeopleSoft)
    o    UAccess Financials (Kuali Financials and Oracle Financials Cloud)
    o    UAccess Research (Kuali Coeus)
    o    Experience with dashboards and automated notifications ("Agents") in OBIEE / Oracle Analytics Cloud / Oracle Analytics Server
    o    Experience extracting data from a central backend data warehouse (such as the University of Arizona's named "EPM")

FLSA: Exempt

Full Time/Part Time: Full Time

Number of Hours Worked per Week: 40

Job FTE: 1.00

Work Calendar: Fiscal

Job Category: Planning and Analysis

Benefits Eligible: Yes - Full Benefits

Rate of Pay: $76,000 - $87,000

Compensation Type: salary at 1.0 full-time equivalency (FTE)

Grade

10

Career Stream and Level

PC4

Job Family

Data Analysis

Job Function

Planning & Analysis

Type of criminal background check required: Name-based criminal background check (non-security sensitive)

Number of Vacancies: 1

Contact Information for Candidates

Brian Berrellez bberrell@email.arizona.edu

Open Until Filled: Yes

Documents Needed to Apply: Resume and Cover Letter

Diversity Statement

At the University of Arizona, we value our inclusive climate because we know that diversity in experiences and perspectives is vital to advancing innovation, critical thinking, solving complex problems, and creating an inclusive academic community. As an Hispanic-serving institution, we translate these values into action by seeking individuals who have experience and expertise working with diverse students, colleagues, and constituencies. Because we seek a workforce with a wide range of perspectives and experiences, we provide equal employment opportunities to applicants and employees without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity, or genetic information. As an Employer of National Service, we also welcome alumni of AmeriCorps, Peace Corps, and other national service programs and others who will help us advance our Inclusive Excellence initiative aimed at creating a university that values student, staff and faculty engagement in addressing issues of diversity and inclusiveness.

This website is part of the HigherEdJobs network.