Senior Data Engineer

TrackTik Inc.; Montreal (administrative region); On-site; CAD 120,000 - 160,000; Full time

Benefits offered by this job

Hybrid and flexible work model

Three weeks of vacation starting in你的第

Job summary

Trackforce is seeking a highly skilled Senior Data Engineer to design, build, and maintain scalable data pipelines powering our SaaS platform. You will shape the data foundation for global clients, ensuring secure, accurate data access across tenants.

You will collaborate with Product, Engineering, and DevOps to deliver reliable data solutions and mentor teammates while shaping our data strategy with modern lakehouse architectures.

Qualifications

• Bachelor’s degree or hands-on equivalent in a technical field.
• Proven experience in designing and operating large-scale data pipelines.
• Strong SQL and data modeling skills for multi-tenant SaaS data.

Responsibilities

• Design, build, and operate scalable ETL/ELT pipelines for multi-tenant data.
• Implement CDC and high-volume near-real-time ingestion.
• Design data models and lakehouse schemas for client data.
• Contribute to API-as-product data access patterns and docs.
• Establish data quality monitoring, alerting, and observability.
• Enforce multi-tenant data isolation and governance.
• Partner with Product, Engineering, and DevOps to translate requirements.
• Mentor teammates and raise engineering quality.
• Leverage AI-assisted tools in pipeline development and docs.
• Build data foundation scalable for analytics and AI capabilities.

Skills

SQL

Relational data modeling

ETL/ELT pipelines

Data warehousing

AWS data services

Spark/PySpark

Streaming ingestion

Data governance

Automation

Communication

Education

Bachelor's degree in Computer Science, Information Technology, Engineering, or related field

Tools

dbt

Job description

At Trackforce, we are transforming physical security operations that are managed around the world. As the leading SaaS platform for physical security workforce management, we provide security companies and organizations with a streamlined solution to manage their guard forces, respond faster, operate more efficiently, and reduce costs — all while staying focused on safety and protection.

We support 4,600+ clients across more than 50 countries and are proud to be a growing team of 300+ professionals. With our headquarters in Dallas, Texas, and Centers of Excellence in Montreal, Quebec and Wroclaw, Poland, we collaborate across regions and time zones in a hybrid work environment that combines flexibility, connection, and meaningful impact.

At Trackforce, we operate in both hybrid and remote models, offering flexibility to balance in‑office collaboration with WFH. This approach allows our teams to stay connected while maintaining autonomy and work‑life balance. We are highly focused on delivering value to our customers, and our recent merger has strengthened our position as the market leader in security workforce management software.

$100 - $130 a year

Trackforce is seeking a highly skilled and motivated Senior Data Engineer to join our Data team. In this role, you will be responsible for designing, building, and maintaining the data infrastructure that powers our SaaS platform, enabling clients across the globe to manage their security workforces with speed, accuracy, and insight.

You'll design and ship the pipelines and data models that move multi-tenant data from our platform into a modern, query-ready foundation. And you'll help shape the technical direction alongside the engineering manager and the team as we define the strategy. This is a zero-to-one role for someone who wants to build the foundation, not inherit it.

This is a high-impact, technically deep role for an engineer who is passionate about scalable data systems, thrives in a collaborative environment, and is eager to help shape the data foundation of a growing global SaaS company.

WHAT YOU'LL BE DOING;

Data Architecture & Pipeline Development

• Design, build, and operate scalable ETL/ELT pipelines that ingest, transform, and load multi-tenant data into a data warehouse/lakehouse.
• Build for change data capture (CDC) and high-volume, near-real-time ingestion; tune pipelines for reliability, performance, and cost.
• Help design the data models and lakehouse schema that make client-facing data accurate, performant, and secure to expose per tenant.
• Contribute to the API-as-product effort — data access patterns, versioning, and documentation that clients depend on.

Quality, governance & security

• Establish data quality monitoring, alerting, and observability across core data domains.
• Implement multi-tenant data isolation and governance practices appropriate for enterprise, compliance-sensitive clients.
• Act as a go-to for investigating and resolving data integrity and availability issues.

Collaborate & elevate

• Partner across Product, Engineering, and DevOps to turn requirements into pragmatic data solutions.
• Share knowledge and mentor teammates as the team grows; help set a high bar for engineering quality.
• Use AI-assisted development tools in your own workflow (pipeline code, query optimization, documentation) and share what works.
• Build with an eye toward a data foundation that can later power analytics and AI/agent-based capabilities.

WHAT WE'RE LOOKING FOR:

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field (or equivalent hands‑on experience).
• 7+ years in data engineering, with strong SQL and relational data modeling on large datasets.
• Proven experience designing and operating ETL/ELT pipelines into a data warehouse or data lake/lakehouse.
• Hands‑on with AWS data services (e.g., S3, Glue, Athena; DMS or similar CDC tooling)
• Experience with distributed data processing (e.g., Spark/PySpark) and modern lakehouse table formats (e.g., Apache Iceberg, Delta), or a strong track record that transfers.
• Comfortable with streaming/queue‑based ingestion (e.g., Kinesis, SQS, Kafka) and building for scale and failure.
• Solid grounding in data governance, quality, and compliance, ideally for multi‑tenant SaaS data.
• Proficiency in pipeline automation.
• Clear communicator who ships pragmatically in ambiguity.
• Nice to have: dbt or similar transformation frameworks; experience exposing client‑facing data via APIs or governed data sharing; SaaS or workforce‑management/physical‑security domain exposure; familiarity with AI/ML data infrastructure patterns.

Success Metrics

• Success in this role will be measured by the following outcomes within the first 3, 6 and 12 months:
• First 90 days: ship a first working pipeline component end-to-end and, with the team, produce a prioritized plan for the data platform build‑out.
• 6 months: demonstrable improvements in pipeline reliability and processing performance; a repeatable pattern for onboarding new data domains.
• 12 months: governance and quality monitoring established across core domains; at least one major, production‑grade pipeline/lakehouse component powering a client-facing or analytics capability.
• Trusted collaborator — strong cross‑functional feedback on delivery, knowledge sharing, and raising the technical bar.

Our office is now located at 2020 Blvd Robert‑Bourassa, Suite 2000, Montreal, QC H3A 2A5, offering a more central and easily accessible workspace.

Benefits We Offer

• Hybrid and flexible work model
• Three weeks of vacation starting in your first year
• Paid sick days & family obligation days
• Comprehensive health & dental coverage from Day1
• 24/7 telemedicine access
• Mental health & wellness support
• Life insurance, AD&D, long term‑disability & critical illness coverage
• RRSP & DPSP with employer matching
• Employee referral bonus
• Paid volunteer day & recognition programs

At Trackforce, we are committed to providing an inclusive, respectful, and discrimination‑free workplace. We do not tolerate discrimination or harassment of any kind and make employment decisions based on qualifications, merit, and business needs. We proudly comply with local employment laws and are an equal opportunity employer in all locations where we operate.