Lead Data Engineer

SOTI; Mississauga; On-site; CAD 80,000 - 120,000; Full time

Job summary

An innovative company is seeking a Lead Data Engineer to drive impactful projects and lead a dynamic team. This role offers the opportunity to work with cutting-edge technologies in a fast-paced environment, focusing on data governance and cloud solutions. You'll be responsible for designing scalable architectures and ensuring the delivery of high-quality data solutions. Join a culture that values personal growth and continuous innovation, where your contributions will make a significant difference in the world of mobile and IoT device management. If you're passionate about data engineering and eager to tackle complex challenges, this is the perfect opportunity for you.

Qualifications

• 10+ years of experience in BI solutions and data engineering.
• Proven track record in leading data engineering teams.
• Strong understanding of cloud-based data solutions.

Responsibilities

• Lead and manage a team of data engineers to deliver projects.
• Design scalable data architectures within Azure and SQL.
• Translate business requirements into technical documentation.

Skills

Azure Data Factory

SQL Server

Python

Data Warehouse concepts

ETL tools

Data governance

Analytical skills

Education

Bachelor's Degree in Computer Science or related field

Master's Degree (preferred)

Tools

Microsoft Azure Synapse Analytics

SSAS

SSIS

SSRS

C#

Job description

Join to apply for the Lead Data Engineer role at SOTI

Join to apply for the Lead Data Engineer role at SOTI

SOTI is committed to providing its employees with endless possibilities; learning new things, working with the latest technologies and making a difference in the world.

Job Title:

Lead Data Engineer

Location:

Mississauga, Canada

Who We Are

At SOTI, we are committed to delivering best in class mobile and IoT device management solutions. We are looking for out of the box thinkers that appreciate the art of creating great software. To us, being visionary is more important than doing things the way they’ve always been done.

What’s in it for you?

The People - From our humble origins in our founder’s basement, to our industry leading position today, SOTI has worked hard to foster a company culture that we can all believe in. A culture that emphasizes personal growth, continuous innovation and fun.

The Growth - Our environment fosters new ideas, fresh perspectives, and the ability to take them over the goal line. SOTI is a fast-paced environment with a global reach that encourages you to make your mark and be part of something big!

The Technology - You’ll get the chance to work with leading edge technologies and take on complex and interesting projects, as part of highly collaborative and agile teams. You will work alongside SOTI’s partners which include leading tech giants that will keep you on the cusp of emerging technologies.

SOTI is looking for a Lead Data Engineer to join our dynamic Business Intelligence team, bringing a proven track record of successfully leading Data Engineering teams and making a positive impact in previous roles. We are seeking individuals who are deeply curious, passionate about exploring modern technologies, and eager to tackle complex data engineering challenges.

The ideal candidate will have a strong understanding of business intelligence practices, data governance, and cloud-based data solutions - particularly within the Azure environment. They should be comfortable in a fast-paced, agile setting and skilled at managing both strategic and tactical aspects of BI strategy, governance, and analytics delivery.

As part of our expanding team, you will work with cutting-edge technologies on complex, high-impact projects that provide innovative mobile device solutions to global enterprise clients, while contributing ideas that support your professional growth and drive motivating career advancement at SOTI.

What You’ll Do

• Lead and manage a driven team of data engineers
• Design, implement, and manage scalable data architectures within the SQL server, Microsoft Azure Synapse Analytics and Microsoft Fabric ecosystem.
• Work with BI Engineers/Business Partners, Data Architects, and internal customers to create project plans, manage, and track projects to deliver.
• Translate and document business requirements into technical documentation, supporting document management and knowledge sharing.
• Take ownership of end-to-end design and all aspects of the development and ensure design and development standards.
• Works closely with data architecture to ensure proper adherence to architectural guidelines and principles.
• Maintain end-to-end on-prem and cloud infrastructure consisting of traditional and modern data pipelines and data stores.
• Design and build monitoring and reconciliation procedures to maintain and improve data pipelines.
• Create project documentation (detailed design, source-to-target mappings, implementation plans, etc.).
• Develop data and database-oriented solutions to solve complex business problems leading to data-driven decision making.
• Design and develop data integration processes to integrate disparate data sets into a cohesive data model in support of BI and analytical requirements.
• Ensure assigned deliverables are within business/audit control requirements.
• Train new team members and guide them to use technology as the tool to solve business problems using data.
  
  

Qualifications:

• Proven track record of successfully implementing end-to-end data engineering solutions.
• 3+ years of experience in leading a data engineering team.
• 10+ years of advanced hands-on experience designing and developing BI solutions and providing technical expertise.
• Strong knowledge of Azure data services, such as Azure Data Factory, Azure Synapse Analytics and One Lake.
• 10+ years of experience with MS SQL Business Intelligence Stack (SSAS, SSIS, and SSRS).
• 5+ years of experience with Python, Scala or related big data technology.
• Experience building semantic models using Sql Server and data connections to Sql Server and/or cloud data lakes
• Experience using Cloud architecture and NoSQL databases.
• Experience using building data pipelines to integrate with unstructured data sources.
• Experience with Data Warehouse concepts, including the use of Extract, Transform, and Load (ETL) tools.
• Excellent analytical, troubleshooting, problem-solving, and research skills.
• Familiarity with big data technologies and analytics tools within the Microsoft fabric ecosystem, such as real-time intelligence, data activator, reflex.
• Basic knowledge in writing services using C# is a preference.
  
  

If you want to bring your ideas to life, apply at SOTI today.

We are committed to providing accessible employment practices that are in compliance with the requirements under the Human Rights Code and the Accessibility for Ontarians with Disabilities Act (AODA). If you require accommodation during any stage of the recruitment process, please notify People & Culture at [e-mail].

Please note that SOTI does not accept unsolicited resumes from recruiters or employment agencies. In the absence of a signed Services Agreement with agency/recruiter, SOTI will not consider or agree to payment of any referral compensation or recruiter fee.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Software Development

Referrals increase your chances of interviewing at SOTI by 2x

Sign in to set job alerts for “Data Engineer” roles.

Richmond Hill, Ontario, Canada 1 week ago

Software Engineer, Backend (All Levels / All Teams)

Software Engineer I, Entry Level (Fall 2024-Spring 2025) - Toronto

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.