Lead Data Engineer

Lead Data Engineer

We are seeking a highly skilled and strategic Lead 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 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 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.

• 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.

• 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 8+ 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, Excel (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, able to convey complex technical concepts clearly and persuasively to diverse audiences, including senior leadership.
• 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, and LLMs.
• Demonstrate a strategic mindset with the ability to connect data insights to broader business strategy and outcomes.

Base pay range: US – $110,000–$204,200

USD;
Canada –…