Azure Data Engineer Lead
Role summary
We are seeking an experienced Lead Data Engineer for a 12+ month contract in Toronto, Canada. This hybrid role will spearhead the design, development, and implementation of the enterprise data platform, focusing on scalability, performance, and innovation. The ideal candidate will have 8+ years of experience in data engineering, with strong expertise in Data Architecture, Data Modelling, ELT processes, and pipeline development. Hands-on experience with Snowflake, SQL, Azure Data Services, and Python is required. The role involves leading data strategy, mentoring teams, ensuring data quality and governance, and translating business needs into robust data solutions within the financial services domain.
Job Title: Lead Data Engineer
Location: Canada (Hybrid Toronto)
12 + Months Contract Position
About the Role:
We are seeking an experienced Lead Data Engineer to spearhead the design, development, and implementation of our enterprise data platform. This role will be instrumental in shaping and driving our data engineering roadmap, ensuring scalability, performance, and innovation. The ideal candidate combines deep technical expertise with strong leadership skills and a solid understanding of financial services data domains.
Key Responsibilities:
- Lead the
data architecture and engineering strategy
, ensuring alignment with business and technology roadmaps.
- Design and implement
data models, pipelines, and data integration frameworks
across multiple platforms.
- Partner with stakeholders to translate business requirements into
scalable data solutions
.
- Performance Optimization: Optimize data pipelines for performance, scalability, and reliability, including query tuning and resource management within Snowflake.
- Drive adoption of
best practices in data engineering design patterns
and modern cloud architectures.
- Data Quality Assurance: Implement and monitor data validation procedures to ensure data accuracy and consistency across systems.
- Collaboration and Communication: Work closely with project managers, data architects, and business analysts to align project milestones and deliverables with business goals.
- Mentor and guide data engineering teams (onsite & offshore) to deliver high-quality outcomes.
- Ensure compliance with data governance, security, and privacy standards.
- Documentation: Create and maintain detailed documentation of data pipelines, data flow diagrams, and transformation logic.
- Issue Resolution: Troubleshoot and resolve issues related to data pipelines, including job failures and performance bottlenecks.
Required Qualifications:
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- 8+ years of experience in data engineering with a strong focus on
Data Architecture
,
Data Modelling
(Conceptual, Logical, Physical), ELT processes and data pipeline development.
- Hands-on experience with
Snowflake
cloud data platform, including data sharing, secure views, and performance optimization.
- Proficiency in SQL
and familiarity with data integration and ETL/ELT tools.
- Azure Data Services and other Cloud Technologies
(Glue, EMR)
- Data Bricks hands on experience
- Python
for data engineering workflows
- Strong understanding of
data engineering design patterns
- Strong problem-solving skills and the ability to work independently to meet deadlines.
- Excellent communication skills for effectively interacting with technical and non-technical stakeholders.
Preferred Qualifications:
- Certifications in Snowflake or relevant data technologies.
- Experience in the financial services sector, especially asset management / alternative investments, with an understanding of data security and compliance requirements.
- Familiarity with cloud platforms (e.g., AWS, Azure) and data orchestration tools (e.g., Apache Airflow).
- Knowledge of data visualization tools (e.g., Tableau, Power BI).
