Data Analyst, Oracle

Data Elephant

Senior Oracle Data Analyst reconciling millions of records for an oil and gas modernization initiative. Investigating legacy-to-new-system discrepancies and guiding remediation.

Posted 8/6/2026contractRemote • 🇨🇦 CanadaSeniorLeadWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates extensive experience in data analysis, reconciliation, and root-cause analysis, particularly with Oracle databases and SQL. Capable of translating complex technical findings into business-friendly language while collaborating effectively with stakeholders.

Highest-signal resume keywords

Oracle Database ExpertiseOracle SQL ProficiencyPL/SQL DevelopmentData Reconciliation ExperienceInformatica Familiarity

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data AnalysisData MigrationData QualityRoot-Cause AnalysisETL ProcessesRelational DatabasesData WarehousingData IntegrationBackend Application DevelopmentAdvanced Excel Skills

Soft Skills

Analytical SkillsAttention to DetailStructured Problem-SolvingOwnership of DeliverablesCommunication Skills

Tools & Technologies

InformaticaAI ToolsGitHub Copilot

Industry Keywords

Oil and Gas Industry ExperienceMaster Data ManagementData Governance

Tech Stack

Tools & technologies

ETLInformaticaOracleSQL

About the role

Key responsibilities & impact

Compare and reconcile large datasets across legacy and new Oracle databases
Investigate approximately 7–10 million identified data discrepancies
Perform 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 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 with business stakeholders to validate data expectations
Collaborate with architects and developers to recommend fixes
Support developers during remediation and validate implemented fixes
Use AI-assisted analysis tools where appropriate
Own assigned analysis and communicate findings to technical and business audiences

Requirements

What you’ll need

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
Experience with large-scale data reconciliation, validation, and root-cause analysis
Ability to read and understand database code, stored procedures, transformations, and business logic
Experience investigating discrepancies between legacy and modernized systems
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 structured problem-solving
Ability to work with limited direction and take ownership of deliverables
Previous oil and gas industry experience
Experience with Informatica preferred
Exposure to master data management and data governance preferred
Experience with multiple operational source systems preferred
Backend application development experience preferred
Familiarity with AI tools such as GitHub Copilot preferred
Advanced Excel skills preferred
Experience within Agile delivery teams preferred

Benefits

Comp & perks

Remote work is acceptable
Alignment with the client’s working time zone is preferred (MST)