Sql jobs in Canada

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.

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.

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

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.

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

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

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.

To apply, please forward your resume to Nick Misener at nick@venor.ca and/or Vanessa Rodriguez Garcia at vanessa@venor.ca.