Senior Data Platform Engineer at Opengov

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 [Upgrade to PRO to see link] JOB DESCRIPTION: Senior Data Platform Engineer Location: Pune Tech Stack: Snowflake, dbt (Cloud/Core), AWS, Terraform, Fivetran ABOUT THE ROLE OpenGov is seeking a highly technical Data Platform Engineer to build and scale our centralized data infrastructure. As an early member of the Data Infrastructure team, you will co-architect the systems that power analytics and AI at scale—from ingestion to transformation and governed access. You are the engineer who builds the factory, not just the one who runs the assembly line. You’ll create the "paved path" that enables our federated business units to build, deploy, and monitor their own data products with speed and reliability. You will partner with the engineering/product, and operations team in G&A and GTM, requiring strong collaboration and communication to translate requirements into scalable data platform solutions.   WHAT YOU’LL OWN - The Foundation: Build and maintain our core stack: Snowflake (Data platform), dbt (transformation), AWS/Fivetran (ingestion). - Outcome Focused: Lead implementation of ELT/ETL pipelines for analytical and AI/ML-driven use cases, ensuring data readiness for consumption - Self-Service Tooling: Build the CI/CD pipelines and dbt Mesh structures that allow federated teams to merge code and deploy models without breaking the central warehouse. - Infrastructure as Code (IaC): Manage our data environment using Terraform/Github to ensure scalability, security, and reproducibility. - Observability & Trust: Implement "Data SLA" monitoring so we know data is broken before our customers do. - Security & Governance: Implement & Automate the Role-Based Access Control (RBAC) in Snowflake that balances "open data" with strict government compliance (GDPR/SOC2). WHAT YOU BRING - Bachelor’s degree in Computer Science, Engineering, or a related field. - 8+ Years of Experience in data engineering, platform engineering, or related roles with experience in modular & governed architecture. - Snowflake & dbt - You don't just write queries; you bring strong experience in the Snowflake platform, understanding clustering keys, micro-partitions, optimization and dbt project modularity. - Proven experience designing and scaling automated ingestion frameworks using Fivetran and AWS services (S3, Lambda, IAM) to reliably and securely move data from disparate sources into Snowflake. - Platform Mindset: Prior experience in building self-service provisioning and CICD frameworks. - Software Engineering Rigor - You treat data code like software (unit tests, documentation, version control, and peer reviews). - Programming Excellence: Strong proficiency in Python for integration and SQL for advanced data transformation and Snowflake optimization. - Experience in using AI tools (e.g. Codex, Claude Code, Cursor) to improve engineering workflows. - Strong communication and collaboration skills, with the ability to work effectively across cross-functional teams. NICE TO HAVE - Metadata & Discovery: Experience with data cataloging tools (e.g., DataHub) to help federated teams find and trust data. - Familiarity working with operations data (e.g., Salesforce, Workday, Netsuite) as well as telemetry/operational data from customer-facing products. - Orchestration Expertise: Familiarity with Airflow or Dagster for managing complex, multi-stage dependencies. - Streaming Exposure: Experience with real-time data ingestion (e.g., Kafka, Snowflake Snowpipe) for low-latency use cases. - Public Sector Awareness: Familiarity with government data security standards or handling multi-tenant data architectures. 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, Buenos Aires, Chicago, Dubuque, Plano, 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.