ZipRecruiter

Log In

1

Data Analysis Intern Jobs in Alberta (NOW HIRING)

Data Elephant Inc

Oracle Data Analyst

Calgary, AB · Remote

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

EnerStar Solutions

Engineering Intern

Red Deer, AB · On-site

POSITION SUMMARY The Engineering Intern will support engineering, telecommunications, and ... data analysis, and project execution. This position is designed to provide meaningful exposure to ...

CARLISLE COMPANIES

R&D Intern

Crossfield, AB

The intern will assist with experimental planning, raw-material preparation, reactor operation under supervision, post-processing, sample characterization, data analysis, and documentation. The role ...

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

Navitas Semiconductor

$25 - $30/hr

Working closely with test operations, this intern will focus on building the business tools ... Strong analytical skills with proficiency in Microsoft Excel for data modeling, demand forecasting ...

Farther Farms

JOB SUMMARY Based at the Farther Farms' R&D facility in Rochester, NY, the Engineering Intern ... This position will assist with experimental design, execution, data collection, and data analysis ...

KRISTEN DISTRIBUTING CO

Compliance-related projects and HR data analysis. * Observation of benefits administration ... The intern sets a weekly schedule based on their class schedule and other commitments. We ...

CASA Mental Health

Evaluation and Data Analyst

Edmonton, AB · On-site

CA$34.99 - CA$45.74/hr

Apply quantitative and qualitative evaluation methods, including data collection and analysis. * Monitor and report on key performance indicators (KPIs) and targets. * Collect, clean, analyze and ...

New

National Bank

Corporate Finance Intern

Edmonton, AB · On-site

... data and analytics. At National Bank, we are continuously looking for talents with different ... intern! Your role: * Improve an analytics environment SQL/SAP/Excel. * Set up or improve Excel ...

next page

Showing results 1-20

All JobsData Analysis Intern JobsData Analysis Intern Jobs in Alberta

Data Analysis Intern information

What does a data analysis intern do?

A data analysis intern supports a data analyst while obtaining valuable practical experience to pursue a position in the field. Your responsibilities in this position include delivering data, formatting information, querying databases for sales, marketing, accounting, and other departments, developing and updating reports, and assisting with projects when needed. Your duties also include evaluating analysis systems, collaborating with other teams, responding to requests for analysis, and investigating data discrepancies. You collect information and review the model to offer recommendations.

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

To thrive as a Data Analysis Intern, you should have a solid understanding of statistics, data management, and analytical thinking, often supported by coursework in mathematics, statistics, or a related field. Familiarity with tools like Excel, SQL, Python, or R, as well as data visualization platforms such as Tableau or Power BI, is typically expected. Attention to detail, problem-solving abilities, and effective communication help interns interpret data accurately and present insights clearly. These skills are vital for transforming raw data into actionable insights that support business decision-making.

What are some common challenges faced by data analysis interns during their internship, and how can they overcome them?

Data Analysis Interns often encounter challenges such as working with large, unstructured datasets and learning to use new analysis tools or programming languages. Navigating ambiguous project requirements and balancing multiple deadlines can also be difficult. To overcome these obstacles, interns are encouraged to proactively communicate with their mentors, seek feedback regularly, and make use of available resources such as online tutorials or internal documentation. Collaborating with teammates and asking questions fosters learning and helps interns efficiently resolve roadblocks.

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

AspectData Analysis InternData Analyst
Required CredentialsTypically pursuing or recent graduate in related fieldBachelor's or higher in data-related field, some certifications
Work EnvironmentInternship setting, entry-level tasks, supervisedFull-time role, more independent responsibilities
Employer & Industry UsageInternships in various industries, educational focusEstablished roles in finance, tech, healthcare, etc.
Common Search & Comparison IntentUnderstanding entry-level opportunities, learning rolesCareer progression, skill requirements

The main difference between a Data Analysis Intern and a Data Analyst lies in experience, responsibilities, and employment status. Interns are usually students or recent graduates gaining initial exposure, while Data Analysts are full-time professionals handling more complex tasks independently. Internships serve as stepping stones toward becoming a full Data Analyst.

Is a data analysis intern internship worth it?

A data analysis intern internship provides practical experience with tools like Excel, SQL, and Python, and helps develop skills in data visualization and reporting. It can enhance a resume, improve job prospects, and offer networking opportunities, making it a valuable step for those pursuing a career in data analysis.
More about Data Analysis Intern jobs

What are the most commonly searched types of Data Analysis jobs in Alberta?

The most popular types of Data Analysis jobs in Alberta are:

What are popular job titles related to Data Analysis Intern jobs in Alberta?

For Data Analysis Intern jobs in Alberta, the most frequently searched job titles are:

What job categories do people searching Data Analysis Intern jobs in Alberta look for?

The top searched job categories for Data Analysis Intern jobs in Alberta are:

What cities in Alberta are hiring for Data Analysis Intern jobs?

Cities in Alberta with the most Data Analysis Intern job openings:

Data Analysis Intern jobs near you
Infographic showing various Data Analysis Intern job openings in Alberta as of August 2026, with employment types broken down into 1% As Needed, 82% Full Time, 14% Part Time, and 3% Contract. Highlights an 85% Physical, 4% Hybrid, and 11% Remote job distribution.

Oracle Data Analyst

Data Elephant Inc

Calgary, AB • Remote

Contractor

Posted 16 days ago

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