Integrity Data Analyst - Risk Modeling & Data Governance

JANA; Toronto; Hybrid; CAD 60,000 - 80,000; Full time

Job summary

A pipeline integrity consulting firm in Toronto is looking for Integrity Analysts to create data staging and validation scripts. The role involves assessing data sources and conducting risk analysis on pipeline assets. Candidates should have a STEM degree and up to 3 years of client-facing software implementation experience. Excellent communication and organizational skills are essential. The company offers comprehensive benefits, a collaborative environment, and supports work-life balance.

Benefits

Comprehensive benefits package

Healthcare Spending Account

Employee Assistance Program

Social events

Phantom Share Program

Annual bonuses

Qualifications

• Undergraduate degree in a STEM field, preferable in Engineering.
• 1 - 3 years of client facing and software implementation experience.
• 1 – 3 years’ experience in MS SQL Server or another RDBMS like Oracle.
• Proficiency in developing spreadsheet models and presentations.
• Strong organizational and multitasking skills.

Responsibilities

• Create data staging, transformation, and validation scripts using SQL.
• Assess effectiveness and accuracy of new data sources.
• Identify trends and patterns in complex data sets.
• Support data quality and governance improvement opportunities.
• Perform risk analysis on specific pipeline assets.

Skills

Client facing experience

Software implementation

MS SQL Server

Advanced mathematical techniques

Microsoft Suite proficiency

Organizational skills

Verbal communication

Written communication

Education

Undergraduate degree in a STEM field

Tools

SQL

Relational databases

Job description

A pipeline integrity consulting firm in Toronto is looking for Integrity Analysts to create data staging and validation scripts. The role involves assessing data sources and conducting risk analysis on pipeline assets. Candidates should have a STEM degree and up to 3 years of client-facing software implementation experience. Excellent communication and organizational skills are essential. The company offers comprehensive benefits, a collaborative environment, and supports work-life balance.