About this role
Senior Enterprise Data Warehouse Architect role at 3Pillar Global, responsible for end-to-end design and delivery of scalable analytics platforms across mixed on-prem and cloud environments. Requires deep expertise in dimensional modeling, ETL/ELT pipelines, and BI solutions with leadership accountability for performance and business impact.
Must have
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 from design through adoption
Expertise in cloud platforms such as AWS Glue and Amazon Redshift
Deep expertise in dimensional modeling including star schema and 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
Proven experience working with complex high-volume multi-source data environments
Prior experience implementing or integrating BI solutions ideally using Tableau
Proven leadership experience mentoring teams and engaging senior stakeholders
Technologies
Responsibilities
Architect and design end-to-end EDW and BI solutions
Design and implement scalable dimensional data models using star schemas and conformed dimensions
Own full lifecycle delivery from requirements through design build deploy adoption optimization and support
Ensure performance scalability and reliability across EDW and BI platforms
Drive cloud deployment and production readiness of analytics solutions
Take accountability for solution outcomes adoption and continuous improvement
Translate business requirements into scalable data analytics solutions
Design and oversee scalable data pipelines supporting enterprise analytics
Lead development of data transformation cleansing and enrichment processes
Implement data quality validation and monitoring frameworks
Integrate analytics data across high-volume multi-source environments including APIs relational systems SaaS flat files JSON and XML
Integrate and enhance large scale BI solutions both on prem and in the cloud
Facilitate architecture and technical design sessions
Act as 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
Define best practices for data modeling data engineering pipelines visualization standards and performance optimization
Deliver scalable reusable and enterprise-aligned solutions
Benefits
Recruitment process
3Pillar is an AI transformation partner helping enterprises build AI-native products and intelligent agents
Work with ambitious companies in financial services healthcare media and technology
HelixAI platform and Helix Pods delivery model put engineers at center of agentic transformation
Remote-first approach with flexibility to work where you perform best
Global community collaborating with talented colleagues across the globe
Culture built on connection support and shared success
Open communication with multiple feedback channels ensuring every employee can be heard
Gain exposure to diverse clients industries and challenges that accelerate learning and career growth
Core values include Collaboration Outperform Respect and Evolve
Similar offers
Freelance Data Scraping Engineer (Python)
76,960 – 76,960 USD
/ year
Senior Software Engineer
98,000 – 147,000 CAD
/ year
Senior Application Support Engineer (Remote Ontario)
85,000 – 110,000 CAD
/ year
Senior Engineer, eCommerce
161,640 – 169,995 USD
/ year
Azure DevOps & Infrastructure Lead
114,400 – 166,400 CAD
/ year