Lead Data Engineer

At CWP Energy Trading, we are an innovative company operating at the intersection of energy analytics and fintech. Our mission is to leverage high-quality data analytics and deep market expertise to optimize power markets. We are looking for a Lead Data Engineer to support multiple teams across the company by building and maintaining a scalable data infrastructure.

As Lead Data Engineer, you'll drive the consolidation of our data infrastructure, shape the team with best practices, and drive data governance. With a strategic mindset, you'll prioritize data needs and keep stakeholders informed.

Key Responsibilities

• Build and maintain reliable data pipelines to integrate data from many heterogeneous sources.
• Develop and maintain a data catalog documenting all datasets, their sources, and usage guidelines.
• Own the user experience of data users across the business, supporting both structured analytics and ad-hoc querying needs.
• Drive the data infrastructure, including the use of infrastructure-as-code tools, across all data projects.
• Implement and support both batch processing and real-time streaming solutions.
• Work closely with multiple teams across the company to define and prioritize data needs.
• Act as the technical lead for the development team, providing guidance on best practices, mentoring junior engineers, and contributing to architectural decisions. Ensure that the data strategy is aligned with the short, mid and long term needs of the business.
• Regularly update stakeholders on data availability, system performance, and project status.

Required Skills & Qualifications

• 8+ years of experience in data engineering or a related field.
• Demonstrated expertise in data warehousing and data governance at data-intensive organizations.
• Proficiency in Python and SQL for data processing.
• Strong experience with analytical databases (BigQuery, Snowflake, Databricks).
• Experience with ETL/ELT pipelines and workflow orchestration tools (Dagster, Apache Airflow, dbt).
• Proven track record in taming large numbers of heterogeneous data sources.
• Expertise in at least one cloud computing platform (GCP is a plus).
• Experience with real-time data streaming technologies is desirable (Dataflow, Kafka, Flink, Spark Streaming, Kinesis).
• Experience with AI/ML is highly desirable, including proficiency with frameworks such as TensorFlow, PyTorch, Keras, and tools for model training and optimization. Familiarity with large language models (LLMs), reinforcement learning, and model deployment will be a plus.
• Tech Lead / Team Lead experience, with the ability to scope, prioritize, and manage multiple workstreams.
• Strong communication and stakeholder management skills, with the ability to present technical concepts to non-technical audiences.
• Senior and versatile professional, comfortable when interacting with developers as well as C-Suite stakeholders.

Why Join Us?

• A dynamic environment that encourages initiative and experimentation. Here’s McGill St Laurent
• A results-driven corporate culture.
• Full group insurance and an RRSP contribution program.
• Vacation policy from day one.
• Public transit incentive program.
• Give & Match program.
• Flexible hours and hybrid work options.
• A modern office with a gym, lounge, locker rooms, and showers.

We collect your information via a secure applicant tracking system, where access is restricted according to the position. Data, including CVs and interview notes, are stored in this system. If you have any objections or wish to withdraw your consent, please contact us at talent@mcgillstlaurent.com.