Integrity Analyst

As an entrepreneurial company, we provide an exciting, dynamic and respectful work environment where you will be an important contributor to the JANA Team. Our Mission at JANA is “Better Pipelines for a Better World” - we are true believers and inspire our employees to join us in this Mission
- High-energy Collaborative Environment: JANA combines the energy of a start-up software organization with the discipline of a precision engineering firm.

- Social Events: Join the entire JANA Team for fun virtual Social Events like our Beer Club. We also like to get together for in-person events such as our Annual Birthday Bonspiel, Holiday events, our annual Company Picnic, and team events

- Best-in-Class Benefits: JANA offers all employees a comprehensive benefits package including a Healthcare Spending Account, Medical, Dental, Life Insurance, AD&D, Drug coverage, Disability coverage, as well as a Wellness Benefit JANA also provides employees with the opportunity to get support with mental wellness through our Employee Assistance Program.

- Giving Back: JANA is dedicated to giving back to our community. We hold an annual food drive for the Aurora Foodbank and have become one of their top contributors

- JANA promotes a healthy work-life balance: Through our comprehensive vacation program, floater days, and a hybrid work environment (up to 20% a month in office) JANA employees are able to take time to rest and rejuvenate

- Employee Recognition: We aim to Win, and we love to celebrate Wins with our People. We also offer a Phantom Share Program and annual bonuses

JANA’s Integrity Analysts - Delivery are responsible for the creation of data staging, transformation, and validation scripts. They work on data assessment, governance and subsequent improvement recommendations and implementation. The Integrity Analyst will be key in identifying risks and threats through their analysis of asset specific information. They must be able to multi-task and work cross-functionally, communicating to all parties involved.

**Responsibilities**:

- Assists in the creation of 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 client and industry data (structured and unstructured).
- Writes reports and provides quality peer-review and release of reports, as required
- Ensures pipeline integrity related issues are appropriately addressed in risk modeling approaches
- Performs risk analysis on specific pipeline assets
- Reviews and analyzes asset specific information to identify risks and threats
- Performs detailed engineering calculations
- Executes on engineering aspects of Integrity Management software implementations
- Meets directly with client's business users for demonstrations, project meetings, implementation workshops and training
- Provides training for clients on the risk models and their assessment of the client’s risk

Required Skills & Experience

- Undergraduate degree in a STEM field, preferable 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, with experience developing 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