Job Title

About the Opportunity Were 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, PowerBi, 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 Handson 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 dont 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 fastpaced, 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 - $130,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 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. #J-18808-Ljbffr