University of Minnesota
Data Analyst
University of Minnesota, Minneapolis, Minnesota, United States, 55400
Apply for Job
Job ID
364630Location
Twin CitiesJob Family
Administration-GeneralFull/Part Time
Full-TimeRegular/Temporary
RegularJob Code
9341A1Employee Class
Acad Prof and AdminAdd to Favorite Jobs
Email this Job
This position is not eligible for visa sponsorship.Position Overview:University Data and Institutional Reporting (UDIR) is a unit within Institutional Analysis (IA) having, among other duties, primary responsibility for authoritative institutional data, reporting, and analysis for the University of Minnesota system. UDIR's portfolio includes a wide range of data and reporting activities including the production of official data required for the University's compliance reporting efforts (e.g. IPEDS, NCAA, MN OHE, HLC), related reporting dashboards (e.g. https://idr.umn.edu), decision support for university leadership, ad hoc data requests, and ensuring the integrity of official institutional data.This data analyst position reports to the team lead of the Data and Reporting Group within UDIR. UDIR is searching for a data analyst to join an established team to address the data and reporting needs primarily related to human resources and cost pool areas. It is responsible for designing, building, and delivering data and reporting solutions for a variety of highly-complex, mission critical projects within UDIR's portfolio, with a particular focus on human resource data-related topics including but not limited to producing data that leads to official HR headcounts, the completion of state, federal and local HR surveys, and in responding to a range of internal and external ad hoc data requests. In addition, this position is responsible for producing institutional data used in the University management process referred to as the cost pools. These cost pools include data from a number of subject areas such as student enrollment, human resources, and sponsored projects expenditures.Given its scope of responsibility, UDIR data projects are often collaborative endeavors, and so this position will alternate between serving as primary and secondary analyst depending on the project.Salary Range: $86,000 - $108,000This is a hybrid role, working in office as needed.Duties/Responsibilities:Responsibilities include but are not limited to:20% - Critical Reports and Projects
Creates human resources (HR) snapshot data used to produce official University data, reporting and statistics for human resources subject areas.Serve as primary analyst, to produce selected critical reports and projection jobs to include official HR headcounts, used in System Wide Strategic Plan MPact 2025 Metrics, the Accountability report, and many state, federal and local reports and surveys.Participate and cooperate with data exchange consortia to which the University belongs.Cross train with others in UDIR to effectively function in either a primary or secondary analyst role in performing the suite of HR related critical reports, projects and production jobs including other HR related compliance work.Prepares headcount data used by the Budget Office in preparing data used in the Cost Pool process that calculates aggregate student, and HR headcounts by college and department.
30% - High Visibility Reports and Surveys
Responsible for human resources-related reporting around salaries, demographics, and other descriptive statistics general HR related high visibility reports.Complete selected Association of American Universities Data Exchange (AAUDE) survey items related to administrators, faculty, and graduate students.Responsible for completing several external surveys such as the College and University Professional Association for Human Resources (CUPA-HR), and the American Association of University Professors (AAUP), and others.In collaboration with the Office of Human Resources work to prepare workforce metrics for Board of Regents presentations.Other selected high visibility reports, and surveys as assigned.
40% - Ad Hoc Data Requests
Provide reporting at the request of senior leaders of the University in a timely manner.Provide accurate and timely reports to internal and external audiences.Prepare and submit institutional and campus reports that include human resources, student enrollments, and general student subject areas reporting.Develop data and reporting solutions for ad hoc data requests that involve new metrics or are not well defined or are considered advanced data requests.Ongoing refinement of code/processes to improve efficiencies in ad hoc and cyclical data request processes.
10% - Special Projects
Participate in special projects that may include projects such as the Systemwide Strategic Plan, the Accountability report, and others as needed.Participates in advancing the operational, and strategic direction of the office.Prepares requirements documentation for complex systems, and data integrations to address advanced data and reporting needs.Employ emerging data science techniques and methods to activate new and large data sets of importance to the University.
The responsibilities of this position include but are not limited to the above. The employer reserves the right to change or assign other duties to this position.QualificationsRequired Qualifications (please document on the resume):Bachelor's degree with at least 6 years of experience.Demonstrated experience in SQL and database management systems such as Oracle, MySQL / MariaDB, SQL Server, PostgreSQL, etc, or AWS/Azure equivalents.Experience working with large enterprise data warehouses or business intelligence systems.Demonstrated experience promoting a diverse, inclusive and respectful workplace.Ability to work collaboratively and across disciplines with administrators, faculty, staff, and students from a wide range of programs and backgrounds.Preferred Qualifications (please document on the resume):Advanced degree in a relevant field.Demonstrable experience with Oracle PL/SQL.At least 2 years relevant experience in a higher education environment, including but not limited to management of information systems, academic planning, policy analysis, program review, or institutional research.Experience with PeopleSoft products such as Campus Solutions, Human Capital Management (HCM), and Financials.Demonstrated experience working with University of Minnesota data systems / environments.Familiarity with higher education data reporting processes pertaining to compliance / regulatory efforts and other common mission critical reporting tasks, e.g., IPEDS, Common Data Set, etc.Excellent oral and written communication skills, including the ability to synthesize and translate complex information when sharing findings or explaining data nuances to a variety of audiences.Strong critical thinking skills, including demonstrated ability to approach problems objectively, draw conclusions, and develop recommendations.Experience working with data governance functions and processes.Experience working without supervision while managing multiple deadlines and priorities.Familiarity with University of Minnesota data policies, processes, and operations.About the DepartmentInstitutional Analysis is a unit within the Office of Budget & Finance at the University of Minnesota. Reporting offices and functions include the University Data & Institutional Reporting (UDIR), University Survey and Assessment Services (USAS), Enterprise Data Management and Reporting (EDMR), Enterprise Constituent Resource Management (CRM) and the MyU Portal.BenefitsWorking at the UniversityAt the University of Minnesota, you'll find a flexible work environment and supportive colleagues who are interested in lifelong learning. We prioritize work-life balance, allowing you to invest in the future of your career and in your life outside of work.The University also offers a comprehensive benefits package that includes:Competitive wages, paid holidays, and generous time offContinuous learning opportunities through professional training and degree-seeking programs supported by the Regents Tuition Benefit ProgramLow-cost medical, dental, and pharmacy plansHealthcare and dependent care flexible spending accountsUniversity HSA contributionsDisability and employer-paid life insuranceEmployee wellbeing programExcellent retirement plans with employer contributionPublic Service Loan Forgiveness (PSLF) opportunityFinancial counseling servicesEmployee Assistance Program with eight sessions of counseling at no costEmployee Transit Pass with free or reduced rates in the Twin Cities metro areaPlease visit the Office of Human Resources website for more information regarding benefits.How To ApplyApplications must be submitted online. To be considered for this position, please click the Apply button and follow the instructions. You will be given the opportunity to complete an online application for the position and attach a cover letter and resume.Additional documents may be attached after application by accessing your "My Job Applications" page and uploading documents in the "My Cover Letters and Attachments" section.To request an accommodation during the application process, please e-mail employ@umn.edu or call (612) 624-8647.DiversityThe University recognizes and values the importance of diversity and inclusion in enriching the employment experience of its employees and in supporting the academic mission. The University is committed to attracting and retaining employees with varying identities and backgrounds.The University of Minnesota provides equal access to and opportunity in its programs, facilities, and employment without regard to race, color, creed, religion, national origin, gender, age, marital status, disability, public assistance status, veteran status, sexual orientation, gender identity, or gender expression. To learn more about diversity at the U: http://diversity.umn.eduEmployment RequirementsAny offer of employment is contingent upon the successful completion of a background check. Our presumption is that prospective employees are eligible to work here. Criminal convictions do not automatically disqualify finalists from employment.About the U of MThe University of Minnesota, Twin Cities (UMTC)The University of Minnesota, Twin Cities (UMTC), is among the largest public research universities in the country, offering undergraduate, graduate, and professional students a multitude of opportunities for study and research. Located at the heart of one of the nation's most vibrant, diverse metropolitan communities, students on the campuses in Minneapolis and St. Paul benefit from extensive partnerships with world-renowned health centers, international corporations, government agencies, and arts, nonprofit, and public service organizations.At the University of Minnesota, we are proud to be recognized by the Star Tribune as a Top Workplace for 2021, as well as by Forbes as Best Employers for Women and one of America's Best Employers (2015, 2018, 2019, 2023), Best Employer for Diversity (2019, 2020), Best Employer for New Grads (2018, 2019), and Best Employer by State (2019, 2022).
#J-18808-Ljbffr
Job ID
364630Location
Twin CitiesJob Family
Administration-GeneralFull/Part Time
Full-TimeRegular/Temporary
RegularJob Code
9341A1Employee Class
Acad Prof and AdminAdd to Favorite Jobs
Email this Job
This position is not eligible for visa sponsorship.Position Overview:University Data and Institutional Reporting (UDIR) is a unit within Institutional Analysis (IA) having, among other duties, primary responsibility for authoritative institutional data, reporting, and analysis for the University of Minnesota system. UDIR's portfolio includes a wide range of data and reporting activities including the production of official data required for the University's compliance reporting efforts (e.g. IPEDS, NCAA, MN OHE, HLC), related reporting dashboards (e.g. https://idr.umn.edu), decision support for university leadership, ad hoc data requests, and ensuring the integrity of official institutional data.This data analyst position reports to the team lead of the Data and Reporting Group within UDIR. UDIR is searching for a data analyst to join an established team to address the data and reporting needs primarily related to human resources and cost pool areas. It is responsible for designing, building, and delivering data and reporting solutions for a variety of highly-complex, mission critical projects within UDIR's portfolio, with a particular focus on human resource data-related topics including but not limited to producing data that leads to official HR headcounts, the completion of state, federal and local HR surveys, and in responding to a range of internal and external ad hoc data requests. In addition, this position is responsible for producing institutional data used in the University management process referred to as the cost pools. These cost pools include data from a number of subject areas such as student enrollment, human resources, and sponsored projects expenditures.Given its scope of responsibility, UDIR data projects are often collaborative endeavors, and so this position will alternate between serving as primary and secondary analyst depending on the project.Salary Range: $86,000 - $108,000This is a hybrid role, working in office as needed.Duties/Responsibilities:Responsibilities include but are not limited to:20% - Critical Reports and Projects
Creates human resources (HR) snapshot data used to produce official University data, reporting and statistics for human resources subject areas.Serve as primary analyst, to produce selected critical reports and projection jobs to include official HR headcounts, used in System Wide Strategic Plan MPact 2025 Metrics, the Accountability report, and many state, federal and local reports and surveys.Participate and cooperate with data exchange consortia to which the University belongs.Cross train with others in UDIR to effectively function in either a primary or secondary analyst role in performing the suite of HR related critical reports, projects and production jobs including other HR related compliance work.Prepares headcount data used by the Budget Office in preparing data used in the Cost Pool process that calculates aggregate student, and HR headcounts by college and department.
30% - High Visibility Reports and Surveys
Responsible for human resources-related reporting around salaries, demographics, and other descriptive statistics general HR related high visibility reports.Complete selected Association of American Universities Data Exchange (AAUDE) survey items related to administrators, faculty, and graduate students.Responsible for completing several external surveys such as the College and University Professional Association for Human Resources (CUPA-HR), and the American Association of University Professors (AAUP), and others.In collaboration with the Office of Human Resources work to prepare workforce metrics for Board of Regents presentations.Other selected high visibility reports, and surveys as assigned.
40% - Ad Hoc Data Requests
Provide reporting at the request of senior leaders of the University in a timely manner.Provide accurate and timely reports to internal and external audiences.Prepare and submit institutional and campus reports that include human resources, student enrollments, and general student subject areas reporting.Develop data and reporting solutions for ad hoc data requests that involve new metrics or are not well defined or are considered advanced data requests.Ongoing refinement of code/processes to improve efficiencies in ad hoc and cyclical data request processes.
10% - Special Projects
Participate in special projects that may include projects such as the Systemwide Strategic Plan, the Accountability report, and others as needed.Participates in advancing the operational, and strategic direction of the office.Prepares requirements documentation for complex systems, and data integrations to address advanced data and reporting needs.Employ emerging data science techniques and methods to activate new and large data sets of importance to the University.
The responsibilities of this position include but are not limited to the above. The employer reserves the right to change or assign other duties to this position.QualificationsRequired Qualifications (please document on the resume):Bachelor's degree with at least 6 years of experience.Demonstrated experience in SQL and database management systems such as Oracle, MySQL / MariaDB, SQL Server, PostgreSQL, etc, or AWS/Azure equivalents.Experience working with large enterprise data warehouses or business intelligence systems.Demonstrated experience promoting a diverse, inclusive and respectful workplace.Ability to work collaboratively and across disciplines with administrators, faculty, staff, and students from a wide range of programs and backgrounds.Preferred Qualifications (please document on the resume):Advanced degree in a relevant field.Demonstrable experience with Oracle PL/SQL.At least 2 years relevant experience in a higher education environment, including but not limited to management of information systems, academic planning, policy analysis, program review, or institutional research.Experience with PeopleSoft products such as Campus Solutions, Human Capital Management (HCM), and Financials.Demonstrated experience working with University of Minnesota data systems / environments.Familiarity with higher education data reporting processes pertaining to compliance / regulatory efforts and other common mission critical reporting tasks, e.g., IPEDS, Common Data Set, etc.Excellent oral and written communication skills, including the ability to synthesize and translate complex information when sharing findings or explaining data nuances to a variety of audiences.Strong critical thinking skills, including demonstrated ability to approach problems objectively, draw conclusions, and develop recommendations.Experience working with data governance functions and processes.Experience working without supervision while managing multiple deadlines and priorities.Familiarity with University of Minnesota data policies, processes, and operations.About the DepartmentInstitutional Analysis is a unit within the Office of Budget & Finance at the University of Minnesota. Reporting offices and functions include the University Data & Institutional Reporting (UDIR), University Survey and Assessment Services (USAS), Enterprise Data Management and Reporting (EDMR), Enterprise Constituent Resource Management (CRM) and the MyU Portal.BenefitsWorking at the UniversityAt the University of Minnesota, you'll find a flexible work environment and supportive colleagues who are interested in lifelong learning. We prioritize work-life balance, allowing you to invest in the future of your career and in your life outside of work.The University also offers a comprehensive benefits package that includes:Competitive wages, paid holidays, and generous time offContinuous learning opportunities through professional training and degree-seeking programs supported by the Regents Tuition Benefit ProgramLow-cost medical, dental, and pharmacy plansHealthcare and dependent care flexible spending accountsUniversity HSA contributionsDisability and employer-paid life insuranceEmployee wellbeing programExcellent retirement plans with employer contributionPublic Service Loan Forgiveness (PSLF) opportunityFinancial counseling servicesEmployee Assistance Program with eight sessions of counseling at no costEmployee Transit Pass with free or reduced rates in the Twin Cities metro areaPlease visit the Office of Human Resources website for more information regarding benefits.How To ApplyApplications must be submitted online. To be considered for this position, please click the Apply button and follow the instructions. You will be given the opportunity to complete an online application for the position and attach a cover letter and resume.Additional documents may be attached after application by accessing your "My Job Applications" page and uploading documents in the "My Cover Letters and Attachments" section.To request an accommodation during the application process, please e-mail employ@umn.edu or call (612) 624-8647.DiversityThe University recognizes and values the importance of diversity and inclusion in enriching the employment experience of its employees and in supporting the academic mission. The University is committed to attracting and retaining employees with varying identities and backgrounds.The University of Minnesota provides equal access to and opportunity in its programs, facilities, and employment without regard to race, color, creed, religion, national origin, gender, age, marital status, disability, public assistance status, veteran status, sexual orientation, gender identity, or gender expression. To learn more about diversity at the U: http://diversity.umn.eduEmployment RequirementsAny offer of employment is contingent upon the successful completion of a background check. Our presumption is that prospective employees are eligible to work here. Criminal convictions do not automatically disqualify finalists from employment.About the U of MThe University of Minnesota, Twin Cities (UMTC)The University of Minnesota, Twin Cities (UMTC), is among the largest public research universities in the country, offering undergraduate, graduate, and professional students a multitude of opportunities for study and research. Located at the heart of one of the nation's most vibrant, diverse metropolitan communities, students on the campuses in Minneapolis and St. Paul benefit from extensive partnerships with world-renowned health centers, international corporations, government agencies, and arts, nonprofit, and public service organizations.At the University of Minnesota, we are proud to be recognized by the Star Tribune as a Top Workplace for 2021, as well as by Forbes as Best Employers for Women and one of America's Best Employers (2015, 2018, 2019, 2023), Best Employer for Diversity (2019, 2020), Best Employer for New Grads (2018, 2019), and Best Employer by State (2019, 2022).
#J-18808-Ljbffr