Base Career helps you apply smarter for this job.
Key skills for this 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.
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.
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.
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
San Francisco, USA
Atlanta, USA
Pune, IND
Pune, IND
Pune, IND
Boston, USA
Atlanta, USA
San Francisco, USA
Chicago, USA
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.
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.
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.
OpenGov is a cloud-based software company that provides budgeting, planning, reporting, and citizen services solutions for U.S. state and local governments. Founded in 2012, the company was acquired by Cox Enterprises in 2024.
Visit company websiteJobs and hiring trendsFull-time
Mid · 4–6 years experience
Onsite
Apply faster on company sites with our extension.