Industry
Data Engineer
Bell Canada - Data Engineering & Artificial Intelligence Team
Toronto, Ontario, Canada (Remote)
Primary owner of the Network Ticket Service data pipeline alongside CS Attack RCA work and the CSAP pipeline. CS Attack work directly supported 2 directors, 1 VP, and multiple engineering managers across a cross-country footprint; CSAP served multiple directors, engineering managers, BI partners, and 20+ downstream consumers across Bell.
78attributes delivered
78,000+records recovered
83%query optimization
12pipelines maintained
Enterprise analytics platform deliveryCS Attack stakeholder RCA deliveryCSAP cross-country stakeholder supportFull-stack RCA and data recoveryQuery performance re-architectureCross-domain technical investigationProduction system ownershipCloud migration preparation
- Built and productionized the mission-critical Network Ticket Service data pipeline on Teradata using a three-tier ETL and ELT architecture across staging, warehouse, and analysis layers.
- Integrated four operational systems including REST API event streams, ERP, billing, and directory services using Python and SAS Data Integration while enforcing data contracts and Kimball-style dimensional modeling patterns.
- Built a stateful sessionization algorithm in Python to fix event sequencing defects, refactoring a flawed sequential method into a robust two-pass group-by propagation model.
- Reduced query latency by 83 percent, from 12 minutes to 2 minutes, on a join over 23 million rows by replacing dynamic runtime computation with a materialized pre-aggregation layer.
- Expanded analytical coverage by 800 percent, from 1 month to 9+ months, by running RCA on a hardcoded 30-day lookback filter and executing staged historical recasts correcting 78,000+ records.
- Fixed historical attribution defects by implementing SCD Type 2 temporal joins on creation date to resolve employee hierarchy changes against directory services data.
- Prevented duplicate data during retries by enforcing idempotency and atomic writes via composite upsert keys with sanitized join conditions and pre-aggregation patterns.
- Refactored monolithic SQL into modular clean and calculate transformation stages, creating a unified abstraction layer that enabled zero-downtime migration for downstream BI consumers.
- Built a Python and Apache Airflow observability module with configuration-driven validation checks across 12+ pipelines, reducing debugging time by 60 percent and preventing 15+ monthly data incidents.
- Promoted to Technical Gatekeeper within 3 months and authored end-to-end validation documents including ERDs, data flow diagrams, and count-by-stage proofs.
- Led requirements gathering and feasibility assessments for new pipeline initiatives, translating business needs into technical architectures and implementation roadmaps.
- Delivered roughly five CS Attack RCAs end to end, tracing source-system behavior, pressure-testing feasibility, outlining implementation plans, and documenting tradeoffs for 2 directors, 1 VP, and multiple engineering managers across Bell's national footprint.
- Supported the CSAP pipeline as a stakeholder-facing data product for multiple directors, engineering managers, BI partners, and 20+ downstream consumers across the country, aligning pipeline design and analytics delivery with operational needs.
- Presented pipeline performance and data quality metrics to directors, team leads, and analysts to drive buy-in for platform modernization.
Expanded scope: platform delivery and cross-domain ownership
- Shipped a 78-attribute analytics platform in MicroStrategy integrating SmartPath, Maximo, IPACT, and LDAP with derived metrics, conditional formatting, cross-filter interactivity, and director sign-off.
- Reduced build cost and risk through strategic architectural decisions, including choosing a SQL view over a physical fact table and expanding the design from 13 columns to 78 attributes.
- Maintained 12 dependent data pipelines as backup owner during a company-wide code embargo, resolving ETL failures and BI metric misconfigurations under time pressure.
- Ramped from zero domain knowledge to full system comprehension within 2 weeks for a five-system pipeline and built a repeatable metadata discovery method using the Teradata system catalog.
- Owned stakeholder-facing CS Attack and CSAP conversations, turning ambiguous asks into feasibility calls, sequencing plans, and implementation tradeoffs leadership could act on.
- Co-authored the team engineering workflow standard, formalizing separation of investigation and implementation phases with front-door ticketing and stakeholder scope boundaries.
- Became a canonical source of institutional knowledge across NTS, SmartPath, CS Attack, and CSAP during a leadership transition and refactored team documentation into executive and technical layers.
- Supporting the Q1 2026 migration to GCP and BigQuery with a roadmap from legacy SAS DI to cloud-native DAG orchestration on Cloud Composer.
PythonSQLSAS DITeradataETL/ELTData WarehousingDimensional ModelingSnowflake SchemaSCD Type 2Root Cause AnalysisPerformance TuningAlgorithm DesignData ModelingMicroStrategyApache AirflowCloud ComposerBigQueryGCPData QualityObservabilityProduction OwnershipStakeholder ManagementConfluence/Jira