BI Developer

Summary

Join ecobee's business intelligence team as a BI Developer. You will design and deliver reports, dashboards, and self-service interfaces to enhance data accessibility and usability. Leveraging your BI tool and data warehousing expertise, you will develop analytical solutions supporting data-driven decision-making. Collaboration with business users, data engineers, and cross-functional teams is crucial. You will contribute to data warehouse architecture, ensuring a strong foundation for BI solutions. This role requires hands-on experience with front-end BI tools and data warehouse technologies, strong communication skills, and the ability to handle large, complex datasets. Ecobee offers a dynamic work environment, flexible hours, and various benefits.

Requirements

• Hands-on experience developing and managing front-end BI tools such as SiSense, Looker and Sigma
• A solid understanding of data warehouse principles and methodologies (e.g., Kimball, Inmon)
• Hands-on experience with datawarehouse technologies, preferably cloud-based platforms such as Google BigQuery and Snowflake
• Strong communication and stakeholder management skills to engage effectively with diverse teams across the organization
• Ability to simplify complex data and present them as clear and actionable insight for a broad range of audiences
• Ability to handle large, complex datasets and develop scalable reporting solutions
• Proactive problem-solving, consistently seeking opportunities for innovation and efficiency to drive meaningful improvements
• Energized by working in a small team with the ability to make an immediate impact on the business
• Experience in an Agile environment, skilled in developing stories, prioritizing tasks, refining backlog

Responsibilities

• Design and develop data marts, views, and BI semantic layers to support governed reporting and self-service data discovery and analytics
• Create dashboards and reports that go beyond basic requirements, addressing core business needs and driving decision-making
• Contribute to data warehouse architecture using industry best practices ensuring a strong foundation for BI solutions
• Engage with business stakeholders to understand the root business needs for new reporting and analytics use cases and deliver actionable solutions
• Collaborate with data engineers to ensure the availability of reliable and well-structured data for analytics and reporting
• Support the administration of BI platforms, ensuring they are secure, up-to-date, and accessible to users

Preferred Qualifications

Familiarity with ETL/ELT tools like Matillion and dbt; basic coding ability in Python or Java is considered an asset

Benefits

• Competitive salaries
• Health benefits
• Progressive Parental Top-Up Program (75% top-up or five bonus days off)
• Flexible hours
• Option of a office-based, fully remote, or hybrid work environment
• In-house learning enablement team
• Generous professional learning budget