Data Analyst

Airswift; Calgary; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading company in the energy sector seeks a detail-oriented Data Analyst in Calgary. The role involves managing on-premise master data, conducting analysis, and supporting core business functions through accurate data reporting. Ideal candidates will have substantial experience with SQL, ERP systems, and data governance practices.

Qualifications

• 5+ years' experience in Data Analysis within on-premise environments.
• Strong SQL proficiency for data querying and reporting.
• Experience with ERP systems like SAP or Oracle.

Responsibilities

• Analyze and maintain master data across on-premise systems.
• Generate reports and dashboards using Excel and Power BI.
• Support data governance policies and quality control standards.

Skills

Data Analysis

SQL

Excel

Power BI

Master Data Management

Data Governance

Tools

ERP Systems

Informatica

SSIS

Job description

Job Title:Data Analyst – On-Premise Master Data
Location: Calgary, AB
Type: T4/INC Contract(6 months with possibility for extension or permanent hire)
Work Setup: On-site (5/40 Monday - Friday)
Industry: Oil & Gas

Job Summary

Airswift is seeking a detail-driven Data Analyst to join one of our major clients in the energy sector. This position focuses on on-premise master data environments, supporting core business functions through accurate data reporting, analysis, and governance.

This is not a cloud or data science role,it’s ideal for professionals experienced with ERP systems, SQL-based reporting, and master data management within structured enterprise IT ecosystems.

Key Responsibilities

Analyze and maintain master data (customers, vendors, materials, assets) across on-premise enterprise systems

Conduct data profiling, validation, and cleansing to ensure consistency and accuracy

Generate reports and dashboards using Excel, Power BI, and other enterprise tools

Collaborate with business and technical teams to define data requirements and address quality issues

Document data definitions, flow diagrams, and processes for cross-functional clarity

Participate in data migration, integration, and transformation activities within ERP platforms

Support and enforce data governance policies and quality control standards

Basic / Required Qualifications

5+ years of experience in Data Analysis within on-premise enterprise environments

Strong proficiency in SQL for querying, validation, and reporting

Experience with ERP systems such as SAP, Oracle EBS, or JD Edwards

Familiarity with master data domains and MDM practices

Proficiency in Microsoft Excel, Power BI, or other reporting tools

Strong communication skills and attention to detail

Legally authorized to work in Canada without sponsorship

Preferred Qualifications

Experience with ETL tools like Informatica or SSIS (on-premise context)

Exposure to data governance frameworks and enterprise data policies

Knowledge of data warehousing and traditional BI environments

Prior experience in energy, utilities, or manufacturing sectors

Not the job you are looking for? Search hundreds more