1

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

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 ...

New

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 ...

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 ...

We are currently seeking a Compliance Intern to join our Market & Trading Compliance team for a ... Assistingin data analysis and validation to support trade surveillance and reporting activities.

Description GIS Intern Why YOU want this position At Enverus, we're committed to empowering the ... Support a multidisciplinary team of data scientists, financial analysts, engineers, and developers ...

Thanks for checking us out! We're hiring and looking for our next Paid Media Intern who is ready to ... Whether analyzing data, supporting campaign setup, or reporting on performance, you approach each ...

New

Were hiring and looking for our next Paid Media Intern who is ready to contribute to a diverse ... Whether analyzing data, supporting campaign setup, or reporting on performance, you approach each ...

New

Thanks for checking us out! We're hiring and looking for our next Paid Media Intern who is ready to ... Whether analyzing data, supporting campaign setup, or reporting on performance, you approach each ...

next page

Showing results 1-20

Data Analyst Intern information

See Calgary, AB salary details

$5

$19

$26

How much do data analyst intern jobs pay per hour?

As of Aug 7, 2026, the average hourly pay for data analyst intern in Calgary, AB is $19.42, according to ZipRecruiter salary data. Most workers in this role earn between $17.55 and $20.19 per hour, depending on experience, location, and employer.

What types of projects and tasks can a data analyst intern expect to work on during their internship?

As a Data Analyst Intern, you can expect to work on a variety of projects such as cleaning and organizing datasets, creating data visualizations, and supporting the analysis of business trends. You'll often be asked to assist in preparing reports, updating dashboards, and collaborating with team members from departments like marketing, finance, or product management. This hands-on experience provides exposure to real-world data challenges and the opportunity to develop technical skills using tools like Excel, SQL, or Python, while also learning how data-driven decisions are made within the organization.

Is a data analyst internship worth it?

A data analyst internship provides practical experience with data analysis tools like Excel, SQL, and visualization software, which can enhance employability and skill development. It offers exposure to real-world projects and networking opportunities, making it valuable for those pursuing a career in data analysis.

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

To thrive as a Data Analyst Intern, you need a solid understanding of statistics, data analysis, and proficiency in Excel or similar spreadsheet tools, often supported by coursework in data science or related fields. Familiarity with data visualization software like Tableau, and programming languages such as SQL or Python, is commonly expected. Strong attention to detail, problem-solving skills, and the ability to communicate findings clearly are standout soft skills for this role. These skills enable interns to extract actionable insights from data, support decision-making, and contribute meaningfully to business objectives.

What is the difference between Data Analyst Intern vs Data Scientist Intern?

AspectData Analyst InternData Scientist Intern
Required CredentialsTypically pursuing or recent graduate in data-related fields; basic knowledge of SQL, Excel, and data visualizationOften pursuing or recent graduate in data science or related fields; knowledge of programming (Python, R), machine learning, and statistical modeling
Work EnvironmentEntry-level, supporting data analysis tasks, reporting, and visualizationMore advanced projects involving predictive modeling, algorithms, and complex data analysis
Employer & Industry UsageCommon in tech, finance, marketing, and consulting firmsFound in tech, research, and analytics-driven industries

The main difference between a Data Analyst Intern and a Data Scientist Intern lies in the complexity of tasks and required skills. Data Analyst Interns focus on data cleaning, visualization, and reporting, while Data Scientist Interns handle advanced modeling and machine learning. Both roles are valuable entry points into data careers, with the Data Scientist Intern position typically requiring more technical expertise.

What does a data analyst intern do?

A Data Analyst Intern supports data analysis projects by collecting, cleaning, and organizing data. They use tools like Excel, SQL, or Python to analyze datasets and help generate reports or visualizations for business insights. Interns often work under supervision, assisting with ongoing projects and learning industry best practices, which helps them gain valuable experience in data analytics and business intelligence.
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 cities near Calgary, AB are hiring for Data Analyst Intern jobs? Cities near Calgary, AB with the most Data Analyst Intern job openings:
Infographic showing various Data Analyst Intern job openings in Calgary, AB as of August 2026, with employment types broken down into 1% As Needed, 79% Full Time, 17% Part Time, and 3% Contract. Highlights an 87% Physical, 3% Hybrid, and 10% Remote job distribution, with an average salary of $40,402 per year, or $19.4 per hour.

Oracle Data Analyst

Data Elephant Inc

Calgary, AB โ€ข Remote

Contractor

Posted 3 days ago

New


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