Data Engineer transforming complex data sources into structured datasets for audit insights. Collaborating with audit professionals using tools like Power BI and ensuring data quality and governance.
Responsibilities
Design and implement ETL processes to consolidate and clean data from various sources including Snowflake, Databricks, SQL databases, Excel files, SharePoint lists, and unstructured data sources.
Acquire business context through walkthroughs and stakeholder engagement to ensure audit-relevant data is appropriately understood and used.
Ensure data models are optimized for performance and usability.
Validate data outputs against business reports and known benchmarks to ensure accuracy and completeness.
Implement data quality checks and reconciliation processes.
Handle sensitive data securely, following internal policies and regulatory standards.
Apply appropriate data protection techniques (e.g. masking, encryption) and manage access controls.
Work closely with auditors to understand data requirements and provide technical support.
Document data flows, transformations, and business logic for transparency and auditability.
Help improve the audit team data literacy by documenting data fields and libraries.
Identify opportunities to automate and streamline data preparation and update processes.
Stay current with best practices in data engineering and analytics.
Requirements
2-5 years of experience in data development and data engineering
Strong ETL skills and experience working with relational databases
Strong knowledge of SQL and working level knowledge of programming language Python
Strong documentation practices, experience working with GitHub and Confluence
Experience working with structured, semi-structured, and unstructured data sources
Understanding of data governance, validation, and reconciliation techniques, as well as good security practices
Excellent problem-solving skills and attention to detail
Strong communication skills and ability to work collaboratively with non-technical stakeholders
For candidates located in Quebec, bilingualism is required considering the necessity to interact on a regular basis with English-speaking colleagues across the country.
Benefits
Opportunities for professional growth and development in data and analytics
Collaborate with a dynamic and supportive team
Work on impactful projects that support transparency and accountability
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.
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.