Data Analyst

Cynet Systems Inc; Edmonton; On-site; CAD 60,000 - 80,000; Full time

Job summary

A leading company is seeking a Data Analyst with a strong background in data analysis and visualization. The role involves developing dashboards, supporting financial planning, and conducting spend analysis to enhance decision-making processes. Candidates should have a bachelor's degree and substantial expertise in relevant tools like Excel, Power BI, and SQL.

Qualifications

• 3+ years of experience in data analysis supporting finance or procurement processes.
• Experience with data extraction, cleansing, and dataset preparation.
• Ability to translate complex data into actionable insights.

Responsibilities

• Develop and share service metrics and performance dashboards.
• Inform teams about data trends and recommend performance metrics.
• Support grants management and financial planning through data analysis.

Skills

Data Analysis

Data Visualization

Attention to Detail

Education

Bachelor’s degree in data science, Statistics, Computer Science, or Finance

Tools

Excel

Power BI

Tableau

SQL

Job description

Job Description:

• Implement, develop, and share service metrics and service performance dashboards of IT projects in relation to spend, progress and risk level or projects.
• Inform project team and leadership about current data trends and performance, and recommend performance metrics to support program delivery and monitoring.
• Research best practices and makes recommendations for the direction of data-driven governance policies to support the adoption of digital services and delivery of services.
• Collaborate with Technology and Innovation (TI) program areas to investigate program needs, understand contract requirements, and support the achievement of program deliverables.
• Develop comprehensive contract inventory and conduct spend analysis to support financial planning and decision-making.
• Prepare contract-level budget justifications and develop optimized contractual spend plans aligned with program objectives.
• Produce comprehensive zero-based budgeting reports to enhance financial transparency and resource allocation.
• Support grants management through data collection and analysis, aiding in compliance and performance reporting.
• Support corporate priorities and data-driven decision making by leveraging existing and new analytics, data visualizations, data models, and storytelling tools
• Other responsibilities as required or requested.

Core Requirements:

• Bachelor’s degree in data science, Statistics, Computer Science, Finance, or a related field.
• 3+ years of experience in data analysis, preferably supporting finance or procurement processes.
• Experience with data extraction, cleansing, and preparing data sets related to contracts, spending, and budgeting.
• Proficiency in data analysis/visualization tools (Excel, Power BI, Tableau) and working knowledge of SQL or other database tools.
• Ability to translate complex financial/operational data into actionable insights for zero based budgeting decisions.
• Experience in preparing dashboards and reports tailored for various audiences.
• Strong attention to detail and commitment to data accuracy and quality.
• Experience supporting business process optimization or financial planning projects preferred.

Scoring Methodology:

• Financial/Pricing: 15%
• Resource Qualifications: 25%
• Interview Process: 60%

Must Have:

• Bachelor's Degree or equivalent experience in a related field, such as Information Technology or Business Yes/No
• Experience creating data visualizations, dashboards, and other information products for clients using BI/analytics software, including any or all: SAS Visual Analytics, SAS Visual Investigator, MS Power BI, Tableau, Looker, R, Python 2 years.
• Direct, hands-on experience performing business requirement analysis, solution architecture and design, and deployment related to data analysis, data analytics, data visualization, data science, data mining 2 years.
• Experience using Microsoft Office Suite tools 3 years.

Nice To Have:

• Experience with presenting data in queries, dashboards, and reports in a way that is easy to understand 3 years.
• Experience analyzing research data and presenting findings in diverse ways 3 years.
• Experience and technical knowledge of Microsoft SQL Server 2 years.
• Experience with government planning and budgeting processes and procedures 3 years.