Staff Business Intelligence/Analytics Engineer

Summary

Join ecobee, a rapidly growing global tech company, as a Staff BI/Analytics Engineer and contribute to building the world of tomorrow with solutions that improve everyday life while making a positive impact on the planet. You will be responsible for managing and optimizing the analytical infrastructure, focusing on data quality, efficient data modelling, and delivery of reliable analytics-ready data assets. You will leverage your expertise in data engineering, warehousing, and modelling to develop optimized data pipelines and deliver the silver and gold layers of the Lakehouse, ensuring seamless data flow and enhancing data accessibility, usability and exploration for analytics use cases. You will champion best practices and continuous improvement across BI processes, collaborating closely with business and cross-functional teams to define and enforce data standards and translate business needs into effective data solutions.

Requirements

• 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

Responsibilities

• 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

Preferred Qualifications

• Proficiency in Python (preferred) with experience scripting data workflows, automation, and quality checks
• Knowledge of data visualization tools

Benefits

• 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
• Our people are empowered to take ownership of their schedules with workflows that allow for flexible hours
• Based on your job, you have an option of a office-based, fully remote, or hybrid work environment
• New team members working remotely, will have all necessary equipment provided and shipped to them, and we conduct our interviews and onboarding sessions primarily through video