A remote role at 3Pillar.
How Sydicom helps: we read this listing’s requirements and tune your CV and cover letter to the keywords its ATS (Lever) is scanning for, for candidates in Canada, then help you apply.
Original listing text, shown exactly as published by the company.
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
•
•
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
•
•
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-source environments (APIs, relational systems, SaaS, flat files, 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, data engineers, and analysts
Governance & Best Practices
•
Establish and enforce data governance, data stewardship, security, and reporting standards
•
•
Data modeling
•
Data engineering pipelines
•
Visualization standards
•
Performance optimization
•
Deliver scalable, reusable, and enterprise-aligned solutions
•
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
•
•
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
3Pillar
Other
76 open roles on Sydicom
3Pillar Global is a digital product development company that partners with businesses to build innovative software solutions. They specialize in custom software development, product strategy, and user experience design to help clients accelerate their digital transformation.
Generated by Sydicom AI