Senior Data Engineer

ZenaTech Inc.; Toronto; On-site; CAD 120,000 - 180,000; Full time

Job summary

ZenaTech Inc. — a Nasdaq-listed AI drone and enterprise software company — seeks a Senior Data Engineer, Operations, to unify acquired firms' data into a single source of truth.

Based in Toronto, you will own the data warehouse, pipelines, and semantic layer enabling analysts to focus on insights. You will work with Snowflake/BigQuery/Redshift/Databricks and dbt, shaping data models, enforcing quality, and guiding other engineers.

Qualifications

• 5+ years in data engineering or analytics
• Experience integrating fragmented source systems across multiple entities
• Strong SQL and Python proficiency with modern data warehouses
• Ability to translate business needs into a usable dataset for analysts
• Comfort working with non-technical staff to define field meaning

Responsibilities

• Design, build, and maintain the operational data warehouse and ingestion pipelines
• Integrate source systems across acquired entities and regions
• Map charts of accounts and service taxonomies to a common model
• Own data quality, validation, reconciliation, and monitoring
• Build the semantic layer for BI tools and analysts
• Set technical standards and mentor a junior engineer

Skills

SQL

Python

Data warehousing

Data modeling

Stakeholder comms

Tools

Snowflake

BigQuery

Redshift

Databricks

dbt

Job description

ZenaTech (Nasdaq: ZENA | FSE: 49Q) is a technology company specializing in AI drones, Drone-as-a-Service (DaaS), enterprise SaaS, and quantum computing solutions for mission-critical business applications. Since 2017, the company has leveraged its software development expertise and expanded its drone design and manufacturing capabilities through ZenaDrone to innovate and enhance customer inspection, monitoring, safety, security, compliance, and surveying processes. ZenaTech serves over 100 enterprise software customers in law enforcement, government, and industrial sectors, with drones used in agriculture, defense, and logistics industries. The company has offices in North America, Europe, and the UAE.

This position will be at our 250 University Ave, Toronto, ON M5G location.

Overview:

The Senior Data Engineer, Operations will build and own the consolidated operational data model that everything else depends on. Every acquired firm arrives with its own accounting, scheduling, and job management systems. This role turns that into a single queryable source of truth so analysts analyse rather than reconcile.

Responsibilities

• Design, build, and maintain the operational data warehouse and ingestion pipelines
• Integrate source systems across acquired entities in both regions, including systems that will never be migrated off
• Map inconsistent charts of accounts, job codes, and service line taxonomies to a common model
• Own data quality: validation, reconciliation to the general ledger, monitoring and alerting
• Build and maintain the semantic layer the analysts and BI tools sit on
• Set technical standards and mentor the second engineer

Requirements

• 5+ years in data engineering, with demonstrated experience integrating fragmented or legacy source systems
• Strong SQL and Python; hands-on with a modern warehouse (Snowflake, BigQuery, Redshift, or Databricks) and a transformation framework such as dbt
• Experience ingesting from small-business accounting platforms — QuickBooks, Sage, NetSuite — which is what most acquired firms run
• Pragmatic about scope: delivers a usable dataset in weeks rather than architecting for three quarters
• Comfortable working directly with non-technical branch staff to establish what a field actually means

We use artificial intelligence to review and screen applications and materials. However, every candidate we move forward with is reviewed and selected, and all final hiring decisions are made by a member of our hiring team.

“We are an equal opportunity employer committed to employment equity utilizing hiring practices on merit and business needs. We encourage applications from women, Indigenous peoples, persons with disabilities, members of visible minorities and all others of legally protected status.”