Data Solutions Analyst

Role Responsibilities

Are you an experienced data architect who enjoys building powerful, scalable systems that support public service? As a Data Solutions Analyst with the Alberta Office of Statistics and Information (OSI), you will be involved in the design and evolution of enterprise data systems that support decision-making across government. Your work will directly support policies and programs that impact Albertans every day.

Reporting to the Manager, Data Services, the Data Solutions Analyst builds and maintains data pipelines, strengthens analytics infrastructure, and turns complex data into insights senior leaders can rely on.

Data Pipeline & Infrastructure

•    Design, build, and maintain scalable data pipelines to support growing data volume and complexity
•    Develop and maintain ETL/ELT processes and API integrations
•    Clean, structure, and integrate data from multiple internal and external sources into the OSI data warehouse
•    Maintain metadata and ensure data quality, integrity, and accessibility
•    Document data processes and workflows for audit, continuity, and knowledge sharing

Data Security & Governance

•    Implement and oversee data security controls to protect sensitive government information
•    Administer OSI’s secure data analysis lab, including access controls and audit processes
•    Manage data-sharing agreements and ensure compliance with privacy and security requirements

Analytics & Decision Support

•    Build data tools, reports, and visualizations that support policy, program, and resource decisions
•    Support data scientists and analysts by enabling efficient access to clean, well-structured data
•    Deploy analytical models into production environments and monitor performance
•    Enhance OSI’s website with interactive data products and visual tools

Stakeholder Support & Collaboration

•    Act as a subject matter expert on data infrastructure and data availability
•    Work with internal and external partners to support data needs and resolve technical issues
•    Represent OSI on cross-ministry data initiatives and infrastructure projects

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.

The competencies that are determined to be essential for this position are:

•    Systems Thinking – Understands how data, systems, and stakeholders connect to support long-term outcomes.
•    Develop Networks – Builds strong relationships across ministries and external partners to advance shared data goals.
•    Agility – Adapts quickly to changing priorities, incomplete information, and emerging data needs.
•    Drive for Results – Delivers reliable, high-quality data solutions that support senior-level decision-making.
•    Build Collaborative Environments – Works effectively with technical and non-technical teams to solve complex problems.
•    Develop Self and Others – Shares knowledge, supports learning, and continuously improves skills and practices.
•    Creative Problem Solving – Designs practical and innovative solutions to unique, complex data challenges.

Qualifications

Requirement:
A university degree in computer science, Information Technology, Applied Mathematics, Statistics, or a related field plus a minimum 4 years of experience working with SQL (advanced SQL required; NoSQL is an asset).

Experience & Technical Skills

•    Hands-on experience with data pipelines, ETL/ELT processes, and data warehousing
•    Hands-on experience with SQL Server, including T-SQL, SSIS, SQL Server Agent, and SSAS Tabular model
•    Experience working with big data platforms
•    Experience working with large, complex, and unstructured datasets
•    Experience using visualization tools such as Power BI
•    Strong understanding of data modeling, data integration, and metadata management
•    Proven ability to work with business users to define data needs
•    Strong written and verbal communication skills

Assets

•    Experience with Cloudera Data Platform
•    Experience building or supporting Apache NiFi, HDFS, and Hive / Hue environments
•    Knowledge of Government of Alberta data, privacy, and security policies
•    Experience supporting cross-functional teams in a fast-paced environment

Please note that all dates listed on the resume must include both a month and a year to ensure inclusion towards noted experience during the screening process.

A cover letter outlining what makes you the ideal fit is required and will be used to help assess your written communication skills.

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 position is a permanent, full-time position working 36.25 hours per week, Monday to Friday.

Location: 
8th floor, Federal Building, 9820 – 107 St NW, Edmonton, Alberta, T5K 1E7

Candidates with lesser qualifications may be considered at a lower classification and salary. This competition may be used to fill future roles at the same or lower classifications.

Candidates may be asked to participate in a written assessment. Final candidates for this position will be asked to undergo a security screening.

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.