Contract IT Data Analyst-Architect

Airswift; Calgary; On-site; CAD 85,000 - 115,000; Full time

Job summary

A leading company is looking for a Contract IT Data Analyst-Architect in Calgary. The role involves data collection, analysis, and enhancing data-driven decision-making within the organization. The ideal candidate has a solid foundation in SQL and Power BI, with experience in data modeling and ETL processes. Strong communication skills are essential as the role involves collaboration across multiple departments.

Qualifications

• 3+ years experience in data analysis and ETL.
• Strong collaboration and communication skills across departments.
• Proficient in SQL, data modeling, and Power BI.

Responsibilities

• Gather and integrate data from internal and external sources.
• Apply statistical techniques to discover trends and patterns.
• Create visualizations and dashboards using Power BI.

Skills

SQL

Power BI

Data modeling

Python

ETL design

Data architecture

Education

Bachelor’s degree in Computer Science

Degree in Data Science

Tools

Power BI

Databricks

PI Data Historian

MSSQL Server

Job description

Job Title: Contract IT Data Analyst-Architect

Type: Contract (INCorT4)

Work Setup: On-site (5/40 schedule)

Job Summary

We are seeking a skilled and detail-oriented Data Business Analyst to join our IT or Data Analytics team in support of enterprise-wide data management initiatives. This role focuses on applying ETL best practices, improving IT systems efficiency, and enabling data-driven decision-making across the organization. You will be responsible for collecting, cleaning, modeling, and interpreting data to uncover insights, designing data strategies, and driving operational improvements.

Ideal Candidates Will Have

• A strong foundation in SQL, Power BI, data modeling, and a solid understanding of ETL processes.
• Experience with Python, Databricks, and upstream oil & gas data systems is highly desirable.

Top Desired Skills

• SQL and data modeling
• Power BI (dashboards and reporting)
• Python or other statistical programming languages
• Data architecture, ETL design, and optimization
• Familiarity with upstream oil & gas data systems (SCADA, PI Historian, FDC)

Key Responsibilities

Data Collection & Management

• Gather and integrate data from internal and external sources, including databases, SCADA systems, and applications.
• Develop and maintain robust data collection and storage frameworks.
• Ensure accuracy, consistency, and integrity of data.

Data Analysis & Interpretation

• Apply statistical and analytical techniques to discover trends, patterns, and anomalies.
• Build predictive data models to support strategic decisions.
• Interpret complex datasets and identify actionable insights.

Communication & Reporting

• Create visualizations, dashboards, and reports using Power BI or equivalent tools.
• Present findings and recommendations to both technical and non-technical stakeholders.
• Collaborate with cross-functional teams (IT, operations, engineering, finance) to define and solve business problems.

Troubleshooting & Optimization

• Investigate and resolve data integrity and pipeline issues.
• Continuously improve data workflows and ETL pipelines for scalability and efficiency.
• Design low-maintenance, high-availability solutions for long-term data use.
• Design and implement scalable data models and architectures aligned with business needs.
• Support compliance and data quality standards, including security protocols.
• Contribute to the development of enterprise data strategies.

Technology Research & Implementation

• Stay updated on trends in data technologies and recommend improvements.
• Evaluate new tools and platforms for data management and analysis.

Basic/Required Qualifications

• Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.
• 3+ years of experience in data analysis, ETL, and business intelligence.
• Proficient in SQL, data modeling, and Power BI.
• Demonstrated problem-solving and critical thinking skills.
• Strong collaboration and communication skills across departments.

Preferred Qualifications

• Experience with Python, Databricks, REST API integration, and data warehousing.
• Familiarity with upstream oil & gas processes including Process Data, SCADA, Field Data Capture.
• Knowledge of Alberta and Saskatchewan emissions regulations.
• Experience with PI Data Historian, MSSQL Server, and other visualization tools.
• Exposure to data migration and system integration projects.

Apply Now

First Name*

Last Name*

Email*

Phone* Phone

CV Upload* Scanned files or files with embedded images will not be accepted.
Allowed file extensions are .rtf, .doc, .docx, or .pdf

Please tick here if you would like to sign up for Airswift’s STEM Careers newsletter.

Not the job you are looking for? Search hundreds more.