Jr. Engineer - Data Warehouse

company

CBTS serves enterprise and midmarket clients in all industries across the United States and Canada. CBTS combines deep technical expertise with a full suite of flexible technology solutions--including Application Modernization, Managed Hybrid Cloud, Cybersecurity, Unified Communications, and Infrastructure solutions. From developing and deploying modern applications and the secure, scalable platforms on which they run, to managing, monitoring, and optimizing their operations, CBTS delivers comprehensive technology solutions for its clients' transformative business initiatives. For more information, please visit www.cbts.com .

OnX is a leading technology solution provider that serves businesses, healthcare organizations, and government agencies across Canada. OnX combines deep technical expertise with a full suite of flexible technology solutions—including Generative AI, Application Modernization, Managed Hybrid Cloud, Cybersecurity, Unified Communications, and Infrastructure solutions. From developing and deploying modern applications and the secure, scalable platforms on which they run, to managing, monitoring, and optimizing their operations, OnX delivers comprehensive technology solutions for its clients’ transformative business initiatives. For more information, please visit www.onx.com .

role

Jr. Engineer - Data Warehouse
Role Purpose: Supports the development, maintenance, and monitoring of data warehouse solutions by performing assigned data integration, modelling, testing, and operational tasks under guidance, helping deliver reliable data for reporting and analytics

Key Responsibilities:

·        Assist in building and maintaining data warehouse tables, data models, and ETL/ELT pipelines based on defined designs and standards.

·        Write and optimize basic SQL queries for data extraction, transformation, validation, and reporting requirements.

·        Support data ingestion from source systems and help troubleshoot routine pipeline, data quality, and job-scheduling issues.

·        Perform unit testing, reconciliation, and documentation to ensure data accuracy, completeness, and traceability.

·        Monitor scheduled workloads and escalate performance, availability, or access issues in line with support procedures.

·        Follow established data governance, security, privacy, naming, version-control, and deployment practices.

Collaborate with senior engineers, analysts, and business stakeholders to clarify requirements and deliver assigned work on time