Senior Data Analyst

Role Responsibilities

Reporting to the Manager, Research Evaluation and Reporting, the Senior Data Analyst will support the Early Learning and Child Care (ELCC) Initiatives and will collect, analyze and prepare reports to measure outcomes and indicators. This position is key to supporting the evaluation of the ELCC initiative's effectiveness in increasing the accessibility, affordability and quality of early learning and childcare in Alberta, providing analysis on licensing, grants, spaces, enrollment, fees, subsidy, etc., in conjunction with external demographic data. The position will also collect and analyze data to the outcomes and indicators identified in ELCC evaluation and measurement activities and the Federal/Provincial Child Care Agreements.

Responsibilities include

1. Engage in complex data collection, extraction, analysis and reporting/presentation for the ELCC Initiatives.
2. Track data results, analyze trends, and prepare monthly, quarterly, and annual reports, as well as other reports as required.
3. Engage in reviews of internal and external data sources to ensure the integrity of the system used, the data and information provided.
4. Specialize in data management for cross-ministry outcome measurement and reporting.
5. Support intra-ministry and cross-ministry initiatives by developing innovative methods of data collection and analysis.
6. Apply methodologies and analysis in accordance with rapidly changing industry standards.
7. Lead the design, production, automation and maintenance of statistical publications and reports that address ELCC information needs.
8. Develop mechanisms to enhance the understanding of and the exchange of ELCC information and inter-jurisdictional insights to support evidence-based planning and decision-making.
9. Lead the development of forecasting and economic modeling, scenario planning and gap analysis.

Please click on this link to view the job description for this position.

APS Competencies

Competencies are behaviors that are essential to reach our goals in serving Albertans. We encourage you to have an in depth understanding of the competencies that are required for this opportunity and to be prepared to demonstrate them during the recruitment process.

This link will assist you with understanding competencies:https://www.alberta.ca/system/files/custom_downloaded_images/psc-alberta-public-service-competency-model.pdf.

• Creative Problem Solving - Expertly considers, develops and weighs implications of complex and technical compensation situations before proposing solutions.
• Agility - Maintains an open perspective to changing priorities, timelines and unexpected and un-planned ad hoc requests from either internal or external partners.
• Build Collaborative Environment - Strong interpersonal and facilitation skills to build capacity and develop effective working relationships with stakeholders internal and external to the ministry.
• Systems Thinking - Maintains an awareness of current events and government priorities that may provide challenges and/or opportunities.

Qualifications

University graduation in Data Science, Economics, Statistics, Mathematics or related field plus four years of progressive experience is required; or equivalent as described below.

Equivalency: Directly related education or experience is considered on the basis of one year of education for one year of experience or one year of experience for one year of education.

Knowledge and/or experience of the following are considered assets for this position:

• A Master's degree in a related field (e.g., Data Science, Economics, Statistics, Mathematics) is preferred.
• Proven experience with SQL — ability to write complex queries for data extraction, transformation, and validation.
• Demonstrated proficiency in Power BI, including data modeling and transformation (Power Query and DAX) and designing interactive dashboards and reports.
• Hands-on experience with Databricks, including performing data transformations, and integrating with SQL and Power BI for advanced analytics and reporting.
• Strong experience with Microsoft Excel, including advanced formulas, Power Query, Pivot Tables and data manipulation techniques.
• Hands-on experience with SharePoint data integration, including building and maintaining connections to SharePoint lists and libraries.
• Hands-on experience with ArcGIS mapping and reporting, including creating spatial visualizations, analyzing geospatial data, and integrating GIS outputs with Power BI or Excel for enhanced data insights.
• Experience working with large and complex datasets from multiple sources.
• Experience in automating and optimizing data workflows (e.g., through Power Query or Python).
• Strong knowledge of statistical analysis and quantitative research methods, including the ability to apply statistical techniques to interpret data and support evidence-based decision-making.
• Experience with stakeholder engagement and leading projects to identify data and information needs of stakeholders.
• Strong analytical and problem-solving skills, with the ability to interpret data and translate insights into actionable recommendations.
• Excellent attention to detail, data accuracy, and quality assurance practices.
• Knowledge of evaluation and research practices.
• Excellent verbal and written communication skills.
• Ability to create clear and concise written reports and briefings, executive summaries, action requests, etc.
• Ability to prioritize and work with several competing priorities.

Minimum recruitment standards outline the minimum education and experience required for appointment to a job classification. Refer to https://www.alberta.ca/alberta-public-service-minimum-recruitment-standards.

Notes

There is one permanent, full-time position working 36.25 hours per week, Monday to Friday.

This position is based in Edmonton.

Resumes must include precise employment dates (month and year) details.

Applicants are required to include a cover letter that demonstrates how their education and experience meet the position’s requirements.

Any costs associated with obtaining the required documents/checks as noted or interview travel expenses, will be the responsibility of the candidate. Out-of-province applicants can obtain the required documents/checks from the province they currently reside in.

Links and information on what the GoA have to offer to prospective employees.

• Working for the Alberta Public Service - https://www.alberta.ca/advantages-working-for-alberta-public-service.aspx.
• Public Service Pension Plan (PSPP) - https://www.pspp.ca.
• Alberta Public Service Benefit Information - https://www.alberta.ca/alberta-public-service-benefits.
• Professional learning and development - https://www.alberta.ca/professional-development-support-directive.
• Research Alberta Public Service Careers tool – https://researchapscareers.alberta.ca."
• Positive workplace culture and work-life balance.
• Leadership and mentorship programs.