Data Architect (EDW) in Canada Creek, Nova Scotia at 3Pillar Global

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.

• Architect & Design end-to-end EDW and BI solutions

• Design and implement scalable dimensional data models (star schemas, fact/dimension design, conformed dimensions)

• 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

• Experience using SSIS, DataStage, Informatica, etc

• Tableau or PowerBI experience

• Experience integrating Salesforce data into EDW/ BI ecosystems

• Prior experience working in FinTech verticals

• Prior experience building operational BI solutions

• Prior application development experience ideally using either Java or .Net C#, Python

• At 3Pillar Global, we are the power behind the brands you know. We are hiring new team members to assist us in continuing our growth trajectory as a fast growing global team of thousands of professionals. New Leaders will live our shared values of Intrinsic Dignity, Open Collaboration, Outsized Impact, and Continuous Improvement everyday to harness The Power of Team and deliver exceptional products and services for our clients.
• We support the comprehensive wellbeing of our team members, through:
• Career growth and development
• Physical and mental wellbeing: as a company, we spend a whole trimester in our annual cycle focused on wellbeing. Whether it is taking advantage of fitness offerings, mental health plans (country-dependent), or simply leveraging unlimited PTO to take some needed time off, we want all of our team members operating at their best.
• Living our value for Intrinsic Dignity as an equal opportunity employer and,
• Providing a comprehensive US benefits package that includes:
• 100% 3Pillar funded medical and dental coverage for employees and their dependents
• Unlimited PTO
• Company paid disability and life insurance, and
• Generous Parental Leave