Data Analyst, Oracle

🔥 9 minutes ago

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Data Elephant

WebsiteLinkedInAll Job Openings

11 - 50 employees

Founded 2022

💼 Consulting

📣 Marketing

📦 Logistics

Consulting • Marketing • Logistics

Data Elephant is a Vancouver-based data and analytics consultancy founded in 2022 that helps organizations modernize data infrastructure and platforms to enable self-service reporting, advanced analytics, AI, and machine learning. They offer end-to-end services including data strategy, cloud migration, data engineering (warehouses, lakes, lakehouses), governance, BI, MLOps, and GenAI proof-of-concept and training, partnering with cloud and analytics providers like AWS, Databricks, and Microsoft. Data Elephant serves enterprise clients across industries (energy, mining, finance, transportation, retail, sports, public sector) and positions itself as a trusted advisor delivering measurable business outcomes through collaboration and long-term partnerships.

📋 Description

• 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

• 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

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