Data Solutions Engineer

About OpenGov Inc.

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.

Job Summary

The Data Solutions Engineer is a fully qualified, experienced professional responsible for driving complex customer data integration implementations from start to finish. This role requires sophisticated analytical and problem-solving techniques to assess and address unique customer needs by way of database schema knowledge, ETL tooling, and scripting to maximize the value for the customer. As a trusted advisor, the Data Solutions Engineer combines their deep expertise in database systems and data migrations with a strategic perspective to guide customers through their challenging integration and migration needs. By building strong relationships with senior internal and other external stakeholders, this position influences projects to deliver impactful solutions.

Responsibilities

• Serve as a key technical advisor and thought leader, leveraging expertise to guide and influence stakeholders on complex data integration projects.
• Lead the end-to-end implementation of advanced SQL and ETL solutions, addressing diverse and often unique challenges in customer workflows.
• Proactively assess customer needs, using sophisticated problem-solving techniques to propose creative and scalable solutions.
• Partner with senior government personnel and internal cross-functional teams to design and deliver tailored integration strategies.
• Identify and drive opportunities for process improvement, collaborating with internal teams to simplify, enhance, and automate workflows that optimize customer experience.
• Independently manage a diverse portfolio of 10-15 projects, using strong organizational and time management skills to meet critical deadlines.
• Create and refine detailed requirements documentation to ensure alignment with customer goals and technical specifications.
• Mentor junior team members and provide guidance to peers on best practices and innovative approaches for data integrations and migrations.
• Stay informed on the latest trends in SaaS, APIs, and cloud technologies, integrating this knowledge into customer projects to drive innovation and value.

Requirements And Preferred Experience

• 4+ years of related experience in Python, SQL scripting, Professional services delivery experience.
• Experience with different database systems.
• Ability to adapt to a rapidly changing product and respond strategically to customer needs.
• Strong interpersonal skills.
• Experience with budgeting concepts and practices and/or finance/budgeting solutions nice to have.
• Organize own work for daily, weekly, and monthly work plans.
• Proactively communicate deadlines, updates, and issues to relevant parties.
• Experience with SaaS solutions, APIs, or Cloud technologies.
• Experience with Agile & Scrum methodologies.

Why OpenGov?

OpenGov offers a compelling environment for professionals seeking to make a significant impact.

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.

Key skills/competency

• Data Integration
• ETL Solutions
• SQL Scripting
• Python Programming
• Database Systems
• Professional Services
• SaaS Applications
• API Integration
• Cloud Technologies
• Agile & Scrum