Reporting to the Assistant Director, Institutional Research and Planning and working with the Survey Lead and University Rankings Specialist in the Office of Institutional Research and Planning (OIRP), the Survey Data Analyst (‘Analyst’) assists in the planning, designing, data analysis and reporting of various surveys that focus on the student population at Queen’s University. The Analyst will be technologically savvy with a strong background in statistical programming languages and business intelligence tools and will develop technical reports, data summaries, training materials, and interactive data products.
Committed to equity, diversity, inclusion and Indigeneity, the Analyst works alongside DSA and OIRP team members to evaluate survey data to produce high quality and high value reporting in a timely fashion. This requires strong collaboration, communication and interpersonal skills to understand and clarify the questions and needs of information consumers within the Queen’s community.
• Work with the project lead(s) and the OIRP Survey Lead and University Rankings Specialist in the coordination, administration, analysis, and reporting for Queen’s internal and external administrative surveys, including the evaluation of the effectiveness of focused initiatives and interventions.
• Analyze large survey datasets of both qualitative and quantitative information using programming and BI tools.
• Develop and implement databases and provide statistical and programming expertise to support research projects.
• Collect/generate and validate various forms of data from central administrative computing systems. Identify and recommend data improvement opportunities
• Maintain an understanding of data definitions as well as data usage within the administrative applications and how to access and retrieve data for inquiry and reporting purposes.
• Understand the university’s internal survey policies and procedures, and ethics implications, ensuring alignment with best practices in survey design.
• Prepare data submissions, reports and presentations to communicate research findings within and outside the University community.
• Assist in the development of resources and programming for administrative units to evaluate the effectiveness of student-focused initiatives and ensure the university meets provincial standards for quality assurance for all undergraduate and graduate programs at the university.
• Assist in the ongoing development of training materials and internal administration processes related to surveys.
• Assist in the identification and management of survey response and completion initiatives including incentives and prize draws for university surveys.
• An undergraduate degree in a discipline or professional program involving statistics, research methodology and statistical computing.
• Some education or professional exposure to research in the social sciences, public policy and/or finance/economics.
• Several years of experience in a research environment that provided exposure to and familiarity with two or more of statistical/analytical software, mainframe administrative systems, database systems, internet-based research, and research design/project management.
• Proficiency with a variety of survey and analytical tools in support of information analysis and reporting, for example Qualtrics, SPSS, SAS, R, SQL, Nvivo, Statistica, PeopleSoft Query, Excel, Tableau, and other appropriate software and improvements as technologies evolve. Experience with Qualtrics and R are an asset.
• Query experience with PeopleSoft or another enterprise system.
• Some knowledge of, and an ability to quickly acquire greater knowledge of university administrative structures and processes and of the Ontario and Canadian post-secondary systems.
• An ability to work with others in project design and implementation.
• Familiarity and experience with strategies for improving processes – eliminating or consolidating process steps, reducing elapsed time, eliminating waste.
• Analytical, research and problem solving skills
• An ability to work with others, and where required, lead in and make decisions related to project design and implementation;
• Excellent oral and written communication skills including project/program documentation, technical presentation and reporting writing and maintenance of client and team relationships involving individuals at all levels throughout the University;
• The curiosity and initiative to search out new data sources, analysis methods and applications;
• The ability to exercise sound judgment and discretion when dealing with sensitive and confidential information;
• The ability to interpret, synthesize and communicate complex data/information, make recommendations and manage situations, and cope with multiple demands arising from competing priorities within fixed deadlines;
• A degree of self-motivation, resourcefulness and curiosity applied to a high level of work independence.
• Technical skills with the ability to use a variety of solutions – hardware, software, and applications.
• Familiarity with a variety of statistical analysis and reporting packages, such as Access, SAS, JMP.
• Evaluates data sources for accuracy, relevance, utility and validity to ensure high-quality information used in analyses.
• Develops and assesses methodologies for solving analytical and programming problems and makes recommendations for, or implements action.
• Determine appropriate software and analytical tools to provide desired reports.
• Determines appropriate report formats and detail levels for different audiences, and finalizes reports following review by the Project Lead(s) and the OIRP Survey Lead and University Rankings Specialist.
• Identifies and recommends opportunities to modify data/business processes and improve data quality /availability.
• Allocates time, prioritizes tasks and determines workflow to meet expectations and conflicting deadlines.