Contract Business Analyst – ERP, RPA & Data (Calgary, 6 months)

Arnett & Burgess Energy Services; Calgary; On-site; CAD 75,000 - 95,000; Full time

Job summary

Arnett & Burgess Energy Services in Calgary, AB, seeks a contract Business Analyst to bridge operations with IT, focusing on ERP, data analytics, and process automation. The role reports to the Director of Commercial and IT and sits at the intersection of field operations, ERP systems, and automation initiatives.

The six‑month contract offers exposure to RPA, data pipelines, SQL querying, and data migrations, with a potential to transition to full-time based on performance and business need.

Qualifications

• 5+ years in a business analyst, systems analyst, or process improvement role.
• Working knowledge of SQL (querying, joins, basic data transformation).
• Experience with ERP systems (implementation, support, or super-user level).
• Exposure to field data capture / mobile data collection tools (construction, energy, or field services industry a plus).
• Familiarity with RPA or workflow automation concepts and tools (UiPath, Power Automate, or similar).
• Experience working in Databricks or similar cloud data platforms (Snowflake, Synapse) for data querying and transformation.
• Strong process-mapping skills (BPMN, flowcharting, or similar).
• Excellent written and verbal communication; able to translate between technical and operational stakeholders.
• Comfortable working in a contract capacity with the flexibility and initiative that entails.

Responsibilities

• Document and analyze current-state operational process flows across commercial, field, and back-office functions.
• Identify opportunities for automation (RPA, workflow tools) and lead requirements gathering for implementation.
• Work within ERP systems to support configuration, reporting, and integration needs.
• Partner with field data capture platforms to ensure data flows accurately from the field into core systems.
• Write and troubleshoot SQL queries to extract, validate, and transpose data across systems.
• Support data pipeline and analytics work in Databricks — querying, transforming, and validating data across lakehouse environments.
• Translate business requirements into functional specifications for IT/vendor teams.
• Support system implementations, upgrades, and data migrations from a business-process perspective.
• Act as liaison between operations, IT/IS, and external vendors/consultants.

Skills

SQL querying

ERP systems knowledge

RPA / workflow automation concepts

Databricks / cloud data platforms

Process mapping (BPMN/flowcharts)

Communication skills

Tools

UiPath

Power Automate

Databricks

Snowflake

Synapse

Job description

Arnett & Burgess Energy Services in Calgary, AB, seeks a contract Business Analyst to bridge operations with IT, focusing on ERP, data analytics, and process automation. The role reports to the Director of Commercial and IT and sits at the intersection of field operations, ERP systems, and automation initiatives.

The six‑month contract offers exposure to RPA, data pipelines, SQL querying, and data migrations, with a potential to transition to full-time based on performance and business need.