Integrity Analyst

JANA has a progressive culture of personal and professional growth. With a vested interest in each employee’s professional growth and continuous improvement as an individual, JANA supports professional development, continuous education, industry participation and technical accreditations. Other Perks that come with joining JANA’s Team include:

- High-energy Collaborative Environment: JANA combines the energy of a start-up software organization with the discipline of a precision engineering firm.
- Regular Social Events: Join the entire JANA Team for fun Social Events like our Weekly Kahoot and Social Club, Annual Birthday Bonspiel, Ice Cream Parties, Holiday events, Cinco de Mayoeven an Easter Egg Hunt
- Best-in-Class Benefits: JANA offers all employees a comprehensive benefits package including Medical, Dental, Vision, Life Insurance, Disability coverage, as well as our great Wellness Benefit
- Giving Back: JANA is dedicated to giving back to our community in various ways. Every year 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 (combination of in-office and work-from-home), JANA employees are able to take time to rest and rejuvenate

Members of JANA’s Delivery Pods, JANA’s Integrity Analysts - Delivery work to cleanse and transform client data for use in assessing and adjusting our existing JANA models to be in line with client specific information and factors. JANA's Integrity Analysts - Delivery, will focus on the transformation of data and refining of our risk models to perform risk analysis on specific pipeline assets. The Integrity Analyst - Delivery will execute on the engineering aspects of software implementations.

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