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.
About the role
- Data Analyst (Hybrid, Toronto): Analyze Netezza databases, assess migration to Azure, perform data mapping, modeling, and documentation.
Responsibilities
- Analyze all Netezza database tables to identify business-critical and frequently used tables, redundant and unused data assets. Perform data profiling and quality analysis. Assess data dependencies and relationships across systems. Evaluate and report on migration status from Netezza to Azure. Validate data consistency between environments. Create source-to-target data mapping documents and establish end-to-end data lineage. Develop metadata repository, data dictionary, and taxonomy. Perform data modeling including conceptual, logical, and physical models. Write and optimize SQL queries, develop DDL scripts, and perform data wrangling using Python. Work with data lakes and structured/unstructured data sources.
Requirements
- 4+ years of experience in data analysis, data modeling, or data engineering roles. Strong expertise in SQL (mandatory) and Python (or other scripting languages). Experience with Netezza and cloud platforms (preferably Azure). Experience with data modeling tools (e.g., ERwin, ER/Studio, Azure tools). Solid understanding of data lineage, metadata management, ETL/ELT processes, and data migration strategies. Data profiling, analysis, mapping, and documentation skills. Ability to collaborate with data engineers, BI/reporting teams, data science teams, and business stakeholders.
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 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.
Web Analyst owning GA4, GTM, pixel, and conversion tracking for an education and nonprofit marketing agency. Ensuring accurate, privacy - compliant data across client campaigns and CRM systems.
Data Analyst supporting client data migrations and corporate actions for Computershare, a global financial administration and transfer agency leader. Ensuring data quality, mapping, validation, and operational sign - off.
Associate Director advancing UJA Toronto’s nonprofit fundraising through donor analytics, predictive modeling, and prospect intelligence. Leading data strategy, pipeline development, and a two - person analytics team.
Sales Force Effectiveness Specialist optimizing territories, targeting and dashboards for GSK, a global biopharma company. Translating sales and market data into actionable commercial insights.
Water and wastewater planning consultant analyzing infrastructure data, forecasting demand, and developing sustainable servicing strategies. Supporting KWL’s consulting engineering projects across Western Canada.
Data analytics intern supporting TD Insurance’s data governance, operational insights, datasets, dashboards, and reporting. Four - month Winter 2027 placement in Montréal or Toronto.
Bilingual Data Analyst translating General Motors social data into performance insights at independent creative agency Rethink. Building reports, dashboards, and recommendations for campaigns and content.