Integrity Analyst developing SQL data workflows and risk analyses for JANA’s gas pipeline software. Supporting client implementations, engineering calculations, and pipeline integrity improvements.
Responsibilities
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 as required
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
Train clients on risk models and their assessment of client risk
Requirements
Undergraduate degree in a STEM field, preferably in Engineering
1–3 years of experience in client-facing work and software implementation
1–3 years of experience with MS SQL Server or another RDBMS such as Oracle, DB2, or Teradata
Experience with advanced mathematical and statistical techniques
Proficiency in Microsoft Suite, including 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
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, up to 20% a month in office
IT Analyst supporting DealMaker’s online capital - raising fintech platform. Managing IT support, device infrastructure, automation, and security compliance in a hybrid Toronto role.
Senior HRIS Analyst supporting SAP SuccessFactors and Workday operations at PointClickCare, a healthcare technology company. Driving integrations, testing, reporting, and HR transformation readiness.
Buyer/Holdback Release Analyst managing natural gas equipment procurement and supplier negotiations at TC Energy. Supporting construction holdbacks and jurisdiction - specific lien compliance across North America.
Analyst transforming pension and investment data into benchmarking insights for CEM, a global institutional - investor data and insights firm. Validating client submissions, analyzing peer performance, and presenting actionable results.
Senior Insolvency Analyst preparing bankruptcy - related tax returns, refunds, and CRA compliance matters. Supporting BDO Canada’s Personal Debt Solutions Tax Center of Excellence.
Senior Insolvency Analyst preparing insolvency tax returns, investigating refunds, and managing CRA matters for BDO Canada’s personal debt solutions. Supporting accurate filings and estate records across a blended work model.
Ag Lending Analyst assessing credit applications and advising Canadian agriculture customers for FCC. Supporting bilingual lending solutions, collections and partner credit adjudication.
Maximo Technical Data Package Analyst maintaining defence technical data, change workflows, and supply records for Thales. Reconciling Maximo, DRMIS, and government cataloguing systems.