Data Analyst - Canada

ReVisionz, a leader in asset & process safety information management, is seeking an experienced Data Analyst to join our team. The primary objective of this role is to utilize advanced programming expertise to efficiently handle substantial volumes of client asset data. This involves analyzing the data to uncover significant insights following predefined criteria and recognizing areas that require attention. Ultimately, the goal is to align this information with the organization's intended information framework. This alignment will facilitate various actions, including enhancing data quality, transitioning to novel solutions, and ensuring seamless integration across diverse systems Our company culture fosters growth and development, making us the ideal place for you to do your best work and grow your career. Here's how you add value:

• Address processing of data off the source databases and fileshares with multiple complex inter-relationships
• Track record in the formalization of findings for developing the path forward for enrichment of data in support of migration processes
• Based on the rules apply regex, parsing and other data processing based on interrogation of the sources to provide necessary outcomes
• Use SQL skills further enabled through such formal computing languages as .NET, Java, Python, etc. to conduct such extraction and data interrogation
• Support the technical Extract/Transform/Load team members who codify process and enrichment rules that are established to address the compliance and gap findings from the analysis and assessments
• Address the normalization of inconsistent data across multiple sources where naming conventions were not applied consistently
• Work with the Content Analysts to establish rules-based processes to extract details from engineering information content and data sources.
• Maintain the plant configuration level tag and document ENS elements.
• Develop load sheets based on Plant Document and Tag Data sets and load them into SDX
• Analyze quality of existing plant engineering content to identify loading issues (file quality, naming inconsistencies, specification compliance, etc.)
• Prepare XL and dashboard reports with which to effectively present findings
• Align the findings with defined rules to identify compliance and gaps.
• Collaborate with the Content Analysts/ Consultants and business subject matter experts to rigorously interrogate the extracted asset information and assess its state against the business rules
• Participate in Content Analyst/Consultant workshops to provide asset information data expertise to enable methods to uncover findings based on the data extractions performed
• Analyze plant specifications and engineering content to identify tag and document naming patterns.

Requirements

• Engineering information standards (e.g., tag and document classification, tag and document metadata, tag and document states)
• 5+ years domain experience in Engineering Document and Information Management Systems for Owner/Operators or EPC’s, including for Tags/Controlled Documentation and the lifecycle of such across project/operations use in facilities
• Strong experience gained through repeated lead data role in sophisticated data analysis projects involving:
• Engineering information management processes
• Extending SQL with .NET programming skills or other such as Java, Python, etc. for addressing specialized extraction, scraping and analysis skills (with .NET is preferred), and
• A background in existing engineering information management system(s) and databases from such solutions as Hexagon, Bentley, Aveva, etc. will be an asset
• Sources vary from strong metadata in sophisticated databases through to fileshares/other sources with only folder/filename without such metadata. Strong background to establish findings in both situations is necessary including folder paths and filenames
• Volume varies significantly. Background is needed for up to high volume data sets
• Experience in the migration of files from sources to destinations in relation to the document objects.
• Skills in creatively establishing coded rules with which to interrogate source data so as to establish compliance and gap findings. Interaction with SMEs to guide them in being able to express the rules is important
• Experience with key role in engagements for engineering and asset information migration as part of solution implementation
• Highly variable sources and data is the norm, as is poor data quality. The candidate must have a proven and demonstrable track record in developing data interrogation automation solutions with which to process large volume sets with high accuracy and efficiency
• Bachelor’s Computer Science, Engineering or Management Information Systems, or related field
• Understanding of the engineering information lifecycle and how this supports Engineering, Construction, C&SU, Operations, Maintenance & Reliability, etc
• Direct domain experience working for Owner / Operators or EPC’s, including:
• Experience with source control of coding used in processing (e.g., Git, SVN, or similar)
• Primary focus on extremely high rates of success on the migration of data/documents and their related metadata
• Applying SQL to datasets upon which to extract, parse and assess the information,

**Applicants must have Permanent Resident status or hold an open work permit in Canada. USA applicants must provide proof of eligibility to work if you are not a US citizen or a Green Card holder.**

We value diversity in our business and encourage responses from all qualified applicants. While we are appreciative of every application we receive, we advise that only candidates under consideration will be contacted.