Reporting to the Executive Director, the Data Analyst (Analyst) assists in the planning, designing, data analysis and reporting of various data sets and surveys that focus on Indigenization, Equity, Diversity, Inclusion, Accessibility and Anti-racism (I-EDIAA) at Queen’s University. The Analyst will be technologically innovative and skilled with a strong background in developing technical reports, data summaries, training materials, and interactive data products, grounded in an understanding of the structural disadvantages experienced by marginalized communities.
• Develops and maintains I-EDIAA ad-hoc reports, dashboards and visualizations.
• Manages, collects, reviews and analyzes data from internal and external sources, as required to support business requirements and information needs and to complete both internal and external reporting requirements on an annual and ad hoc basis such as the Federal Contractors Program (FCP) and the Accessibility for Ontarians with Disabilities Act (AODA).
• Clean and validate Human Resources Information System data to ensure accuracy, completeness, and uniformity.
• Liaises with other internal Units to meet requests for I-EDIAA information. Internal Units include, but are not limited to, Office of Institutional Research and Planning, Human Resources, and Information Technology Services. Also, develops and provides statistical profiles for external agencies, such as the Federal Contractors Program. Liaises with external agencies, such as Statistics Canada, to acquire specific statistics, research and analysis.
• Works with the Registrar’s Office and OIRP on administering the student applicant census and prepares data for reporting.
• Strategizes with unit leaders on how to collect and translate data and consults with the VPCEI team on the creation of action plans to address any gaps of underrepresentation regarding equity deserving groups.
• Manages the ICOUNT Equity Census and employment equity hiring data , timelines, and communications with academic and administrative professionals.
• Performs data analysis using statistics and modeling and disseminates to clients; Prepares reports and visualizations for the Employment Equity Reporting programs.
• Provides statistical and programming expertise to support projects.
• Understands the university’s internal policies and procedures, and ethics implications, ensuring alignment with best practices in survey design.
• Assists in assessing the quality of data collection and ensuring distributed information is verified and of the highest possible quality.
• Assist in the ongoing development of training materials and internal administration processes related to I-EDIAA data and surveys.
• Translates complex and/or disparate needs, inquiries and data sources into easily understood and measurable responses and reports.
• Stays current with relevant literature and advances in technologies; maintains an understanding of the university’s strategic goals and contributes to the development of the institutional evidence base for I-EDIAA initiatives.
• Investigates new data and analytics technologies, and may assist with developing pilots or prototypes for new solutions.
• A university degree with a core focus on statistical methods, such as mathematics and statistics, computer science, quantitative analysis for the social sciences, or a related field.
• Experience with data analysis, modeling and BI tools, such as:
o SPSS, Power BI, Tableau or other Business Intelligence and analytics tools
o Microsoft Office application skills including MS Excel using pivot tables
• Experience with web based applications, survey applications; capacity and performance monitoring.
• Demonstrated commitment to principles of Indigenization equity, diversity, inclusion, accessibility and human rights for equity deserving groups.
• Extensive knowledge of current and sound practices with respect to advancing equity, diversity, inclusion, accessibility and human rights practices within a decentralized institutional environment, such as a postsecondary institution.
• Sound knowledge of Federal and Provincial legislations related to I-EDIAA in the workplace.
• Experience doing presentations and an ability to convey technical and statistical information to a non-technical audience; demonstrated ability to critically analyze quantitative data to generate meaningful and contextually appropriate findings regarding equity-deserving groups.
• Understanding of software development processes focused on the maturation of business requirements into system solutions with a high degree of quality expectations.
• Some understanding of the concepts of data governance and knowledge management.
• Sensitivity to issues containing confidential information.
• Excellent verbal and written communication skills including experience writing technical documentation.
• Consideration may be given to an equivalent combination of education and experience.
• Knowledge of university structure, procedures, policies and systems and how they impact on the functioning of the Office of VPCEI.
• Actively listens to the concerns of others. Demonstrates a strong ability to gather factual details before responding. Whether in person or in writing, takes a careful approach when sharing complex information to ensure the explanation is understood.
• Actively engages the customer or team member and evaluates their needs in a timely manner. Establishes plans and organizes work to meet or exceed the deadlines. Periodically, conducts plan reviews and provides an update to client/customer and recommends any process efficiencies.
• Takes an active role in analyzing problems regarding resources/deliverables that may impact deadlines or standards and escalates for discussion and resolution. Plans medium-term requirements and provides insight into scope of potential problems and identifies possible solutions.
• Takes an active role to identify ways to improve department processes, and quality of customer service. Seeks to understand how to become more effective in own position. Participates in continuous learning by acquiring new knowledge that will add value to self and team.
• Actively works to address quality problems by sharing concerns with team and manager. Understands the details of the problem and identifies solutions. Seeks to understand the nature of (new/existing) assignments as it relates to own role and the expected results.
• Takes an active role to positively support team members through change. Supports change by generating new ideas and offering suggestions that will benefit the team.
• Determines which data, reports and analyses are required under legal and regulatory requirements such as those of the FCP and AODA, and determine how to distribute and present the information clearly and effectively for the University community including individuals with institutional responsibilities within a decentralized environment.
• Analyzes quantitative and qualitative data, summarizing information and making sound conclusions regarding policy in the areas of I-EDIAA.
• Determine how to contact and collect data for reporting requirements.
• Makes recommendations for improvements and efficiencies for monitoring and ensuring compliance.
• Recommends options for decision making on data architecture, design and development unit-wide.
• Allocates own time to ensure tasks are completed by deadline, and provides input into prioritization of future tasks.
• Assesses appropriate “fit” of technical solutions relative to functional requirements, conformance to University standards.
• Determines when to advise or involve Executive Director for complex or sensitive issues.