Analyste des données clients chez EDC, société d’État aidant les entreprises canadiennes à réussir à l’étranger. Modernisation des pipelines, tableaux de bord et solutions analytiques marketing.
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.
Customer Data Analyst modernizing EDC’s customer data ecosystem at Canada’s export - finance Crown corporation. Building Microsoft Fabric pipelines, Power BI assets, and marketing analytics solutions.
Senior Data Analyst building trusted financial metrics, dbt models, and Looker dashboards for Jane’s clinic - management SaaS platform. Partnering with Finance and Payments to guide critical decisions.
Digital media specialist improving campaign tracking, reporting and analytics at a Toronto marketing technology lab. Automating insights with AI while maintaining data quality and measurement accuracy.
Data Analytics Intern analyzing new features and updates for Montreal - based mobile gaming studio Ludia. Building data modules, dashboards, and insights to optimize game operations.
Senior Data Analyst transforming Sun Life insurance and financial - services data into actionable marketing insights. Building SQL, Python, AWS, Adobe Analytics, reporting, and dashboard solutions.
Student Data Analyst supporting Sun Life’s financial security mission through stakeholder insights and Tableau KPI reporting. Building data analysis skills during a four - month hybrid campus placement.
Analyste de données principal modernisant les plateformes et pipelines de données d’EDC, société financière publique canadienne. Traduction des besoins opérationnels en modèles, règles de transformation et récits utilisateurs.
Senior Data Analyst modernizing enterprise data capabilities at Export Development Canada. Translating business requirements into data models, mappings, pipelines and Agile delivery artifacts.
Data Analyst improving Instacart’s online grocery fulfillment quality through operational analytics. Monitoring retailer performance, diagnosing issues, and delivering recommendations to cross - functional stakeholders.