Senior Data Analyst building financial models and Looker dashboards for Jane’s healthcare practice management platform. Supporting Finance and Payments with trusted revenue, billing, and transaction insights.
About the role
- Senior Oracle Data Analyst reconciling millions of records for an oil and gas modernization initiative. Investigating legacy-to-new-system discrepancies and guiding remediation.
Responsibilities
- 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)
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
No Education Requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Senior Data Analyst building AI - enabled Tableau analytics for Sun Life, a global financial services company. Developing trusted metrics, data models, dashboards, and sales insights.
Marketing data advisor analyzing and valorizing member/client data for Desjardins, North America's largest cooperative financial group. Developing dashboards, self - service reports and recommendations for marketing decisions.
LP
Payments Data Analyst (Modernization)
LinkedIn Recruiter Post
Payments Data Analyst needed for modernization project in Toronto. Requires Python, SQL, and wholesale payments expertise.
Intermediate Data Analyst transforming complex data into actionable insights for PLATO, Canada’s Indigenous - owned technology services company. Developing models, dashboards, and data management solutions with MS Dynamics and Azure.
Senior Data Analyst improving player engagement, monetization, and live operations for Big Viking Games’ YoWorld and FishWorld. Building SQL - driven dashboards and insights for product and business decisions.
Senior data analyst generating client acquisition insights for Sun Life, a global financial security and health company. Building KPIs, dashboards, forecasts, and automated analytics to improve lead conversion and client growth.
Data Analyst converting business data into actionable insights for StarTech.com, a global tech connectivity solutions provider. Building models, dashboards, and reports across product, inventory, revenue, customer, and marketing analytics.
LP
Data Solution Architect
LinkedIn Recruiter Post
Hiring a Data Solution Architect for a remote 6 - month contract. Expert in GCP, Kubernetes, distributed systems, and ML platforms.
Gartner Director Analyst advising enterprise leaders on agentic data management. Publishing research, presenting insights, and supporting clients’ data and analytics initiatives.