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
Senior Data Architect modernizing Alberta justice data marts into an integrated enterprise data warehouse. Designing ETL, Power BI testing, data models, governance, and reporting architecture.
Senior Data Architect integrating Alberta court data marts into an enterprise data warehouse. Designing ETL, data models, governance practices, and Power BI validation reports.
Data & Analytics Engineer building scalable data platforms for Ledgebrook, an insurance company. Designing pipelines, governance, and cloud data systems while partnering with technical and insurance teams.
Data Engineer building scalable pipelines for SumerSports’ football intelligence platform. Supporting deep learning, video, LLM, analytics, and AI - driven products across sports.
Data Platform Engineer building ingestion pipelines, storage, governance, and observability systems for Movable Ink’s AI - driven marketing personalization platform. Supporting scalable, secure, multi - tenant data services.
Senior Data Engineer building AWS ETL/ELT pipelines and dbt models for Tango’s cloud real - estate and facilities SaaS. Managing databases, data quality, warehousing, and observability.
Senior Data Engineer building AWS and dbt data pipelines for Tango’s cloud real - estate and facilities SaaS platform. Managing databases, warehouses, data quality, and analytics - ready datasets.
Data Engineer building streaming pipelines and analytical databases for Movable Ink’s data - activated marketing personalization platform. Developing Elixir/Python services and reliable event - data products at billions - event scale.
Senior Data Engineer needed for a 1 - year contract with an asset management client in Toronto. Requires 7+ years of experience, Snowflake, Python, SQL, and cloud platform expertise.