CanadaData Architect (EDW)
3 мес. назад
CanadaWorldwideSeniorRemote
data warehousingbusiness intelligencecloud environments
Senior Data Architect role focused on enterprise data warehouse and business intelligence solutions delivery.
О компании
- 3Pillar is an AI transformation partner on a mission to help enterprises build the AI-native products and intelligent agents that will define the next era of business. With teams across North America, Europe, Latin America, and Asia, we work with the most ambitious companies in financial services, healthcare, media, and technology — helping them move faster, modernize boldly, and compete on their own terms. Our HelixAI platform and Helix Pods delivery model put our engineers at the center of real agentic transformation — doing work that is open, portable, and built to last. We are building the future of enterprise AI. 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 ge
Обязанности
- Architect & Design end-to-end EDW and BI solutions
- Design and implement scalable dimensional data models (star schemas, fact/dimension design, conformed dimensions)
- 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
- 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-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
- 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
- Define best practices across:
- 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
- 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
Другое
- What It's Like to Work at 3Pillar: At 3Pillar, we create an environment where people can do their best work while maintaining a healthy work-life balance. Flexibility & Well-being – Our remote-first approach gives you the flexibility to work where you perform best, while prioritizing your well-being and personal commitments. Global Community – Collaborate with talented colleagues across the globe in a culture built on connection, support, and shared success. Your Voice Matters – We foster open communication and multiple feedback channels, ensuring every employee has the opportunity to be heard and make an impact. Growth & Development – Gain exposure to diverse clients, industries, and challenges that accelerate learning and career growth. Our culture is guided by four core values: