Data Engineer

VenorTalent; Toronto, Halifax; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading technology solutions provider is seeking a Data Engineer for their Toronto office to design and optimize data processes using Azure services. The role involves collaboration with teams to deliver high-performing data solutions, requiring strong skills in MS SQL and experience with Azure Data Factory. The company supports work-life balance and embraces a culture of belonging. Apply to join a team making impactful contributions to community supervision technology.

Benefits

Work-life balance focus

Global exposure

High trust, high ownership culture

Qualifications

• Strong experience in Microsoft SQL Server and Azure data ecosystems.
• Advanced proficiency in T-SQL development and query performance tuning.
• Familiarity with data architecture patterns, XML/JSON, and data orchestration.

Responsibilities

• Designing and maintaining ETL/ELT data processes.
• Developing and deploying data processes using Azure tools.
• Documenting technical and system specifications.

Skills

MS SQL (T-SQL) development

ETL/ELT processes

Azure Data Factory

Power BI

Communication skills

Education

Bachelor's degree in a related field

Tools

SQL Server

Azure Data Lake Storage

Azure Synapse

SSIS

Microsoft Fabric

Job description

Venor is proud to partner with Track Group Inc. on their search for a Data Engineer to join their global Research & Development team.

Track Group is a worldwide leader in advanced electronic monitoring and supervision solutions for the criminal justice and corrections market. For over 27 years, the company has been delivering reliable, technology-driven solutions to governments and agencies around the world, integrating state-of-the-art tracking devices with flexible software, analytics, and mobile-driven monitoring systems. Known for innovation, reliability, and customer focus, Track Group continues to redefine what’s possible in community supervision technology.

What You’ll Do

The Data Engineer will play a key role in designing, developing, testing, and maintaining automated and manual ETL/ELT data processes to ensure seamless data integration across systems. This role involves deep collaboration with internal teams, customers, and partners to deliver secure, scalable, and high-performing data solutions.

Key responsibilities include:

• Analyzing business requirements to design, develop, and manage ETL/ELT pipelines and provide datasets for business consumption.
• Developing, testing, deploying, and maintaining complex data processes using T-SQL, SSIS, Azure Data Factory (ADF), Synapse, and Fabric, incorporating logging, data validation, and integrity checks.
• Designing and implementing scalable and cost-effective data storage solutions using Azure SQL Database, Azure Data Lake Storage, and Azure Synapse Analytics.
• Building and managing Fabric data lakes within Azure and Fabric environments.
• Configuring, monitoring, and maintaining automated data movement pipelines to ensure top performance, availability, and security.
• Optimizing data extraction and load performance while minimizing OLTP system impact.
• Refining and automating manual data processes using Microsoft data tools, including SQL Server, ADF, Synapse, and Fabric.
• Documenting technical and system specifications for all data movement and transformation processes.
• Collaborating with database administrators, software developers, and business analysts to troubleshoot and resolve data integration and storage issues.
• Assisting developers with complex query tuning and participating in SQL code reviews.
• Providing ad-hoc data support and communicating database changes, risks, and updates to relevant stakeholders.
• Responding to and resolving production issues promptly to maintain high system reliability.

What You Bring

The ideal candidate is a technically skilled and detail-oriented data professional with strong experience in Microsoft SQL Server and Azure data ecosystems, capable of managing complex integrations in a fast-paced environment.

Qualifications include:

• Bachelor’s degree in a related field (or equivalent combination of education and experience).
• Advanced proficiency in MS SQL (T‑SQL) development and query performance tuning.
• Proven experience designing and implementing ETL/ELT processes using T‑SQL, SSIS, and Azure tools.
• Strong understanding of Azure services, including Azure Data Factory, Azure SQL Database, Azure Data Lake Storage, Azure Synapse, and Microsoft Fabric (Lakehouses, notebooks, Spark, and pipelines).
• Familiarity with data architecture patterns, XML/JSON, and data orchestration processes.
• Experience with Power BI, Microsoft Reporting Services (SSRS), and Red‑Gate tools (asset).
• Excellent analytical, troubleshooting, and documentation skills.
• Strong interpersonal and communication skills, with the ability to collaborate across technical and non-technical teams.
• High attention to detail, adaptability, and ability to balance multiple priorities.

Why Track Group

• Impactful mission: Directly improve public safety and support sustainable justice solutions.
• High trust, high ownership culture: Opportunities to design and deliver solutions with autonomy.
• Work-life balance focus: Organization, collaboration, and coding discipline mean delivering value within a regular workday.
• Global exposure: Work alongside teams across North America and internationally, on meaningful, real-world projects.
• Hybrid flexibility: Fully remote role with preference for candidates in the Halifax, NS or Toronto, ON area to allow for occasional in‑person collaboration.

Our Commitment to Belonging

At Venor and Track Group, we embrace a culture of belonging in the workplace. No matter who you are, where you’re from, how you think, what you believe in, or who you love, we welcome your application. We all come from different backgrounds and different walks of life, bringing unique perspectives and experiences. We encourage applications from 2SLGBTQ+, Black, Indigenous, and People of Colour (BIPOC), women, newcomers to Canada, and people with disabilities.

How to

Apply

To apply, please forward your resume to Nick Misener at [e-mail] and/or Vanessa Rodriguez Garcia at [e-mail].