Senior BI Developer (SaaS)

TL;DR

Senior BI Developer (SaaS): Developing customized business intelligence reporting for local government customers with an accent on sophisticated custom reporting solutions and high-quality data governance. Focus on architecting robust ETL/ELT data pipelines and managing complex data models within a medallion architecture.

Location: Flexible, hybrid work

Salary: $100,000 - $130,000 CAD

Company

A rapidly growing SaaS company that provides a complete planning, budgeting, and financial reporting suite for local governments.

What you will do

• Architect and develop sophisticated custom reporting solutions within a modern BI stack.
• Manage complex data models and schemas within a medallion architecture to ensure data governance.
• Design and implement robust ETL/ELT data pipelines for large-scale integration projects.
• Collaborate with key stakeholders at nonprofits and government agencies to define requirements and deliver actionable insights.
• Utilize JIRA and Confluence for streamlined project tracking and capacity management.

Requirements

• 5+ years of mastery in SQL scripting and database optimization.
• 2+ years of experience with enterprise report builders such as Looker, Power BI, or SAP Business Objects.
• 2+ years of Python expertise for advanced data manipulation and automation.
• Experience with GitHub-based version control workflows.
• Proven ability to thrive in an Agile/SDLC environment.

Culture & Benefits

• Quality Medical, Dental, and Vision Insurance Plans.
• RRSP Matching and Life Insurance.
• Flexible, hybrid work environment.
• Personal Time Off policy and company-paid holidays.
• Annual "Dimming of the Lights" (reduced work hours).
• Parental leave and employee referral bonuses.