---
title: 'Data Engineer (Snowflake | DBT) at OpenGov'
canonical: 'https://feeny.ai/job/data-engineer-snowflake-dbt-opengov-pune-p5q8k3x70kzc'
type: 'job'
last_seen: '2026-09-07'
---

# Data Engineer (Snowflake | DBT) at OpenGov

- **Company:** OpenGov
- **Location:** Pune, India
- **Employment:** full-time
- **Work type:** onsite
- **Posted:** 2026-09-03
- **Last confirmed live:** 2026-09-07
- **Apply:** https://jobs.ashbyhq.com/opengov/93d3ce22-3b33-4357-bdec-8c8412e5b42a/application

**Skills:** Snowflake, dbt, Airflow, SQL, Python, Dimensional modeling, Star schema, Slowly changing dimensions, Data modeling, Fivetran, Airbyte, AWS Glue, Salesforce, Workday, NetSuite, Tableau, Looker, Claude Code, Cursor, Copilot

> OpenGov seeks a Data Engineer to build scalable data products using Snowflake, dbt, and Airflow. The role involves translating business requirements into reliable data models, orchestrating pipelines, and ensuring data quality for analytics and AI use cases.

## Job description

OpenGov is the leader in AI and ERP solutions for local and state governments in the U.S. More than 2,000 cities, counties, state agencies, school districts, and special districts rely on the OpenGov Public Service Platform to operate efficiently, adapt to change, and strengthen the public trust. Category-leading products include enterprise asset management, procurement and contract management, accounting and budgeting, billing and revenue management, permitting and licensing, and transparency and open data. These solutions come together in the OpenGov ERP, allowing public sector organizations to focus on priorities and deliver maximum ROI with every dollar and decision in sync. Learn about OpenGov’s mission to power more effective and accountable government and the vision of high-performance government for every community at OpenGov.com http://OpenGov.com.

## ABOUT THE ROLE

OpenGov is looking for a skilled and solution-oriented Data Engineer to join our growing Data team. In this role, you will be the bridge between business stakeholders and data solutions—translating complex analytical and AI use case requirements into reliable, scalable data products. You will work hands-on with Snowflake, dbt, and Airflow to model, transform, and orchestrate data that powers decision-making across the organization. You think in terms of data models, business domains, and consumption patterns. You partner closely with analytics, product, and engineering teams to understand their needs and deliver data solutions that are well-structured, well-documented, and production-ready.

## WHAT YOU’LL OWN

- Stakeholder Engagement & Requirement Gathering: Partner with business stakeholders across Analytics, Operations, GTM, and G&A to understand problem statements and translate them into clear data requirements..
- Data Modeling & Transformation: Design and build dimensional and analytical data models in Snowflake using dbt (Cloud/Core) that serve as the single source of truth for business domains. Develop, test, and maintain dbt models following best practices—including modular layering (staging, intermediate, marts), documentation, and data tests. Optimize SQL queries and dbt models for performance, leveraging Snowflake features such as clustering, materialization strategies, and query profiling.
- Data pipeline Orchestration: Build and manage Airflow DAGs to orchestrate multi-step data pipelines, ensuring reliability, observability, and SLA adherence. Own end-to-end delivery of data products—from raw source data ingestion through transformation to governed, consumption-ready datasets. Collaborate with the Data Platform team on pipeline integration, CI/CD workflows, and adherence to shared coding and deployment standards.
- Data Quality & Analysis: Implement data quality checks and freshness tests within dbt to proactively catch issues before they reach consumers. Perform exploratory data analysis to validate source data, understand distributions, and surface data anomalies during scoping and build phases. Work with stakeholders to define and monitor data SLAs, ensuring data products are trustworthy and consistently delivered.

## WHAT YOU BRING

- 4–6 years of experience in data engineering, analytics engineering, or a similar related role.
- Snowflake & DBT Proficiency: Hands-on experience building and maintaining dbt projects in Snowflake—you understand model layering, ref() dependencies, materialization strategies, and how to write performant SQL.
- Airflow Expertise: Proven ability to author and manage production Airflow DAGs for orchestrating complex, multi-step data workflows.
- Data Modeling Skills: Solid understanding of dimensional modeling concepts (star schema, slowly changing dimensions) and the ability to design models that balance clarity, performance, and flexibility.
- SQL Mastery: Advanced SQL skills with the ability to write complex transformations, window functions, and optimization techniques in Snowflake.
- Python: Proficiency in Python for data manipulation, pipeline scripting, and automation.
- Business Acumen: You can sit in a discovery session with a business stakeholder, understand their analytical problem, and translate it into a well-structured data model.
- Data Analysis: Comfort exploring raw data, identifying quality issues, and communicating findings clearly to stakeholders.
- Software Engineering Practices: You treat data code like software—version-controlled, peer-reviewed, tested, and documented.
- Strong communication and collaboration skills, with the ability to work across technical and non-technical audiences.
- Bachelor's degree in Computer Science, Engineering, Statistics, or a related field.

## NICE TO HAVE

- Familiarity with dbt Mesh concepts (cross-project references, data contracts) or multi-project dbt architectures.
- Exposure to data ingestion tools such as Fivetran, Airbyte, or AWS Glue for loading source data into Snowflake.
- Experience working with business application data (e.g., Salesforce, Workday, NetSuite) and understanding its quirks.
- Familiarity with BI tooling (e.g., Tableau, Looker) and how data models serve visualization layers.
- Experience using AI-assisted development tools (e.g., Claude Code, Cursor, Copilot) to accelerate engineering workflows.
- Exposure to data cataloging or discovery tools (e.g., DataHub) for improving data discoverability.

WHY OPENGOV?

A Mission That Matters.

At OpenGov, public service is personal. We are passionate about our mission to power more effective and accountable government. Government that operates efficiently, adapts to change, and strengthens public trust.  Some people say this is boring.  We think it’s the core of our democracy.

Opportunity to Innovate

The next great wave of innovation is unfolding with AI, and it will impact everything—from the way we work to the way governments interact with their residents. Join a trusted team with the passion, technology, and expertise to drive innovation and bring AI to local government. We’ve touched 2,000 communities so far, and we’re just getting started.

A Team of Passionate, Driven People

This isn’t your typical 9-to-5 job; we operate in a fast-paced, results-driven environment where impact matters more than simply clocking in and out. Our global team of 800+ employees is united in our commitment to challenge the status quo. OpenGov is headquartered in San Francisco and has offices in Atlanta, Boston, Chicago, Dubuque, Dallas, and Pune.

A Place to Make Your Mark

We pride ourselves on our performance-based culture, where every employee is encouraged to jump in head-first and take action to help us improve. If you have a great idea, we want to hear it. Excellent performance is recognized and rewarded, and we love to promote from within.

## Benefits That Work for You

Enjoy an award-winning workplace with the benefits to match, including:

- Comprehensive healthcare options for individuals and families
- Flexible vacation policy and paid company holidays
- 401(k) with company match
- Paid parental leave, wellness stipends, and HSA contributions
- Professional development and growth opportunities
- A collaborative office environment with weekly catered lunches.

## About OpenGov

## Company Overview
- **One-liner**: OpenGov provides a cloud-based platform of AI-enabled software solutions designed to modernize and streamline operations for local and state governments across the United States.
- **Entity Type**: Private (acquired by Cox Enterprises in February 2024; previously venture-backed with $178M in total funding)
- **Headquarters**: San Francisco, California, United States (additional hubs in Boston, Chicago, Dallas, Atlanta, Dubuque, and Pune, India)
- **Founded**: 2012
- **Founders**: Nate Levine, Dakin Sloss, Joe Lonsdale, Zachary Bookman (Zac Bookman)

## Core Business
- **Primary industry**: Government Technology (GovTech) – cloud software for public sector
- **Target customers**: B2G – cities, counties, state agencies across the U.S.
- **Mission**: “To power more effective and accountable government” [opengov.com/about/](https://opengov.com/about/)

## Products & Services
For each major offering:
- **OpenGov Permitting & Licensing**: AI-enabled platform for permits, licenses, inspections, and code enforcement – automates workflows, renewals, and applicant portals.
- **OpenGov Enterprise Asset Management**: Tracks infrastructure assets (roads, bridges, water mains, parks) with work order management, lifecycle tracking, GIS integration, and reporting.
- **OpenGov Financial Management**: Modern ERP cloud suite including general ledger, accounts payable, budgeting, procurement, and reporting – replaces legacy systems.
- **OpenGov Budgeting & Performance**: Tools for operational, capital, and workforce budgeting with transparency dashboards and ERP integration.
- **OpenGov Tax & Revenue Collection**: Centralizes tax billing, filing, and payments for business and property taxes.
- **OpenGov Procurement & Contract Management**: Workflow automation for the entire procurement lifecycle, from requests to contracts, with AI and compliance controls.
- **OpenGov Public Service Platform**: Unified platform integrating all modules, powered by AI, open APIs, and real-time analytics. [opengov.com/](https://opengov.com/)

## Market Standing
- **Valuation/Market Cap**: $1.8 billion (acquisition price paid by Cox Enterprises in February 2024) [linkedin.com/company/opengov-inc](https://www.linkedin.com/company/opengov-inc)
- **Key Metric**: Total funding raised prior to acquisition: $178 million across multiple rounds (Series B, D, etc.)
- **Notable Investors/Partners**: Andreessen Horowitz, 8VC, Weatherford Capital, Formation 8, Thrive Capital; early supporters include Marc Andreessen, John Chambers, Laurene Powell Jobs, Scott Cook. Parent company: Cox Enterprises.
- **Growth Signals**: Serves 2,000+ communities; 4,500+ software implementations; 1 in 3 Americans receive digital services via OpenGov; 845 employees (+17.3% year-over-year growth); expanded to 9 countries (India, Argentina, Ukraine, Hungary, Poland, etc.) [linkedin.com/company/opengov-inc](https://www.linkedin.com/company/opengov-inc) [opengov.com/about/](https://opengov.com/about/)

## Competitive Advantages
- **Purpose-built for government**: Every product is designed specifically for local and state government workflows, not adapted from enterprise software.
- **AI-enabled automation**: Embedded AI and automation reduce manual work, delays, and errors across permitting, procurement, and financial management.
- **Integrated platform**: Single, secure platform with open APIs and robust integrations, replacing siloed legacy systems.
- **Deep domain expertise**: Professional services team includes former public servants who understand government operations and best practices.
- **Scale and trust**: Over 2,000 communities served and a proven track record of 4,500+ implementations. [opengov.com/](https://opengov.com/)

## Strategic Focus
- **Current priorities**: Continue modernizing government operations through AI and automation; expand the number of communities served (targeting every U.S. community); deepen integration with existing ERP systems and third-party tools.
- **Direction for growth**: Leverage the partnership with Cox Enterprises to scale faster, invest in product innovation, and broaden the platform’s capabilities to cover more government functions. [opengov.com/about/](https://opengov.com/about/)

## Why Work Here
- **Culture highlights**: Mission-driven environment focused on public impact. Core values include “We Do What We Say We’ll Do”, “We Go the Extra Mile”, “We Care, A Lot”, “We Challenge the Status Quo”, and “Win As One”. Team celebrates wins with Gong ringing, ping pong nights, and sports events.
- **Remote/hybrid/office policy**: Strong in-office culture – “Work from Work is a Perk” and hubs foster face-to-face collaboration. Offices in San Francisco (dog-friendly), Boston, Chicago, Dallas, Atlanta, Dubuque, and Pune.
- **Notable perks**: Dog-friendly SF office, collaborative workspaces, team outings, and a focus on learning and growth. Engineering roles emphasize innovation and autonomy.
- **Impact**: Employees directly contribute to making government more efficient and accountable, touching the lives of millions of Americans. [opengov.com/careers/](https://opengov.com/careers/)

## Sources
1. [OpenGov Careers Page](https://opengov.com/careers/)
2. [OpenGov About Page](https://opengov.com/about/)
3. [OpenGov Main Website](https://opengov.com/)
4. [OpenGov LinkedIn Profile](https://www.linkedin.com/company/opengov-inc)
5. [OpenGov Jobs on Ashby](https://jobs.ashbyhq.com/opengov)

## Other roles at OpenGov

- [Account Executive, SMG](https://feeny.ai/job/account-executive-smg-opengov-boston-0qsctnvt7c8z) — Boston, MA
- [Account Executive, SMG](https://feeny.ai/job/account-executive-smg-opengov-chicago-3sa5x0fdsht8) — Chicago, IL
- [Account Executive II](https://feeny.ai/job/account-executive-ii-opengov-boston-9pt1343cbk5r) — Boston, MA
- [Accountant II](https://feeny.ai/job/accountant-ii-opengov-pune-jr3f8tzt5wqw) — Pune, India
- [Sr Software Engineer (Full Stack)](https://feeny.ai/job/sr-software-engineer-full-stack-opengov-boston-zgdsfsmrnzws) — Boston, MA
- [SDR](https://feeny.ai/job/sdr-opengov-pune-2z0vqesqg1yf) — Pune, India
- [Manager, SDR - Pune](https://feeny.ai/job/manager-sdr-pune-opengov-pune-2rh5zja0vf0b) — Pune, India
- [Software Engineer III](https://feeny.ai/job/software-engineer-iii-opengov-pune-gjgwxw0evcqa) — Pune, India
- [ERP Solutions Engineer I](https://feeny.ai/job/erp-solutions-engineer-i-opengov-dallas-a4vy18nz30bn) — Dallas, TX
- [Senior Accountant](https://feeny.ai/job/senior-accountant-opengov-chicago-mx1kvang08cs) — Chicago, IL