Serves as Business Intelligence Analyst and will collaborate with customers, staff, and other stakeholders to gather and analyze reporting requirements; will understand complex data sources and underlying data; will write requirements for the design of reports to improve business knowledge and decisions; will work with customers, staff and stakeholders to see the value of HR data and how to use it; performs analysis for a wide range of requests using data in different formats and from various systems; will work with Assistant Director to determine appropriate reporting tool to be used for each request, validate and test reporting solutions, dashboards and analytics; will adhere to functional, development and quality standards; creates, maintains or reviews documentation and user training when required. Will query data as needed to validate requirements and test results. Will provide reports/data to requestors as needed.
Unit Specific Education/Experience/Skills
Knowledge equivalent to that which normally would be acquired by completing a four-year college degree program in Computer Science, Information Systems, Business or related information technology field related to relational database languages with coursework in an information technology specialization related to the area of employment; three to five years of related and progressively more responsible or expansive work experience in Business Intelligence tools such as Oracle SQL, MS SQL, Access and/or Cognos; or an equivalent combination of education and experience.
Business system analytical skills; experience with HR/Payroll data and SAP, data analysis; understanding of HR/Payroll processes and procedures; advanced Excel skills such as VLOOKUPs, conditional formatting, charting, and pivot tables; experience writing complex SQL, experience with Query Manager, good business and communication skills; broad based information technology experience in meeting changing business requirements; experience in testing, data/problem analysis, and resolution; flexible and willing to change direction and priorities.
Required Application Materials
Resume or Curriculum Vitae and Cover letter
Bidding eligibility ends on 2/13/18 at 11:55 PM.
Internal Number: 490422
About Michigan State University
Spartans work every day to advance the common good in uncommon ways.Together, we tackle some of the world?s toughest problems to find solutions that make life better?from alternative energy to better food safety to breakthrough medical and environmental applications achieved through rare isotope research.We teach. We explore and we discover. We collaborate and lead. We innovate, inspire, and empower. We achieve our potential and create circumstances that help our students and others achieve theirs.We're good at it, and we've been at it for more than 150 years.The nation?s pioneer land-grant university, MSU began as a bold experiment that democratized higher education and helped bring science and innovation into everyday life. The revolutionary concept became a model for the nation.Today, MSU is one of the top research universities in the world?on one of the biggest, greenest campuses in the nation. Home to nationally ranked and recognized academic, residential college, and service-learning programs, we?re a diverse community of dedicated students and scholars, athletes and artists, scientists and leaders.In ways both practical and profound, we work to create a stronger, more sustainable, and more hopeful future for all.