Data Engineer

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 high-ownership, solution-oriented Data Engineer to join our rapidly growing Data Platform team. You'll work hands-on with dbt to model and transform data that powers decision-making across the organization — and you'll take end-to-end ownership of how that work gets shipped: version-controlled, tested, and deployed through CI/CD rather than simply handed off. You think in terms of data models, business domains, and consumption patterns, but you're equally comfortable working close to the infrastructure your data pipelines run on. You view data and infrastructure similar to software that is maintained, not just stateless scripts that are deployed and forgotten about. You partner closely with business analytics, product, and AI 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 — modular layering (staging, intermediate, marts), documentation, and data tests. Optimize SQL queries and dbt models for performance using Snowflake features like clustering, materialization strategies, and query profiling. - Pipeline Scheduling & Deployment: Own scheduling and orchestration of dbt jobs, ensuring reliability, observability, and SLA adherence. Own CI/CD workflows for dbt and pipeline deployments using GitHub Actions — automated testing, linting, and promotion through environments. Work with the Data Platform team on AWS resource provisioning (via Terraform) needed to support ingestion and pipeline infrastructure. - 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 anomalies during scoping and build phases. WHAT YOU BRING - Bachelor's degree in Computer Science, Mathematics, Engineering, Statistics, or a related field. - 4–6 years of experience in data engineering, backend engineering, or a similar role. - Data warehouse & dbt Proficiency: Hands-on experience building and maintaining dbt projects in a data warehouse (preferably Snowflake). - DevOps Experience: Experience building or maintaining CI/CD pipelines (GitHub Actions preferred) for automated testing and deployment of pipelines. - Data Modeling Skills: Solid understanding of dimensional modeling (star schema, preventing schema drift, etc. ) and the ability to design models that balance clarity, performance, and flexibility. - Cloud Familiarity: Hands-on experience with core AWS services (e.g., S3, Lambda, IAM). - SQL Mastery: Advanced SQL — complex transformations, window functions, etc. - Python: Proficiency in Python for data manipulation, pipeline scripting, and automation. - Data Analysis: Comfort exploring raw data, identifying quality issues, communicating findings clearly. - Software Engineering Practices: You treat data code like software — version-controlled, peer-reviewed, tested, documented. - Strong communication and collaboration skills across technical and non-technical audiences. - Experience using AI-assisted development tools (e.g., Claude Code, Cursor, Codex) to accelerate engineering workflows. NICE TO HAVE - Some working exposure to Terraform or other IaaC for provisioning/managing cloud resources. - Comfort in discovery sessions with business stakeholders, translating their analytical problems into well-structured data models. - Exposure to a workflow orchestrator (e.g., Airflow, Dagster, Prefect) — not required day-to-day, but a plus. - 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. - Experience working with business application data (e.g., Salesforce, Workday, NetSuite) and its quirks. - Familiarity with BI tooling (e.g., Tableau, Looker) and how data models serve visualization layers. - Exposure to data cataloging/discovery tools (e.g., DataHub). - Any exposure to containerized deployments (Docker, SPCS) — not required, but a plus if present. 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.