ZipRecruiter

Log In

1

Data Analyst Internship Jobs in Calgary, AB (NOW HIRING)

Data Elephant Inc

Oracle Data Analyst

Calgary, AB · Remote

Senior Oracle Data Analyst - Contract We are seeking a senior Oracle Data Analyst to support a major application and database modernization initiative within the oil and gas sector. This is an ...

Strathcona Resources Ltd

Data Analyst

Calgary, AB

We are seeking a skilled Contract Data Analyst to join our Analytics team in Calgary for an 18-month term. Reporting to the Team Lead, Analytics, you will work closely with internal stakeholders and ...

Hexagon

Business & Data Analyst

Calgary, AB · Hybrid

As a Business & Data Analyst, responsibilities include: * Business Analysis * Elicit, analyze, and document business requirements. * Translate requirements into clear, testable system requirements.

New

Hexagon

Business & Data Analyst

Calgary, AB · Hybrid

Data Analysis * Use SQL and other data analysis techniques to query databases, investigate data issues, validate business processes, identify trends, and support decision-making. * Develop and ...

Capital Power

Sr. Analyst, Market Data

Calgary, AB · On-site

The Sr. Analyst, Market Data owns Capital Power's end-to-end price curve framework within the Risk Group. The role is accountable for the quality, integrity, and governance of all priceand market ...

Onterris

Workday Analyst - Financials & Projects

Calgary, AB · On-site +1

CA$85K - CA$100K/yr

Prior exposure to Workday or another ERP system (through coursework, an internship, or on-the-job ... Basic understanding of system security or data concepts Onterris is a leading global environmental ...

Wood Plc

TAC Internship 2022

Calgary, AB

Overview / Responsibilities Wood currently has an exciting opportunity for Transportation Engineering Internship(s) . If you thrive on challenges in a fast paced environment, this is the opportunity ...

next page

Showing results 1-20

All JobsData Analyst JobsData Analyst Internship JobsData Analyst Internship Jobs in Calgary, AB

Data Analyst Internship information

What is a data analyst internship?

A Data Analyst Internship is a temporary position where interns gain hands-on experience in collecting, organizing, and analyzing data to support business decisions. Interns typically work with large datasets, use tools like Excel, SQL, and Python, and create reports or visualizations. The role helps develop technical skills, analytical thinking, and an understanding of how data-driven insights impact an organization. It is a great opportunity for students or recent graduates to apply theoretical knowledge in a real-world setting.

What typical projects or responsibilities might I have as a data analyst intern?

As a Data Analyst Intern, you'll likely work on tasks such as cleaning and organizing raw data, running analysis to identify trends or patterns, and assisting with the creation of reports and data visualizations for your team. You may collaborate closely with senior analysts or cross-functional teams to support ongoing projects and business initiatives. Interns commonly get exposure to real-world datasets, participate in team meetings, and sometimes contribute to presentations or process improvement efforts. This hands-on experience is designed to help you develop both your technical and analytical skills while gaining insight into the role of data in business decision-making.

What are the key skills and qualifications needed to thrive in a data analyst internship, and why are they important?

To thrive as a Data Analyst Intern, you need a solid grounding in statistics, data interpretation, and problem-solving, often backed by coursework or a degree in fields like mathematics, computer science, or economics. Familiarity with tools such as Microsoft Excel, SQL databases, and data visualization software like Tableau or Power BI is highly valuable. Attention to detail, effective communication, and a willingness to learn are essential soft skills for success in this position. These competencies are crucial for accurately analyzing data, drawing insights, and clearly presenting findings to support business decisions.

What are the most commonly searched types of Data Analyst jobs in Calgary, AB?

The most popular types of Data Analyst jobs in Calgary, AB are:

What are popular job titles related to Data Analyst Internship jobs in Calgary, AB?

For Data Analyst Internship jobs in Calgary, AB, the most frequently searched job titles are:

What job categories do people searching Data Analyst Internship jobs in Calgary, AB look for?

The top searched job categories for Data Analyst Internship jobs in Calgary, AB are:

What cities near Calgary, AB are hiring for Data Analyst Internship jobs?

Cities near Calgary, AB with the most Data Analyst Internship job openings:

Data Analyst Internship jobs near you
Infographic showing various Data Analyst Internship job openings in Calgary, AB as of August 2026, with employment types broken down into 1% As Needed, 84% Full Time, 12% Part Time, and 3% Contract. Highlights an 85% Physical, 5% Hybrid, and 10% Remote job distribution.

Oracle Data Analyst

Data Elephant Inc

Calgary, AB • Remote

Contractor

This job post has expired today. Applications are no longer accepted.

Job description

Senior Oracle Data Analyst - Contract

We are seeking a senior Oracle Data Analyst to support a major application and database modernization initiative within the oil and gas sector. This is an initial 4-6-month contract focused on analyzing and resolving significant data discrepancies between a legacy Oracle application and its newly rebuilt replacement.


The organization is migrating data from multiple source systems into a new Oracle database while improving data transformation, prioritization, and master data management practices. Although the new environment is intended to become the authoritative source, millions of records currently do not align with the legacy system. The immediate priority is understanding why these differences exist and determining how the data should be populated.

This role is primarily analytical rather than development-focused. You will investigate data, trace legacy business rules, review SQL and PL/SQL logic, and identify whether discrepancies are caused by source data, data quality issues, transformation logic, field-mapping rules, or differences between the old and new applications.


Key responsibilities

  • Compare and reconcile large datasets across legacy and new Oracle databases.
  • Investigate approximately 7-10 million identified data discrepancies.
  • Perform detailed root-cause analysis to determine why records and fields do not match.
  • Review Oracle SQL, PL/SQL, stored procedures, and legacy application logic.
  • Trace data from multiple source systems through Informatica and PL/SQL transformations.
  • Determine the intended business rules and how individual fields should be populated.
  • Distinguish between source-data issues, transformation defects, mapping gaps, and logic differences.
  • Document findings, business rules, discrepancy patterns, and recommended resolutions.
  • Work closely with business stakeholders to validate data expectations.
  • Collaborate with architects and developers to recommend fixes that will not negatively affect other processes.
  • Support developers during remediation and validate that implemented fixes resolve the underlying issues.
  • Use AI-assisted analysis tools, where appropriate, to accelerate code review and discrepancy investigation.
  • Work independently, take ownership of assigned analysis, and communicate findings clearly to technical and business audiences.


Required qualifications

  • At least seven years of experience in data analysis, data migration, data quality, database development, or a closely related field.
  • Strong hands-on expertise with Oracle databases, Oracle SQL, and PL/SQL.
  • Demonstrated experience with large-scale data reconciliation, validation, and root-cause analysis.
  • Ability to read and understand existing database code, stored procedures, transformations, and business logic.
  • Experience investigating discrepancies between legacy and modernized systems.
  • Good understanding of ETL processes, relational databases, data warehousing, and data integration.
  • Experience translating technical findings into clear, business-friendly language.
  • Strong analytical skills, attention to detail, and a structured approach to problem-solving.
  • Ability to work with limited direction and take ownership of deliverables.
  • Previous oil and gas industry experience.


Preferred qualifications

  • Experience with Informatica.
  • Exposure to master data management and data governance.
  • Experience working with data originating from multiple operational source systems.
  • Backend application development experience.
  • Familiarity with AI tools such as GitHub Copilot or similar tools for SQL, code, and data analysis.
  • Advanced Excel skills.
  • Experience working within Agile delivery teams.


Contract details

  • Initial duration: 4-6 months
  • Work arrangement: Remote work is acceptable; alignment with the client's working time zone is preferred (MST)
  • Primary focus: Data analysis, reconciliation, and root-cause investigation
  • Industry: Oil and gas



Apply