Staff BI/Analytics Engineer

ecobee; Toronto; Hybrid; CAD 110,000 - 130,000; Full time

Job summary

Join a forward-thinking tech company as a Staff BI/Analytics Engineer, where you will play a pivotal role in optimizing analytical infrastructure. This position offers the chance to design robust data models, collaborate with cross-functional teams, and ensure data quality while contributing to innovative solutions that impact everyday life. With a focus on sustainability and a commitment to making a difference, this role provides an exciting opportunity to be part of a dynamic team dedicated to enhancing home automation and energy efficiency. Embrace flexibility in your work environment and contribute to a culture that values diversity and inclusion.

Benefits

Competitive Salaries

Health Benefits

Professional Learning Budget

Parental Top-Up Program

Flexible Work Environment

Mentorship Program

Qualifications

• Experience designing scalable dimensional data models.
• Advanced SQL proficiency for complex queries.

Responsibilities

• Design scalable silver-layer models and gold-layer data marts.
• Implement data validation and pipeline monitoring.

Skills

SQL

Data Modeling

Data Quality

Python

Stakeholder Management

Problem-Solving

Education

Bachelor's Degree in Computer Science or related field

Tools

dbt

Cloud Warehouse

Data Visualization Tools

Job description

Join to apply for the Staff BI/Analytics Engineer role at ecobee

1 week ago Be among the first 25 applicants

Join to apply for the Staff BI/Analytics Engineer role at ecobee

Hi, we are ecobee.

ecobee introduced the world’s first smart Wi-Fi thermostat to help millions of consumers save money, conserve energy, and bring home automation into their lives. That was just the beginning. We continue our pursuit to create technology that brings peace of mind into the home and allows people to focus on the moments that matter most. We take pride in making a meaningful difference to the environment, all while being part of the exciting, connected home revolution.

Hi, we are ecobee.

ecobee introduced the world’s first smart Wi-Fi thermostat to help millions of consumers save money, conserve energy, and bring home automation into their lives. That was just the beginning. We continue our pursuit to create technology that brings peace of mind into the home and allows people to focus on the moments that matter most. We take pride in making a meaningful difference to the environment, all while being part of the exciting, connected home revolution.

In 2021, ecobee became a subsidiary of Generac Power Systems. Generac introduced the first affordable backup generator and later created the category of automatic home standby generator. The company is committed to sustainable, cleaner energy products poised to revolutionize the 21st century electrical grid. Together, we take pride in making a meaningful difference to the environment.

Why we love to do what we do:

We’re helping build the world of tomorrow with solutions that improve everyday life while making a positive impact on the planet. Our products and services work in harmony to provide comfort, efficiency, and peace of mind for millions of homes and businesses. While we’re proud of what we’ve done so far, there’s still a lot we can do—and you can be part of it.

Join our extraordinary team.

We're a rapidly growing global tech company headquartered in Canada, in the heart of downtown Toronto, with a satellite office in Leeds, UK (and remote ecopeeps in the US). We get to work with some of North America and UK's leading professionals. Our colleagues are proud to bring their authentic selves to work, confident that what we do is grounded in a greater purpose. We’re always looking for curious, talented, and passionate people to join our team.

Who You'll Be Joining

The business intelligence team, consisting of BI and data professionals, is responsible for managing and optimizing our analytical infrastructure. As a Staff BI/Analytics Engineer, you’ll operate at the intersection of data engineering and analytics, 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 our 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. Technically strong yet comfortable engaging with non-technical stakeholders, you'll collaborate closely with business and cross-functional teams to define and enforce data standards and translate business needs into effective data solutions.

How You’ll Make an Impact:

• 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
  
  

What You’llBring to the Table:

• 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
  
  

What happens after you apply:

Application review. It will happen. By an actual person in Talent Acquisition. We get upwards of 100+ applications for some roles, it can take a few days, but every applicant can expect a note regarding their application status.

Interview Process:

• 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: 45-minute video interview with the VP
  
  

With ecobee, you’ll have the opportunity to:

• 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 likeecobeeacts.
• 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.
  
  

Are you interested? Let's make it work.

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.

We’re committed to inclusion and accommodation.

ecobee believes that openness and diversity make us better. We welcome applicants from all backgrounds to apply regardless of race, gender, age, religion, identity, or any other aspect which makes them unique. Accommodations can be made upon request for candidates taking part in all aspects of the selection process. Our recruitment team is happy to answer any questions candidates may have about virtual interviewing, onboarding, and future work locations.

We’re up to incredible things. Come and be part of them.

Discover our products and services and learn more about who we are.

Ready to join ecobee? View current openings.

Please note,ecobeedoes not accept unsolicited resumes.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Computers and Electronics Manufacturing

Referrals increase your chances of interviewing at ecobee by 2x

Sign in to set job alerts for “Data Engineer” roles.

Richmond Hill, Ontario, Canada 6 days ago

Mississauga, Ontario, Canada CA$110,000.00-CA$130,000.00 15 hours ago

Software Engineer, Backend (All Levels / All Teams)

Software Engineer I, Entry Level (Fall 2024-Spring 2025) - Toronto

Toronto, Ontario, Canada CA$120,000.00-CA$190,000.00 1 month ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.