Data Architect (EDW)
New
CanadaFull-TimeSenior
Salary140,000 - 160,000 USD per year
Apply NowOpens the employer's application page
Job Details
- Experience
- 15+ years
- Required Skills
- AWSSQLBusiness IntelligenceMicrosoft Power BIMicrosoft SQL ServerTableau
Requirements
- 15+ years of experience in data architecture, data engineering, or enterprise data platform roles.
- Proven track record of delivering enterprise EDW and BI solutions end-to-end in complex environments.
- Strong expertise in dimensional modeling, including star schema design and fact/dimension modeling principles.
- Hands-on experience with SQL and Microsoft SQL Server in large-scale data environments.
- Experience building and optimizing ETL/ELT pipelines using modern data integration tools.
- Strong knowledge of cloud data platforms, including AWS services such as Glue and Redshift (or equivalent Azure experience).
- Experience working with high-volume, multi-source data ecosystems (APIs, SaaS, relational, flat files, JSON/XML).
- Familiarity with BI tools such as Tableau or Power BI for enterprise analytics delivery.
- Proven leadership experience mentoring teams and influencing senior stakeholders in technical decision-making.
Responsibilities
- Architect and design end-to-end enterprise data warehouse (EDW) and BI solutions across hybrid cloud and on-prem environments.
- Own full lifecycle delivery including requirements gathering, design, development, deployment, adoption, and ongoing optimization.
- Design scalable dimensional data models such as star schemas, fact/dimension structures, and conformed dimensions.
- Build and oversee robust ETL/ELT pipelines, ensuring reliable data ingestion, transformation, and integration from multiple sources.
- Ensure high performance, scalability, security, and reliability across enterprise analytics platforms.
- Establish and enforce data governance, data quality, and architectural best practices across teams and systems.
- Lead stakeholder engagement sessions, providing technical direction and mentoring data engineering and BI teams.
View Full Description & ApplyYou'll be redirected to the employer's site
