Integrity Analyst

JANA Corporation

. Create data staging, transformation, and validation scripts using SQL .

Posted 9/18/2026full-timeAurora • CanadaJunior💰 CA$60,000 - CA$72,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in SQL for data staging, transformation, and validation, alongside strong analytical skills for interpreting complex data sets. Proficient in risk analysis and engineering solutions, with a focus on client engagement and training.

Highest-signal resume keywords

SQL ServerData AnalysisRisk ManagementEngineering SolutionsClient Training

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data StagingData TransformationData ValidationStatistical TechniquesEngineering CalculationsReliability ModelingFault Tree AnalysisRoot-Cause AnalysisSpreadsheet ModelsRelational Databases

Soft Skills

Organizational SkillsMultitaskingTime ManagementVerbal CommunicationWritten Communication

Tools & Technologies

Microsoft SuiteIntegrity Management SoftwareOracleDB2Teradata

Industry Keywords

Pipeline OperationsRisk ModelingData QualityGovernance ImprovementClient-Facing Experience

Tech Stack

Tools & technologies

MS SQL ServerOracleRDBMSSQL

About the role

Key responsibilities & impact

Create data staging, transformation, and validation scripts using SQL
Assess the effectiveness and accuracy of new data sources and data-gathering techniques
Identify, analyze, and interpret trends or patterns in complex data sets
Support data quality and governance improvement opportunities
Work with large volumes of structured and unstructured client and industry data
Write reports and provide quality peer review and report release
Ensure pipeline integrity issues are addressed in risk modeling approaches
Perform risk analysis on specific pipeline assets
Review and analyze asset-specific information to identify risks and threats
Develop engineering solutions using reliability modeling and prediction, Fault Tree Analysis, Weibull Analysis, Root-Cause Analysis, and Root-Cause Failure Analysis
Perform detailed engineering calculations
Execute engineering aspects of Integrity Management software implementations
Meet with client business users for demonstrations, project meetings, implementation workshops, and training
Provide client training on risk models and risk assessments

Requirements

What you’ll need

Undergraduate degree in a STEM field, preferably in Engineering
1–3 years in client-facing and software implementation
1–3 years’ experience in MS SQL Server or another RDBMS such as Oracle, DB2, or Teradata
Experience with advanced mathematical and statistical techniques
Proficiency in the Microsoft Suite
Experience developing spreadsheet models, relational databases, and presentations
Pipeline operations or risk management knowledge is an asset
Solid organizational skills, including multitasking and time management
Exceptional verbal, written, and presentation skills
Ability to work effectively independently and as part of a team
Ability to work on tight deadlines
Must be able to travel in the US and Canada up to 20% of the time
Successful completion of a background check is required as a condition of employment

Benefits

Comp & perks

High-energy collaborative work environment
Virtual and in-person social events
Healthcare Spending Account
Medical coverage
Dental coverage
Life Insurance
AD&D coverage
Drug coverage
Disability coverage
Wellness Benefit
Employee Assistance Program for mental wellness
Comprehensive vacation program
Floater days
Hybrid work environment with up to 20% a month in office
Phantom Share Program
Annual bonuses