Integrity Analyst

JANA Corporation

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

Posted 11/10/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 data staging, transformation, and validation using SQL, alongside strong analytical skills for interpreting complex data sets. Proficient in risk analysis and engineering solutions, with a solid foundation in client-facing roles and software implementation.

Highest-signal resume keywords

SQL Data StagingRisk AnalysisEngineering Solutions DevelopmentClient-Facing Software ImplementationAdvanced Mathematical Techniques

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

SQLData TransformationData ValidationRisk ModelingReliability ModelingFault Tree AnalysisWeibull AnalysisRoot-Cause AnalysisEngineering CalculationsStatistical Techniques

Soft Skills

Organizational SkillsMultitaskingTime ManagementVerbal CommunicationWritten CommunicationPresentation SkillsTeam Collaboration

Tools & Technologies

MS SQL ServerOracleDB2TeradataMicrosoft Suite

Industry Keywords

Pipeline OperationsRisk ManagementData QualityData GovernanceClient Training

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 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 directly with client business users for demonstrations, project meetings, implementation workshops, and training
Train clients on risk models and assessment of client risk

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 like Oracle, DB2, Teradata, etc.
Experience with advanced mathematical and statistical techniques
Proficiency in the Microsoft Suite, including spreadsheet models, relational databases, and presentations
Pipeline operations or risk management knowledge an asset
Solid organizational skills, including multitasking and time-management
Exceptional verbal, written, and presentation skills
Ability to work effectively both 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

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