Data Analyst

IT Data Analyst

• Contract Length: 1 Year
• Location: Calgary, Alberta

Raise is currently hiring an
IT Data Analyst
on behalf of our client. They're expanding their team to meet growing needs, making this a unique opportunity to work with an industry leader. Our client, the third largest producer of Canadian oil and natural gas and the second largest refiner and upgrader with extensive midstream and downstream infrastructure.

Note: The primary pay rate is based on T4 classification; however, we will also consider applications from candidates interested in an INC classification, where applicable.

Description

The IT Data Analyst in this role will focus on using data and automation to solve business problems and improve efficiency within our organization's IT/OT systems. Collect, clean, analyze, and interpret data to identify trends, patterns, and create actionable insights, then communicate these findings to stakeholders to inform decision-making and drive improvements.

Responsibilities

• Data Collection and Management (ETL):
• Gathering data from various sources, including databases, systems, and potentially external sources.
• Developing and maintaining data collection and storage systems.
• Ensuring data accuracy, consistency, and quality.
• Data Analysis and Interpretation:
• Applying statistical techniques and tools to analyze data.
• Identifying trends, patterns, and correlations within the data.
• Developing data models to support analysis and predictions.
• Communication and Reporting:
• Creating visualizations, reports, and dashboards to present findings.
• Communicating insights and recommendations to technical and non-technical audiences.
• Collaborating with stakeholders to understand their needs and translate them into data-driven solutions.
• Troubleshooting and Optimization:
• Identifying and resolving issues with data systems and processes.
• Optimizing data collection, storage, and analysis processes.
• Continuously improving data quality and efficiency.

Qualifications

• 5+ years of professional experience in a Data Analyst or similar technical role.
• Previous experience working within the Oil & Gas industry is highly preferred, specifically within Upstream operations.(specifically Process Data, SCADA, Field Data Capture, SAP)
• Advanced SQL:
  Expert ability to write complex queries, manage databases, and perform deep-dive data extraction.
• Python Programming
  : Proficiency in Python for data manipulation, automation, and statistical analysis.
• Power BI
  : Advanced experience in developing sophisticated dashboards and visualizations that drive executive decision-making.
• Data Modeling & ETL
  : Strong background in designing data models and maintaining robust ETL (Extract, Transform, Load) processes to ensure data integrity and quality.
• Desirable & Specialized Skills
• Cloud & Big Data:
  Experience with Databricks and Microsoft SQL Server.
• OT Systems
  (Operational Technology): Familiarity with PI Data Historian, SCADA, and Field Data Capture systems.
• ERP Integration
  : Knowledge of SAP data structures and integration.
• Advanced Programming:
  Experience with REST API programming for data integration between systems.
• Education and Skills
• Bachelor's degree in computer science, information technology, or a related field
• Strong problem-solving, critical thinking, and analytical abilities.
• Ability to work effectively with cross-functional teams.
• Ability to clearly and effectively communicate complex information, including visualizations and reports to diverse audiences.