Data Analyst

Posted on8/11/2017
Job typeFull-time
Reports toDirector of Institutional Research
Reports in officeInstitutional Research
Application due dateAugust 25, 2017
Job start dateSeptember 4, 2017
InstitutionNorthwest Missouri State University
Institution descriptionFounded in 1905, Northwest is a four-year university that offers a broad range of profession-based undergraduate and graduate programs on its Maryville campus as well as a location in Kansas City. With an enrollment of 6,600 students, Northwest was ranked by U.S. News and World Report as the top moderately selective regional university in Missouri for the second consecutive year, and it is one of only four four-year institutions in Missouri to meet all measures of the state's performance-based funding initiative during its first three years.
Northwest boasts a graduation rate that is in the 85th percentile of the University's national peer group. In addition, 97 percent of Northwest bachelor's degree earners and 99 percent of master's degree earners secure employment or continue their education within six months of graduation, according to the most recent data. For more information visit the website at
Job dutiesPRIMARY DUTY: The Data Analyst designs, executes, and documents processes to retrieve, cleanse, load, transform, aggregate, and report data to satisfy user data needs and facilitate completion of federal, state, and other compliance reporting and to support institutional strategic planning. In addition, the analyst performs basic statistical analysis and report writing, designs, and administers surveys. Also serves as the Institutional Research Office operational back-up as needed.

1. Designs and executes data selections to provide accurate and on-time fulfillment of data collections and strategic planning support, including term and annual statistical reports and annual Common Data Set files; Prepares reports and visuals; Documents processes
2. Creates/updates/maintains survey designs, administers survey schedule, monitors response progress, addresses administration issues, prepares data for analysis to support institutional effectiveness and assessment survey projects
3. Designs and executes processes to provide accurate and on-time data collection and display of the Northwest dashboard/scorecard system; Fulfills various external marketing and research surveys and data requests
4. Serves as the Assessment Office operational back-up as needed
5. Utilizes recommended templates, standards, and methodologies in data collection and reporting
6. Participates in professional development activities as available and as appropriate
7. Serves on internal/external committees as assigned
8. Develops and nurtures positive relationships with internal and external stakeholders
9. Promotes the mission, vision, and values of Northwest in all activities
10. Performs other duties as assigned, including but not limited to functioning as operational backup for Institutional Research Office
Education: Bachelor’s degree in Computer Science, Information Technology, or related field
Experience: One year of relational database query and report design or equivalent course work
Skills: Familiarity with relational database design including multi-table query design and report design; familiarity with common database interface applications (i.e. SQL, Microsoft Access); familiarity with Microsoft Office applications such as Word, Outlook, Excel, PowerPoint; ability to think critically; attention to detail and accuracy; ability to meet deadlines; ability to work independently and as a dependable team member

Education: Master’s degree in related field or equivalent experience
Experience: One to two years of data warehouse experience; experience with higher education student information system (i.e. Banner)
Skills: Demonstrated ability in relational database design; familiarity with data warehouse; proficient Excel skills (string and logic functions, linked files); advanced programming skills (outer joins, referential integrity, nested queries); skills with SPSS and Cascade server (web content); familiarity with Tableau; Application of best practice standards in design
Salary rangeDependent on qualifications and experience
Salary benefitsThe Office of Human Resource prides itself in offering a full, competitive benefits package with providers, who we feel, will offer the best service possible to the employees. Full-time employees are offered Health, Dental, Vision, Life and Long-term Disability insurance options as well as retirement plans upon employment at the University. For more information on each of these topics, please visit our website.
Application procedureTo learn more and to apply please visit our website.