
Staff BI/Analytics Engineer
- Toronto, ON
- Permanent
- Full-time
- Design scalable, robust and reusable silver-layer models, standardized dimensional schemas, and curated gold-layer data marts, providing an enterprise-wide single source for consistent metrics, reliable analysis, and unified data usage.
- Develop semantic layers and data catalogs that enable flexible dashboarding, independent data exploration, and intuitive self-service analytics for business stakeholders
- Implement rigorous data validation, pipeline monitoring, data documentation, and lineage tracking, stewarding company-wide data quality, consistency and trust
- Collaborate closely with engineering, domain experts, and cross-functional teams to define clear data requirements, establish data contracts, proactively manage schema changes, and ensure reliable data for downstream analytics
- Drive critical data initiatives, provide mentorship, champion best practices, and actively contribute to advancing the organization's analytical capabilities and data maturity
- Hands-on experience with designing scalable dimensional data models and managing multi-layer data architectures (Silver/Gold layers)
- Advanced SQL Proficiency: Ability to write, optimize, and troubleshoot complex queries on large, disparate datasets, demonstrating both accuracy and efficiency
- Hands-On dbt & Cloud Warehouse Experience
- Proven experience applying data quality, governance standards, lineage tracking, and security best practices.
- Demonstrated capability to lead technical discussions, uphold best practices, and translate business requirements into clear technical deliverables.
- Strong stakeholder management and communication skills to effectively engage with cross-functional teams of varying technical expertise
- Excellent problem-solving skills, with the ability to systematically analyze, hypothesize, and implement innovative solutions
- Proficiency in Python (preferred) with experience scripting data workflows, automation, and quality checks
- Knowledge of data visualization tools
- Round 1: 30-minute phone call with a member in Talent Acquisition
- Round 2: 60-minute video interview with the Hiring Manager covering technical, behavioral, and situational questions to evaluate your qualifications and fit for the role
- Round 3: 60-minute video interview with team members to delve into your technical expertise and experience
- Final Interview: 60-minute video interview with Leadership
- Be part of something big: Get to work in a fresh, dynamic, and ever-growing industry.
- Make a difference for the environment: Make a sustainable impact while on your daily job, and after it through programs like ecobee acts.
- Expand your career: Learn with our in-house learning enablement team, and enjoy our generous professional learning budget.
- Put people first: Benefit from competitive salaries, health benefits, and a progressive Parental Top-Up Program (75% top-up or five bonus days off).
- Play a part on an exceptional culture: Enjoy a fun and casual workplace with an open concept office, located at Queens Quay W & York St. ecobee Leeds is based at our riverside office on the Calls.
- Celebrate diversity: Be part of a truly welcoming workplace. We offer a mentorship program and bias training.