Lead Data Engineer

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

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

Qualifications:

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

#LI-AK1

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 careers@soti.net.

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.