TITLE Business Intelligence Analyst
CLASSIFICATION NUMBER 1645
IMMEDIATE SUPERVISOR Director, Institutional Research
The Business Intelligence Analyst assists the Business Intelligence and Database Analyst in developing initiatives and strategies to improve internal and external reporting efficiencies in the analysis, design, integration, implementation, and maintenance of all systems that support the functions of Institutional Research. The Business Intelligence Analyst develops and maintains a high level of understanding of all aspects of IR reporting, while fully supporting all policies, such as the Family Educational Rights and Privacy Act (FERPA) that regulate disclosure of student data ensuring confidentiality of all processed, stored, or accessed data. The Business Intelligence Analyst understands all aspects of MSU’s student information systems and keeps a clean data environment in IR’s research-related databases, ensuring the development of accurate report deliverables. On an ongoing cycle, the Business Intelligence Analyst assists in the identification of best practices in developing, implementing, and monitoring data quality to ensure data and reporting needs are met in a timely manner. The Business Intelligence Analyst identifies and reports all discrepancies and contributes to the overall success of the IR team by participating in the development and writing of SQL queries to accommodate IR’s needs. The Business Intelligence Analyst provides solutions that assist with campus goals and leads joint design efforts, including streamlining ‘big data analytics’ while continuously defining solutions, troubleshooting, analyzing, and documenting all processes and practices with the goal of supporting decision makers with data-driven validation.
MINIMUM ACCEPTABLE QUALIFICATIONS
Education/Experience: A Bachelor’s degree and two years of experience working in Institutional Research or a related environment or a Master’s degree and one year of experience working Institutional Research or a related environment is required. Experience with state and federal postsecondary reporting is preferred. Experience with database query tools and products is preferred.
Skills: Strong active listening skills and evidence of good verbal and written communications skills are required. A strategic approach to innovative thinking and vision and an adeptness for data visualization and dashboard design are required. The ability to maintain confidentiality in regard to information processed, stored, or accessed is required. Familiarity with data mining and ‘big data analytics’ is required. The ability to develop knowledge of, respect for, and skills to engage with those of other cultures or backgrounds is required. An understanding of database technology and proficiency in handling, organizing, manipulating, storing, and working with large datasets beyond those traditionally handled within a relational system is preferred. The ability to quickly learn, use, and explain preparation software such as PowerBi is preferred. Proficiency with SQL, Power Query, Dax, and Argos is preferred. A functional knowledge of database management systems is preferred.
ESSENTIAL DUTIES AND RESPONSIBILITIES
1. Collaborates closely with the Director, the Business Intelligence and Database Analyst, co-workers, and information technology staff either one-on-one or through interviews, workshops, and/or documentation procedures.
2. Aligns resources with University goals and assists in monitoring the collection and reporting for the Provost’s spotlight and key performance indicators.
3. Participates in the definition, testing, training, implementation, and support of system requirements.
4. Understands the functions supported by the current system.
5. Understands and accommodates the constraints imposed by our current system.
6. Troubleshoots issues quickly and appropriately by identifying immediate remediation, determining the root cause, and collaborating with others to determine a long-term solution.
7. Ensures reporting requirements are understood, agreed to, and signed off at the appropriate stages of each project.
8. Provides an ongoing analysis of processes and workflows including suggestions for improvement.
9. Identifies areas where technology can lead to increased efficiency.
10. Collaborates with the Director, Institutional Research’s Business Intelligence and Database Analyst, and other Institutional Research co-workers to deliver dashboards that provide data to aid in decision making.
11. Assists in the development of dashboards, reporting systems, the Institutional Research data dictionary, and a query repository.
12. Prepares and provides video user documentation for training procedures and processes when needed.
13. Alerts the Director, Institutional Research of potential risks and issues of importance.
14. Contributes to a work environment that encourages knowledge of, respect for, and development of skills to engage with those of other cultures or backgrounds.
15. Remains competent and current through self-directed professional reading, developing professional contacts with colleagues, attending professional development courses, and attending training and/or courses as directed by the supervisor.
16. Supports the overall success of Institutional Research by performing other duties as assigned.
OFFICE OF HUMAN RESOURCES