Staff BI/Analytics Engineer

Summary

Join ecobee's business intelligence team as a Staff BI/Analytics Engineer and contribute to building the world of tomorrow. You will be responsible for managing and optimizing the analytical infrastructure, focusing on data quality, efficient data modeling, and delivering reliable analytics-ready data assets. Leverage your expertise in data engineering, warehousing, and modeling to develop optimized data pipelines and deliver the silver and gold layers of the Lakehouse. Collaborate with business and cross-functional teams to define and enforce data standards and translate business needs into effective data solutions. Champion best practices and continuous improvement across BI processes. This role offers the opportunity to make a sustainable impact and expand your career with professional development opportunities.

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

• Competitive salaries
• Health benefits
• Progressive Parental Top-Up Program (75% top-up or five bonus days off)
• Flexible hours
• Office-based, fully remote, or hybrid work environment