Junior Data Analyst

Role Responsibilities

Reporting to the Reporting & Data Analyst, the Junior Data Analyst provides analytical support for Housing Division operating and capital programs. The position is responsible for analyzing and interpreting program data, supporting the development of reporting and business intelligence products, maintaining data quality and integrity, and assisting program areas in translating business needs into meaningful analytical requirements. The role helps ensure decision-makers have access to accurate, timely, and reliable information to support program oversight, performance monitoring, operational planning, and policy development. The position aligns closely with the Digital and Business Solutions mandate of supporting reporting, analytics, and evidence-based decision-making across Housing programs.

The job responsibilities include:
1. Data Analysis and Interpretation
This position analyzes and interprets data related to Housing's operating and capital programs to support informed program management and policy development. This work is undertaken to ensure decision-makers have access to accurate, relevant, and meaningful information.
Key responsibilities include:
•    Aggregating data from multiple primary and secondary sources to answer defined business and program questions.
•    Applying established analytical methodologies to identify trends, patterns, variances, and emerging issues.
•    Interpreting analytical findings within the context of business processes, program objectives, and operational priorities.
•    Conducting quantitative and qualitative analysis to support operational decision-making and policy discussions.
•    Preparing clear and concise summaries of findings, observations, and recommendations for non-technical audiences.
•    Supporting evidence-based planning through the provision of accurate and actionable insights.

2. Reporting and Analytical Product Development
This position supports the development and maintenance of analytical products that enable consistent and reliable reporting across Housing programs. This work ensures timely access to standardized information to support program oversight and performance monitoring.
Key responsibilities include:
•    Assisting in the development, maintenance, and enhancement of data models, datasets, and Power BI reporting solutions.
•    Creating dashboards, reports, and visualizations that communicate program performance, trends, outcomes, and progress.
•    Supporting enhancements to reporting tools to improve functionality, accessibility, and user experience.
•    Collaborating with program areas to ensure reporting products meet business needs and reporting requirements.
•    Testing, validating, and verifying analytical outputs prior to release to ensure accuracy and consistency.
•    Supporting the creation of standardized reporting processes and performance measures across Housing programs.

Role Responsibilities 2

3. Data Quality and Integrity
This role supports data quality and integrity activities to ensure analytical outputs are accurate, reliable, and suitable for decision-making. This work is critical to maintaining confidence in program information and reporting products.
Key responsibilities include:
•    Supporting data collection, validation, cleansing, and quality assurance activities.
•    Identifying data quality issues, inconsistencies, and gaps and escalating concerns as appropriate.
•    Assisting with the investigation and resolution of data discrepancies in collaboration with analysts and business users.
•    Applying established data standards, business rules, and validation practices to ensure consistency of information.
•    Supporting ongoing monitoring of data quality and reporting accuracy.
•    Contributing to the development and maintenance of reliable and trusted data assets.

4. User Engagement and Requirements Support
The position participates in user engagement activities to support translating program and business needs into analytical requirements. This work ensures analytical products are relevant, fit-for-purpose, and aligned with operational and strategic objectives.
Key responsibilities include:
•    Participating in discussions with program staff and users to understand reporting and analytical needs.
•    Assisting with the documentation of business requirements, assumptions, business definitions, and reporting specifications.
•    Supporting the translation of business questions into analytical and technical requirements under the guidance of senior analysts.
•    Communicating analytical considerations, assumptions, limitations, and risks to users as appropriate.
•    Building positive working relationships with program areas to support a client-focused approach to analytics and reporting.
•    Contributing to the identification and prioritization of reporting and information needs.

5. Documentation and Knowledge Management
This position develops and maintains analytical documentation to support transparency, continuity, and effective management of data assets. This work ensures analytical products can be understood, maintained, and reused over time.
Key responsibilities include:
•    Developing and maintaining data dictionaries, metadata, business definitions, and documentation related to data sources.
•    Documenting analytical methodologies, calculations, business rules, assumptions, and data processing activities.
•    Maintaining organized project documentation, meeting records, requirements documentation, and supporting materials.
•    Supporting consistent documentation standards and practices across reporting and analytical initiatives.
•    Assisting with knowledge-sharing activities that support effective use of analytical tools and information assets.

Role Responsibilities 3

6. Continuous Improvement and Innovation
This role contributes to the ongoing improvement of analytical practices, reporting processes, and data management approaches. This work supports increased efficiency, consistency, and effectiveness in the use of data across Housing programs.
Key responsibilities include:
•    Identifying opportunities to streamline reporting, data preparation, and analytical processes.
•    Supporting the adoption of standardized reporting practices and data collection approaches.
•    Assisting with the implementation and refinement of analytical tools, dashboards, and reporting solutions.
•    Sharing observations, lessons learned, and improvement opportunities with the analytical team.
•    Participating in testing, evaluation, and continuous improvement activities related to analytical products and processes.
•    Supporting initiatives that enhance organizational data literacy and evidence-based decision-making.

The Job Description is provided for Further details on 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.

Systems Thinking
•    Consider inter-relationships between programs, data sources, policies, and operational activities.
•    Seek insight into the implications of different reporting, analytical, and business options.
•    Analyze long-term outcomes with a focus on program goals, organizational priorities, and public value.
•    Identify emerging issues, potential risks, and unintended consequences that may affect decision-making.
•    Support solutions that align with Housing Division objectives and broader government priorities.

Creative Problem Solving
•    Ask thoughtful questions to understand business problems and reporting requirements.
•    Look for opportunities to improve analytical processes, reporting tools, and data quality practices.
•    Explore different approaches and identify lessons learned from previous projects and initiatives.
•    Gather diverse perspectives and relevant data to support informed recommendations.
•    Contribute innovative ideas that improve efficiency, consistency, and the use of information across programs.

Agility
•    Take initiative to improve work processes and analytical practices.
•    Anticipate and adapt to changing priorities, business requirements, and organizational needs.
•    Remain calm, organized, and effective when managing multiple priorities and deadlines.
•    Seek advice, support, and feedback to continuously improve your work.
•    Work creatively within established guidelines, policies, and standards to achieve results.

Build Collaborative Environments
•    Leverage the skills, expertise, and knowledge of colleagues and users.
•    Build respectful and productive working relationships across program areas.
•    Genuinely value diverse perspectives and learn from others' experiences and expertise.
•    Support open communication and constructive resolution of differing viewpoints.
•    Recognize and appreciate the contributions of team members and partners.

Develop Self and Others
•    Seek feedback and work with your supervisor to support ongoing professional development.
•    Reflect on your performance and identify opportunities to strengthen your skills and knowledge.
•    Share insights, lessons learned, and best practices with colleagues.
•    Contribute to a supportive team environment that encourages learning and growth.
•    Help build organizational capacity through collaboration, mentoring, and knowledge transfer.

Qualifications

Minimum Recruitment Standards
University graduation in Data Science, Computer Science, Information Systems and Business Analytics; no experience required; or equivalent as described below.

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.

The following experience is required: 
•    A strong analytical mindset with the ability to learn new technologies, tools, and analytical methodologies quickly. 
•    Experience analyzing, organizing, and interpreting information to support business decision-making. 
•    Practical experience developing basic reports, dashboards, or visualizations using Power BI. 
•    Ability to manage and organize technical documentation, business requirements, and analytical materials in a structured and efficient manner. 
•    Strong written and verbal communication skills, including the ability to present information clearly and concisely. 
•    Demonstrated ability to collaborate effectively in a team environment and build positive working relationships. 
•    Strong attention to detail and commitment to producing accurate, high-quality work. 
•    Ability to prioritize competing demands, manage multiple tasks, and meet established deadlines. 
•    Proficiency with Microsoft Office applications, particularly Excel, Word, and PowerPoint.

The following experience is considered as assets:
•    Experience working within the Alberta Public Service, broader public sector, or a complex organizational environment. 
•    Experience supporting housing, social services, infrastructure, capital planning, or public policy programs. 
•    Familiarity with Power BI data models, DAX calculations, and dashboard design principles. 
•    Experience preparing technical documentation, data dictionaries, metadata, or process documentation. 
•    Knowledge of business analysis, requirements gathering, or user engagement practices. 
•    Experience using analytical tools such as Power BI, SQL, Excel Power Query, Microsoft Fabric, or similar business intelligence solutions. 
•    Coursework or certification in data analytics, business intelligence, statistics, information management, or related disciplines. 
•    Demonstrated commitment to continuous learning and professional development in analytics and data management.

The following experience will be given preference:
•    Experience supporting reporting, analytics, or business intelligence initiatives. 
•    Experience working with Power BI, including creating reports, dashboards, data visualizations, and performance metrics. 
•    Experience gathering, documenting, or organizing business and reporting requirements. 
•    Experience working with data collection, validation, data quality, or data management processes. 
•    Experience supporting program reporting, performance measurement, or operational analysis. 
•    Exposure to SQL, relational databases, Microsoft Fabric, or other data and reporting technologies. 
•    Experience working with cross-functional teams to support business objectives and reporting needs. 
•    Knowledge of analytical best practices, reporting standards, and data governance principles.

Minimum recruitment standards outline the minimum education and experience required for appointment to a job classification. 

Notes

Hours of work are 08:15 AM to 04:30 PM, Monday to Friday. This is a full-time temporary position until December 31, 2027, working 36.25 hours per week.

Location: The work location is at 44 Capital Boulevard – 10044 108 Street NW, Edmonton

If a security screening is required:
•    Final candidates may be required to undergo a criminal records check (CRC).

A cover letter outlining how your experience relates to the qualifications of this role is required. In your cover letter, please briefly summarize:
      1) How your professional and/or academic background relates to this role, including your direct and transferable expertise and skills.
      2) Reason(s) for interest in this role.

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 we have to offer: 
•    Working for the Alberta Public Service
•    Public Service Pension Plan (PSPP)  
•    Alberta Public Service Benefit Information  
•    Professional learning and development  
•    Research Alberta Public Service Careers tool  
•    Positive workplace culture and work-life balance.