3Pillar Global

Product Development

DataArchitect(EDW)

CA$140–160k Canada FULL TIME
Market Sentiment
HIGH DEMAND

Neural analysis suggests this role is
optimal for Senior candidates.

The Brief

“Data Architect (EDW) at 3Pillar Global. Skills: Enterprise Data Warehouse (EDW) Architecture, Business Intelligence (BI) Solutions, Cloud Data Platforms (AWS, Azure), Dimensional Data Modeling, ETL/ELT Pipeline Development, End-to-End Data Solution Delivery. Architecture & Solution Design. Architecture & Design end-to-end EDW and BI solutions”

What You'll Achieve.

Accountable for performance, scalability, and business impact; Deliver scalable, high-performance analytics platforms; Accountability for solution outcomes, adoption, and continuous improvement; Deliver scalable, reusable, and enterprise-aligned solutions

Industry & Context.

Product Development
Problems you'll solve

Translate business requirements into scalable data analytics solutions

What They're Looking For.

Must Have

15+ years in data architecture, or data engineering roles, Proven experience owning and delivering enterprise EDWI 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), 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, Experience deploying solutions in cloud environments, Proven leadership experience mentoring teams and engaging senior stakeholders

Nice to Have

AWS, Azure, Tableau, PowerBI, Salesforce data integration into EDW/BI ecosystems, FinTech verticals experience, Building operational BI solutions experience, Application development experience using either Java or .Net, C#, Python

What You'll Do.

Architecture & Solution Design

Architecture & Design end-to-end EDW and BI solutions

Design and implement scalable dimensional data models (star schemas

fact/dimension design

conformed dimensions)

End-to-End Delivery Ownership

Own full lifecycle delivery: requirements → design → build → deploy → adoption → optimization & support

and reliability across EDW and BI platforms

Drive cloud deployment and production readiness of analytics solutions

Take accountability for solution outcomes

and continuous improvement

Data Engineering & Integration

Translate business requirements into scalable data analytics solutions

Design and oversee scalable data pipelines (ETL/ELT) supporting enterprise analytics

Lead development of data transformation

and enrichment processes

Implement data quality

and monitoring frameworks

Integrate analytics data ingested across high-volume

multi-source environments (APIs

JSON/XML) and make it available for various data consumers

Integrate and enhance large scale BI solutions both on prem and in the cloud

Leadership & Stakeholder Engagement

Facilitate architecture and technical design sessions

Act as a trusted advisor bridging business strategy and technical delivery

Lead and mentor BI developers

Governance & Best Practices

Establish and enforce data governance

and reporting standards

Define best practices across: Data modeling

Data engineering pipelines

Visualization standards

Performance optimization

and enterprise-aligned solutions

How You'll Work.

Team & Collaboration

Partnering with senior stakeholders; Leading delivery teams; Leading and mentoring BI developers, data engineers, and analysts; Facilitating architecture and technical design sessions; Bridging business strategy and technical delivery

Communication Scope

Engaging senior stakeholders

Process & Methodology

Full lifecycle delivery ownership (requirements → design → build → deploy → adoption → optimization & support)

Full Job Description

## Description Senior Data Archtect (EDW) Accomplished Tech Visionary:  Embark on an exciting journey with 3Pillar! We extend an invitation for you to join our team and gear up for a thrilling adventure.   We are seeking a Senior Enterprise Data Warehouse (EDW) / Architect with a proven record of owning and delivering enterprise-scale data and analytics solutions on mixed prem and cloud environments. This is a hands-on architecture and delivery role requiring deep expertise across data warehousing, and business intelligence domains with clear evidence of end-to-end ownership from design through production and adoption. The successful candidate for this role is someone who has prior proven experience delivering Enterprise Data Warehouse (EDW) and Business Intelligence (BI) solutions end-to-end and is accountable for performance, scalability, and business impact. You will lead the design and delivery of scalable, high-performance analytics platforms, while partnering with senior stakeholders and leading delivery teams.   ## Responsibilities Architecture & Solution Design Architect & Design end-to-end EDW and BI solutions Design and implement scalable dimensional data models (star schemas, fact/dimension design, conformed dimensions) End-to-End Delivery Ownership 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 Take accountability for solution outcomes, adoption, and continuous improvement Data Engineering & Integration Translate business requirements into scalable data analytics solutions Design and oversee scalable data pipelines (ETL/ELT) supporting enterprise analytics Lead development of data transformation, cleansing, and enrichment processes Implement data quality, validation, and monitoring frameworks Integrate analytics data ingested across high-volume, multi-s

Free ATS check

Applying for this Data Architect (EDW) role?

Most applicants get filtered before a human reads their resume. See if yours makes the cut.

How to Apply on Lever

  • Lever uses a streamlined one-page form — apply in under 5 minutes.
  • LinkedIn import works well; review parsed data before submitting.
  • The cover letter field is optional but visible to reviewers — use it to differentiate.
  • Referral codes from employees can significantly boost visibility of your application.

ANONYMOUS · UNFILTERED

What do employees actually say about 3Pillar Global?

Real rants from real employees. Read before you apply.

Read Company Rants →