Senior Data Analyst

Role Responsibilities

Reporting to the Manager, Child Care Data Analysis 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 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. This position is key to support the data collection, analysis and reporting function of the Ministry related to Early Learning and Child Care initiatives, including the Bilateral Agreement and the Canada-Alberta Canada-Wide ELCC Agreement.

Responsibilities include:

• Engage in complex data collection, extraction, analysis and reporting/presentation for the ELCC Initiatives.  
• Track data results, analyze trends and prepare monthly, quarterly and annual reports. 
• Engage in reviews of internal and external data sources to ensure the integrity of the system used, the data and information provided.  These reviews may involve seeking input from individuals internal and external to the Ministry. Verify and evaluate adequacy of data sources, rationale, limitations, and references, alerting PIEPM Management and the Director of any issues identified.
• Specialize in data management for cross-ministry outcome measurement and reporting, including development of a reporting strategy to collect data for approved indicators/measures and prepare monthly, quarterly and annual reports on results.
• Coordinate responses to ad hoc data requests within the Branch.
• Support intra-ministry and cross-ministry initiatives by developing innovative methods of data collection and analysis, ensuring proper data standards and research methods are employed, and by contributing to the design and data-maintenance of web-applications, including leading the identification and creation of new datasets for both external applications and internal analysis.
• Shape the delivery of ECD analysis and reporting:
• Apply methodologies and analysis in accordance with rapidly changing industry standards.
• Provide expertise and advice on ECD analysis and industry data considerations for effective decision making. 
• Lead the design, production, automation and maintenance of statistical publications and reports that address ECD information needs. 
• Develop mechanisms to enhance the understanding of and the exchange of ECD information and inter-jurisdictional insights to support evidence-based planning and decision-making. 
• 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.

Systems Thinking - Leads collaborative efforts within the unit to reduce duplication and raise efficiency.

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 Environments - Strong interpersonal and facilitation skills to build capacity and develop effective working relationships with stakeholders internal and external to the ministry.

Qualifications

University graduation in Data Science, Economics, Statistics, Mathematics or a related field plus 4 years progressively responsible related experience; or equivalent as described below. A Master's degree in a related field (e.g., Data Science, Economics, Statistics, Mathematics) is preferred

Equivalency: 

Directly related education or experience considered on the basis of:
 
•    1 year of education for 1 year of experience; or 
•    1 year of experience for 1 year of education. 

Assets and skills required:

• 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.
• 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

This is a full-time permanent position working 36.25 hours per week, Monday to Friday, 8:15am – 4:30pm

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.