Senior BI Developer

About ClearGov

Our mission is to create easy-to-use software to help local governments plan, budget and report better. ClearGov is a rapidly growing SaaS company that offers a complete planning, budgeting and financial reporting suite that enables local governments to plan, build, and present their financials more efficiently and effectively. We’re a mission-driven company that envisions a world where modern software enables every local government to best serve and improve its community.

Our software is utilized nationwide by more than 1,700 towns, cities, school districts, and other local agencies who are part of the ClearGov community, and we’re adding more every day. We’ve been named to the “GovTech 100” for eight years running. ClearGov also earned a place on the Inc. 5000 list of America’s Fastest Growing Companies for five consecutive years: 2021, 2022, 2023, 2024, and 2025.

The ClearGov team is a talented group of folks who are passionate about our mission and committed to building a positive, productive company culture. We believe in a work-hard/play-hard environment, and every day, we strive to get better at our work, all while being considerate, trustworthy, and transparent in everything we do.

Core Values

• Be Clear: We strive to be open in all that we do because we believe that transparency is the foundation upon which all meaningful relationships are built.
• Be Trustworthy: We always act with integrity and keep our word because we believe that honest people are authentic, consistent, and dependable and that those traits form the cornerstone for success and well-being.
• Be Considerate: We are mindful about the impact that our comments and actions will have on others because we want to build a compassionate, inclusive environment that nurtures all individuals and communities.
• Be Positive: We believe that the first step in getting something done is believing that it can be done because we know that positive energy brings enthusiasm, excitement, and empowerment to the team.
• Be Better: We constantly ask ourselves, "How can we do this better?" because we know that our families, colleagues, investors, and customers depend on the results we deliver every day.
• Be Fierce: We seek to have bold conversations that interrogate reality and provoke learning to help us tackle our toughest challenges and enrich relationships.
• Be Fun: We value the lighter side of life because we believe that balance, laughter, and enjoying every moment fuel the soul.
  
   

About the Opportunity

We’re looking for a Senior BI Developer with a passion for learning, a kind heart, a positive attitude, and a great sense of humor to join our growing team. The Senior BI Developer will be responsible for developing customized business intelligence reporting for CitySpan customers.

The Senior BI Developer will be a key player on an incredible team as we execute our mission to help local governments and school districts take the next step from good to great.

Key Responsibilities:

• Architect and develop sophisticated custom reporting solutions within a modern BI stack, leveraging JIRA and Confluence for streamlined project tracking
• Manage complex data models and schemas within a medallion architecture, ensuring high-quality data governance and technical documentation
• Design and implement robust ETL / ELT data pipelines to support large-scale integration projects, such as the SF Department of Early Childhood implementation
• Collaborate directly with key stakeholders at high-impact nonprofits like After School Matters to define requirements and deliver actionable insights

Critical Skills/Experience:

• 5+ years of mastery in SQL scripting and database optimization
• 2+ years of experience with enterprise report builders (Looker, Power Bi, SAP Business Objects) and GitHub-based version control workflows
• 2+ years of Python expertise for advanced data manipulation and automation
• Proven ability to thrive in an Agile/SDLC environment using JIRA for capacity management and ticket lifecycle

  The Ideal ClearGov Candidate:

• Self-motivated, self-starter with a zeal to win 
• Great communicator; strong oral and written skills 
• Ability to think creatively and innovatively 
• Hands-on problem solver who enjoys cracking difficult nuts 
• Quick study – able to pick up and apply new concepts in a hurry 
• Track record of achievement 
• Enjoys working on and helping to build outstanding teams 
• Demonstrates an entrepreneurial spirit and gets stuff done 
• A sense of humor and don’t take themselves too seriously 

Why Join Us:

• Flexible, hybrid work
• Chance to make a meaningful impact on government and school district transparency and accountability
• Opportunity to work in a fast-paced, fun, and collaborative environment
• Competitive salary and benefits package (see below)
• Professional growth opportunities

Compensation:

• In the spirit of transparency, we are excited to share the base salary for this position is $100,000 - $120,000 CAD and exclusive of fringe benefits or potential bonuses. If you are hired at ClearGov, your final base salary compensation will be determined by factors such as skills, interview performance, education and/or experience. In addition to those factors, we believe in the importance of pay equity and consider internal equity of our current team members as a part of any final offer. Please keep in mind that the range mentioned above is the full base salary for the role. Hiring beyond the base range would not be typical in order to allow for future & continued salary growth. We also offer a generous compensation and benefits package (more information on benefits listed below).

Benefits:

• Competitive Salary
• Quality Medical, Dental, and Vision Insurance Plans 
• Life Insurance 
• RRSP Matching
• Personal Time Off Policy
• Company-Paid Holidays Observed
• Annual Holiday “Dimming of the Lights” (aka: reduced work hours)
• Parental Leave
• Employee Referral Bonus

#LI-ER1

 

ClearGov is an equal opportunity employer committed to building a diverse, inclusive, and respectful workplace. We prohibit discrimination and harassment of any kind and make employment decisions without regard to race, color, ancestry, ethnicity, nationality or national origin, citizenship, sex, sexual orientation, gender identity or expression, religion or creed, age, disability, genetic information, pregnancy, childbirth or related medical conditions, marital or family status, veteran or military status, Indigenous status, record of offenses (where legally protected), or any other characteristic protected by applicable federal, state, provincial, or local laws in the United States and Canada.

ClearGov is also committed to providing reasonable accommodations for applicants and employees with disabilities, in accordance with applicable U.S. and Canadian laws. If you require an accommodation during any part of the hiring process, please let us know.

At ClearGov, we value diverse perspectives and believe they strengthen our ability to achieve our mission of helping local governments work better.