Senior Data Engineer

Orca has been providing freight audit and analytics services to its growing client base since 2016. We have experienced tremendous growth since inception and are proud to offer our solution to some of North America’s largest organizations. Orca processes billions of dollars in freight invoices each year for clients and provides invaluable reporting and analysis to help our clients operate more efficiently. Orca was awarded London’s prestigious ‘Medium Business of the Year’ award in 2024 by the London Chamber of Commerce for tremendous growth and community involvement.

Job Summary

The successful candidate will be responsible for leading the rebuild of Orca’s data platform. Working with our existing Azure SQL, SQL Server on Azure VMs, and Azure Fabric environment, this role will assess what is working, identify gaps and risks, and design and implement improved data architecture and pipelines. The candidate will work closely with external data architecture partners, our internal analytics team, and key stakeholders to deliver a modern, scalable, and reliable data platform that supports both internal operations and client‑facing analytics.

The candidate will act as the technical owner of Orca’s data platform, ensuring that data is accurate, timely, and accessible, while reducing manual processes through automation. The successful candidate may also support and take on responsibilities including performance tuning, reliability, and general data operations.

Responsibilities

• Lead the assessment of Orca’s current data landscape (Azure SQL, SQL Server on Azure VMs, Azure Fabric, and related integrations) and document strengths, weaknesses, and risks
• Design and implement a modernized data platform architecture in partnership with external advisors and internal stakeholders
• Build, maintain, and optimize ETL / ELT pipelines to ingest, transform, and deliver data for analytics and operational needs
• Standardize and automate manual data processes, reports, and extracts wherever possible
• Own database performance and reliability, including indexing, query optimization, capacity planning, and environment management
• Implement and manage backup, restore, and disaster recovery processes for critical data systems
• Collaborate closely with our team of data and business analysts to ensure they have clean, well‑modeled, and well‑documented data for Power BI and other reporting tools
• Establish and maintain data quality checks, monitoring, and alerting for key data flows
• Contribute to data governance practices, including naming conventions, documentation, and data access controls
• Provide technical guidance and best practices to internal teams on data‑related topics and support broader data initiatives as required

Qualifications

The following qualifications are not required, however would be considered a strong asset :

Key Traits

Compensation

Seniority level

Mid‑Senior level

Employment type

Full‑time

Job function

Information Technology

Industries

Transportation, Logistics, Supply Chain and Storage

Referrals increase your chances of interviewing at Orca Intelligence by 2x.

Get notified about new Senior Data Engineer jobs in London, Ontario, Canada .

#J-18808-Ljbffr