Data Warehouse 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. Were 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 1700 towns cities school districts and other local agencies who are part of the ClearGov community and were adding more every day. Weve been named to the GovTech 100 for eight years running. ClearGov also earned a place on the Inc. 5000 list of Americas Fastest Growing Companies for five consecutive years: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
Were looking for a Data Warehouse Developer with a passion for learning a kind heart a positive attitude and a great sense of humor to join our growing team. We are looking for a Data Warehouse Developer with a strong knowledge of Go-To-Market operations to join our data team. You wont just be moving data; youll be the architect responsible for transforming raw signals from our sales success and product tools into a unified source of truth. The ideal candidate understands that data is only as good as its reliability. You should be equally comfortable writing complex SQL window functions orchestrating Python pipelines and discussing data governance frameworks.

The Data Warehouse 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:

• ETL/ELT Architecture: Design and maintain robust data pipelines using the Medallion Architecture (Bronze/Silver/Gold) to ensure data lineage and scalability.
• GTM Integration: Ingest and model data from our core tech stack including Salesforce Zendesk Pendo ChurnZero and Gong.
• Data Modeling: Transform disparate data sources into a high-performance Fact/Dimension (Star Schema) architecture.
• Quality & Governance: Implement automated data quality rules and validation checks to ensure accuracy. Define and enforce data governance standards across the warehouse.
• Observability: Build and manage alerting and monitoring systems to proactively identify pipeline failures or data drift before they impact the business.
• Analytics Delivery: While primarily backend-focused you will occasionally build stakeholder-facing dashboards and self-serve layers to visualize GTM KPIs.
• The Data Detective: You dont just report a bug; you find the root cause in the source system and fix the logic.
• Translator: You can bridge the gap between technical infrastructure and business requirements from Sales and Marketing leaders.
• Ownership: You take pride in clean code and even cleaner data.

Critical Skills/Experience:

• 5 years of Experience with modern data stack tools (e.g. Databricks dbt Airflow Fivetran/Airbyte).
• Knowledge of Gong conversation intelligence data and how to link it to CRM outcomes.
• Understanding of SaaS metrics (CAC LTV Net Retention Churn).

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 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 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 $100000 - $120000 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 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.