Senior Data Architect delivering enterprise-scale data and analytics solutions at 3Pillar. Leading design and delivery of analytics platforms in mixed prem and cloud environments.
Responsibilities
Architecture & Solution Design
Own full lifecycle delivery: requirements → design → build → deploy → adoption → optimization & support
Ensure performance, scalability, and reliability across EDW and BI platforms
Drive cloud deployment and production readiness of analytics solutions
Facilitate architecture and technical design sessions
Act as a trusted advisor bridging business strategy and technical delivery
Lead and mentor BI developers, data engineers, and analysts
Establish and enforce data governance, data stewardship, security, and reporting standards
Requirements
15+ years in data architecture, or data engineering roles
Proven experience owning and delivering enterprise EDW/BI solutions end-to-end
Demonstrated accountability for full lifecycle delivery (design, build, deploy, optimize, adoption)
Expertise in cloud platforms such as AWS GLue and Amazon Redshift
Deep expertise in dimensional modeling (star schema, fact/dimension design)
Strong hands-on SQL and data modeling expertise using Microsoft SQL Server
Experience building and optimizing ETL/ELT pipelines and large-scale data platforms using current ETL tools
Proven Experience working with complex, high-volume, multi-source data environments
Prior experience implementing or integrating BI solutions ideally using Tableau
Experience deploying solutions in cloud environments (nice to have AWS, or Azure)
Proven leadership experience mentoring teams and engaging senior stakeholders.
Benefits
100% 3Pillar funded medical and dental coverage for employees and their dependents
Administrateur principal de plateformes de données chez EDC, société d’État aidant les entreprises canadiennes à réussir à l’étranger. Conception, exploitation et gouvernance de plateformes de données infonuagiques.
Senior Data Platform Administrator shaping and operating EDC’s secure enterprise data platforms. Supporting Canadian businesses through Export Development Canada’s trade - finance solutions.
Staff full - stack engineer architecting GitLab’s data products, integrations, and knowledge graph. Building APIs, marketplace data access, and AI - powered developer intelligence.
Data Governance Architect shaping governance strategies and cloud data architectures for Lovelytics’ enterprise data and AI consulting clients. Leading technical delivery, presales, migrations, and governance implementations on Databricks.
Senior Data Engineer owning Databricks lakes, pipelines, and AI data infrastructure. Building Quandri’s AI operating system for insurance agencies and brokerages.
Senior Data Engineer architecting Azure and Databricks data platforms for TTEC Digital’s client experience solutions. Building governed pipelines, APIs, MCP integrations, and agentic AI data services.
Senior Data Engineer building Palantir Foundry data solutions for Unit8, a Swiss AI and data analytics consultancy. Supporting client delivery and establishing its Canadian market presence.
Staff Software Engineer building AWS data infrastructure and integrations for Solink’s cloud video - security platform. Driving scalability, architecture, and engineering mentorship.
Senior Azure Fabric Data Engineer building reliable pipelines and modern data platforms for Data Elephant, a Canadian data, analytics, and AI consultancy. Delivering trusted datasets for reporting, AI, and machine learning.
Senior Data Architect leading Microsoft Fabric implementations for Data Elephant, a Canadian data, analytics, and AI consulting firm. Designing secure Azure, OneLake, and Fabric platforms for clients.