Oracle Data Analyst

<p><strong>Company Description</strong> Data Elephant is a Canadian full-stack data and analytics services firm founded in 2022 to address the growing demand for specialized data expertise. The company combines the deep technical skills, agility, and value-driven mindset of a boutique firm with the strategic thinking and proven methodologies of global consultancies. Its founders bring extensive technology services experience, enabling a unique engagement model and strong value proposition for clients. Data Elephant partners with organizations across industries to drive impact and value throughout the entire data stack, positioning itself as a trusted, long-term Canadian data partner.</p><p><br></p><p>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.</p><p><br></p><p>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.</p><p>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.</p><p><br></p><p><strong>Key responsibilities</strong></p><ul><li>Compare and reconcile large datasets across legacy and new Oracle databases.</li><li>Investigate approximately 7–10 million identified data discrepancies.</li><li>Perform detailed root-cause analysis to determine why records and fields do not match.</li><li>Review Oracle SQL, PL/SQL, stored procedures, and legacy application logic.</li><li>Trace data from multiple source systems through Informatica and PL/SQL transformations.</li><li>Determine the intended business rules and how individual fields should be populated.</li><li>Distinguish between source-data issues, transformation defects, mapping gaps, and logic differences.</li><li>Document findings, business rules, discrepancy patterns, and recommended resolutions.</li><li>Work closely with business stakeholders to validate data expectations.</li><li>Collaborate with architects and developers to recommend fixes that will not negatively affect other processes.</li><li>Support developers during remediation and validate that implemented fixes resolve the underlying issues.</li><li>Use AI-assisted analysis tools, where appropriate, to accelerate code review and discrepancy investigation.</li><li>Work independently, take ownership of assigned analysis, and communicate findings clearly to technical and business audiences.</li></ul><p><br></p><p><strong>Required qualifications</strong></p><ul><li>At least seven years of experience in data analysis, data migration, data quality, database development, or a closely related field.</li><li>Strong hands-on expertise with Oracle databases, Oracle SQL, and PL/SQL.</li><li>Demonstrated experience with large-scale data reconciliation, validation, and root-cause analysis.</li><li>Ability to read and understand existing database code, stored procedures, transformations, and business logic.</li><li>Experience investigating discrepancies between legacy and modernized systems.</li><li>Good understanding of ETL processes, relational databases, data warehousing, and data integration.</li><li>Experience translating technical findings into clear, business-friendly language.</li><li>Strong analytical skills, attention to detail, and a structured approach to problem-solving.</li><li>Ability to work with limited direction and take ownership of deliverables.</li><li>Previous oil and gas industry experience.</li></ul><p><br></p><p><strong>Preferred qualifications</strong></p><ul><li>Experience with Informatica.</li><li>Exposure to master data management and data governance.</li><li>Experience working with data originating from multiple operational source systems.</li><li>Backend application development experience.</li><li>Familiarity with AI tools such as GitHub Copilot or similar tools for SQL, code, and data analysis.</li><li>Advanced Excel skills.</li><li>Experience working within Agile delivery teams.</li></ul><p><br></p><p><strong>Contract details</strong></p><ul><li>Initial duration: 4–6 months</li><li>Work arrangement: Remote work is acceptable; alignment with the client’s working time zone is preferred (MST)</li><li>Primary focus: Data analysis, reconciliation, and root-cause investigation</li><li>Industry: Oil and gas</li></ul><p><br></p><li><br></li>

Back to blog

Other Jobs To Apply

No other job posts for this day.

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...