Job Description: Data Analyst (Digital Transformation Projects) Project Overview
seven (7) Data Analysts
Scope of Services
- Duration: Initial 12-month contract, extendable up to 24 months.
- Commitment: Full-time (7.25-hour workday).
- Workload: Support 2--3 projects concurrently.
- Work Location: Primarily remote, with occasional meetings or work sessions in Edmonton (travel at the Analyst's own cost).
- Travel: Some in-province travel for field research or user interviews may be required.
Responsibilities Data Engineering
- Design, develop, and maintain scalable data pipelines and architectures (on-premises e.g., SSIS, and cloud platforms e.g., Azure, AWS, GCP).
- Ensure data integrity, accuracy, and availability.
- Collaborate with cross-functional teams to understand and implement data requirements.
- Optimize ETL processes and improve data workflows.
- Implement data governance, security best practices, and manage data lakes/warehouses.
- Deploy data solutions across SQL/NoSQL databases.
Data Analytics
- Perform exploratory data analysis to identify trends and actionable insights.
- Develop reports, dashboards, and visualizations using BI tools (e.g., Power BI, SAS VA).
- Conduct statistical analysis and modeling to inform business decisions.
- Create and share service metrics and performance dashboards.
- Support agile teams by delivering service metrics and mentoring on analytics fluency.
- Provide data-driven evidence for corporate priorities.
Work Environment and Facilities
- Remote Work: Analysts must supply their own equipment (computer, software, desk, chair, etc.).
- On-site Work: If required, the Province will provide office space and supplies (excluding computers and software).
Security Requirements
- Must provide a current criminal record check upon request.
- Some assignments (e.g., Justice projects) require Enhanced Security Clearance.
- May require additional clearances, such as RCMP Top Secret Clearance, during the contract.
Mandatory Qualifications Education Experience as Data Analyst/Engineer Experience with cloud platforms (AWS, GCP, Azure) Experience with data marts, warehousing, BI tools Experience querying Microsoft Transact-SQL Server Experience designing/implementing ETL processes
Nice-to-Have Qualifications
Additional Requirements Project Examples
- Overview of project/assignment.
- Sector served (public, private, other).
- Size of the project ($100K, $500K, $1M+).
- Approach used, including design, development, risk mitigation, and communication.
- Skills, tools, and technologies applied.
Project examples must be attached at the bottom of the resume.
