Data Analyst

STV, Inc.; Noel Road; On-site; CAD 30,000 - 50,000; Full time

Job summary

An innovative firm is seeking a skilled Data Analyst to join their team, contributing to a significant infrastructure project valued at $3-$5 billion. This role will focus on transforming complex project data into actionable insights, optimizing reporting processes, and ensuring data integrity across systems. The Data Analyst will leverage advanced analytics and visualization techniques to create compelling dashboards and reports using PowerBI. With structured onboarding and mentorship, this position offers a unique opportunity to build expertise in data analytics and process automation while collaborating with cross-functional teams. If you're passionate about data and eager to make a meaningful impact, this role is perfect for you.

Benefits

Health insurance

Dental insurance

Vision insurance

401(k) Plan

Paid Time Off (16 days)

Paid Holidays (8 days)

Parental Leave

Continuing Education Program

Professional Licensure

Employee Assistance Program

Qualifications

• 3+ years of experience in data analysis and business intelligence.
• Strong proficiency in PowerBI for creating dashboards and visualizations.
• Experience with SQL for data extraction and manipulation.

Responsibilities

• Transform project data into actionable insights through advanced analytics.
• Develop dashboards and reports using PowerBI to communicate metrics.
• Automate data workflows using Python/R to improve reporting efficiency.

Skills

Data Analysis

Business Intelligence

PowerBI

Python

R

SQL

Problem Solving

Education

Bachelor's degree in Data Analytics

Bachelor's degree in Information Systems

Bachelor's degree in Computer Science

Bachelor's degree in Engineering

Tools

PowerBI

SQL

Python

R

Job description

dental insurance, life insurance, vision insurance, parental leave, paid time off, paid holidays, 401(k)

STV is seeking a Data Analyst to support a $3-$5 billion dollar project in managing and analyzing project data to enhance decision-making for high-quality infrastructure projects. This role will be integral in developing data-driven insights, optimizing reporting processes, and ensuring data integrity across project management systems. The Data Analyst will receive structured onboarding and mentorship to progressively build expertise in data analytics, visualization, and process automation within the project.

Responsibilities:

Transform project data into actionable insights through advanced analytics and visualization techniques

Develop comprehensive dashboards and reports using PowerBI to communicate key performance metrics effectively

Collaborate with cross-functional teams to identify data-driven opportunities and establish best practices

Automate data workflows using Python/R to improve efficiency in reporting and analytics

Maintain data integrity by identifying and resolving inconsistencies across project management information systems

Support the integration of multiple data sources (ex. project management information systems and common data environments) to create unified reporting solutions

Create visualizations that tell compelling stories about project performance for both technical and non-technical stakeholders

Required Experience

Bachelor's degree in Data Analytics, Information Systems, Computer Science, Engineering, or related field

3+ years of experience in data analysis and business intelligence, preferably in project environments

Strong proficiency in PowerBI for creating advanced dashboards and interactive visualizations

Demonstrated experience with Python or R for data processing, analysis, and workflow automation

Experience with SQL for data extraction and manipulation from various database systems

Exceptional skill in transforming complex data into compelling narratives, with proven ability to present insights at conferences and stakeholder meetings

Strong problem-solving skills with experience handling large datasets from multiple sources

Engage directly with clients to understand their needs and respond effectively to impromptu requests for data analysis and reporting

Hands-on experience integrating multiple data sources into unified reporting solutions

Experience with data preprocessing of both structured and unstructured information

Preferred Qualifications

Experience with transportation and/or infrastructure projects and programs

Knowledge of Project Management Information Systems (PMIS)

Knowledge of data governance and reporting compliance standards

Demonstrated ability to work independently while collaborating effectively with diverse teams

Familiarity with geospatial analytics and mapping visualization techniques

Proficiency with PowerBI Report Builder for creating custom reporting solutions

Document analytical methodologies for knowledge transfer and reproducibility

Don't meet every single requirement? Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. At STV, we are fully committed to expanding our culture of diversity and inclusion, one that will reflect the clients we serve and the communities we work in, so if you're excited about this role but your past experience doesn't align perfectly with every qualification in the job description we encourage you to apply anyways. You may be just the right candidate for this or other roles.

STV offers the following benefits * Health insurance, including an option with a Health Savings Account * Dental insurance * Vision insurance * Flexible Spending Accounts (Healthcare, Dependent Care and Transit and Parking where applicable) * Disability insurance * Life Insurance and Accidental Death & Dismemberment * 401(k) Plan * Retirement Counseling * Employee Assistance Program * Paid Time Off (16 days) * Paid Holidays (8 days) * Back-Up Dependent Care (up to 10 days per year) * Parental Leave (up to 80 hours) * Continuing Education Program * Professional Licensure and Society Memberships

STV is committed to paying all of its employees in a fair, equitable, and transparent manner. The listed pay range is STV's good-faith salary estimate for this position. Please note that the final salary offered for this position may be outside of this published range based on many factors, including but not limited to geography, education, experience, and/or certifications.