Senior Data Engineer in Toronto

We are seeking a highly skilled and strategic Senior Data Engineer to join our team. In this advanced individual contributor role, you will spearhead the development of sophisticated, insightful, and visually compelling reporting solutions using tools such as DBT, Snowflake, Claude.AI, SQL, Power BI, Tableau, Python, Excel, and PowerPoint. A critical component of this position involves pioneering the integration of advanced AI solutions into our reporting processes to significantly enhance data-driven decision-making for our stakeholders. Strategic collaboration with diverse stakeholders is paramount to ensure our reporting solutions address complex business needs effectively.

Key Responsibilities

• Lead the architecture, development, design, and maintenance of complex, interactive, and dynamic data pipelines, frameworks and dashboards using DBT, SQL, Python, Claude.AI, Power BI, Tableau, Excel, and PowerPoint.
• Partner strategically with senior stakeholders to define complex reporting needs, deliver high-impact actionable insights, and drive data-informed strategies.
• Champion and implement advanced AI and machine learning techniques to innovate reporting solutions and provide predictive and prescriptive insights.
• Conduct in-depth analysis of large, complex datasets to uncover critical trends, patterns, and anomalies that directly inform strategic business decisions.
• Establish and enforce best practices for data integrity, accuracy, and governance across all reporting solutions, and mentor team members on these standards.
• Provide expert guidance, mentorship, and training to team members and stakeholders on advanced reporting tools, analytical methodologies, and emerging AI technologies.
• Drive continuous improvement initiatives for reporting processes and tools, proactively research and implement cutting-edge industry trends and technologies, and contribute to the team's technical roadmap.
• Articulate complex findings and strategic recommendations to executive-level stakeholders through compelling presentations and comprehensive reports.
• Lead data projects from conception through deployment, ensuring alignment with business objectives and technical excellence.
• Act as a subject matter expert and technical escalation point for data analysis and reporting within the team.

Required Qualifications

• Possess a Bachelor’s degree in Engineering, Data Science, Computer Science, Statistics, Business Analytics, or a related field; a Master’s degree is a strong plus.
• Have 5+ years of progressive experience in data engineering or a similar role, with a proven track record of leading complex reporting and dashboard projects and delivering impactful business intelligence solutions.
• Demonstrate expert proficiency in DBT, SQL, Alteryx, Snowflake, Power BI, Tableau, Python (for data analysis and scripting), Excel (including advanced functions and modeling), and PowerPoint.
• Have extensive, hands-on experience designing, implementing, and operationalizing AI solutions and machine learning algorithms to solve challenging business problems.
• Exhibit exceptional data analytical, critical thinking, and problem-solving skills, with a demonstrated ability to interpret complex data and translate it into strategic business insights.
• Possess outstanding communication, presentation, and influencing skills, with the ability to convey complex technical concepts clearly and persuasively to diverse audiences, including senior leadership.

Preferred Qualifications

• Have a proven ability to lead technical initiatives, operate with a high degree of autonomy, collaborate effectively in a team environment, and mentor junior colleagues.
• Show advanced proficiency in programming languages such as Python or R for complex data analysis, automation, and statistical modeling.
• Have expert-level skills in SQL, Snowflake, DBT, for complex data extraction, manipulation, transformation, and query optimization.
• Possess a deep understanding and practical experience with data warehousing concepts, ETL processes, data governance principles, and emerging AI technologies like Claude.AI, Copilot, Large Language Models (LLMs).
• Demonstrate a strategic mindset with the ability to connect data insights to broader business strategy and outcomes.

What’s in it For You?

• Hybrid Work Model: We’ve adopted a flexible hybrid working environment for our office-based roles while delivering a seamless experience that is digitally and physically connected.
• Flexibility & Work-Life Balance: Flex My Way is a set of supportive workplace policies designed to help manage personal and professional responsibilities, whether caring for family, giving back to the community, or finding time to refresh and reset.
• Career Development and Growth: By fostering a culture of continuous learning and skill development, we prepare our talent to tackle tomorrow’s challenges and deliver real-world solutions.
• Industry Competitive Benefits: We offer comprehensive benefit plans to include flexible vacation, two company-wide Mental Health Days off, access to the Headspace app, retirement savings, tuition reimbursement, employee incentive programs, and resources for mental, physical, and financial wellbeing.
• Culture: Globally recognized, award-winning reputation for inclusion and belonging, flexibility, work-life balance, and more.
• Social Impact: Make an impact in your community with our Social Impact Institute. We offer employees two paid volunteer days off annually and opportunities to get involved with pro-bono consulting projects and Environmental, Social, and Governance (ESG) initiatives.
• Making a Real-World Impact: We are one of the few companies globally that helps its customers pursue justice, truth, and transparency.