About the role
Job Title: Contract IT Data Analyst-Architect
Location: Calgary, AB
Type: Contract (INC or T4)
Work Setup: On-site (5/40 schedule)
Industry: Oil & Gas
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, design data strategies, and drive 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 language
- 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 data 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
Data Strategy & Governance
- 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 up to date 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 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 air emissions regulations
- Experience with PI Data Historian, MS SQL Server, and other visualization tools
- Exposure to data migration and system integration projects
About Airswift
We support STEM professionals looking for jobs with exceptional firms in the technology and engineering sectors.
With over 9,000 contractors and 1,000 employees in 60 offices worldwide, our talent pool and geographical reach are unmatched in the industry.
About the role
Job Title: Contract IT Data Analyst-Architect
Location: Calgary, AB
Type: Contract (INC or T4)
Work Setup: On-site (5/40 schedule)
Industry: Oil & Gas
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, design data strategies, and drive 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 language
- 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 data 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
Data Strategy & Governance
- 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 up to date 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 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 air emissions regulations
- Experience with PI Data Historian, MS SQL Server, and other visualization tools
- Exposure to data migration and system integration projects
About Airswift
We support STEM professionals looking for jobs with exceptional firms in the technology and engineering sectors.
With over 9,000 contractors and 1,000 employees in 60 offices worldwide, our talent pool and geographical reach are unmatched in the industry.