Associate Data Engineer

PayIt; Kansas City (MO); On-site; USD 60,000 - 75,000; Full time

Job summary

PayIt is a fast-growing GovTech company on a mission to modernize how residents interact and transact with government. In this Data Engineer role, you will work with the data team to ensure high-quality, accessible data across reporting, data warehouses, and BI tools to support government clients and residents.

The role emphasizes building scalable ETL pipelines, data modeling with dbt, and deploying in cloud environments (AWS preferred).

Qualifications

• Strong SQL experience and data modeling with dbt.
• Expertise in Python with a working knowledge of test-driven development.
• Experience deploying software to public cloud infrastructure: AWS (preferred), GCP, Azure.
• Experience with RDBMS, NoSQL and Cloud data storage technologies - AWS DocumentDB, MongoDB, Postgres and Snowflake experience preferred.
• Experience with building ETL solutions and transforming data between different types of sources.
• Experience with modern, Python-based data orchestration tools like Dagster, Prefect or Airflow.
• Experience building solutions for analytical reporting and business intelligence.
• Experience with a data visualization tool such as Tableau, Apache Superset or Looker.
• Experience building or working on reconciliation systems that compare data from multiple sources for verification.

Responsibilities

• Collaborate with data engineers and broader engineering to ensure high-quality data for reporting, data warehouses, and BI tools.
• Develop and maintain ETL pipelines and data models for analytics and dashboards.
• Support reconciliation and data validation across multiple sources.

Skills

SQL

Python

AWS

GCP

Azure

NoSQL

Postgres

ETL

Dagster

Prefect

Airflow

Tableau

Looker

data reconciliation

Tools

dbt

Docker

Kubernetes

Snowflake

MongoDB

DocumentDB

GitHub Actions

Job description

PayIt is a fast-growing GovTech company on a mission to modernize how residents interact and transact with government, improving the customer experience and helping our client agencies more efficiently and effectively achieve their missions. Our easy-to-implement platform consolidates government services and payments into one connected experience and enables our clients to drive resident trust, collect revenue quickly, and redeploy their staff to more important challenges. This innovative approach to government service delivery has garnered significant recognition in both the public and private sectors, including our inclusion in the GovTech 100 every year since 2017. PayIt solutions cover services including hunting and fishing licensing, DMV, courts, property tax, utilities, tolling, and more.

Our culture welcomes people who exhibit what we call “PayIt DNA”: High integrity, drive, grit, high aptitude, and team orientation. We are collaborative and passionate about the work we do to improve the lives of our government clients and the end users they serve. We have ambitious scaling goals, and we look for team members who are ready to roll up their sleeves, solve problems, and find new opportunities to win with our clients. And we have a lot of fun together.

In this position you will work closely with other Data Engineers on your team, and members of the broader Engineering organization, to ensure that the business has access to high quality, accurate data via multiple channels (reporting, data visualization tools, data warehouse, BI tools, etc).

Other duties as necessary.

What You’ll Need to Have:

1. Strong SQL experience and proven expertise handling large volumes of data, including data modeling with dbt
2. Expertise in Python with a working knowledge of test-driven development
3. Experience deploying software to public cloud infrastructure - AWS (preferred), GCP, Azure
4. Experience with RDBMS, NoSQL and Cloud data storage technologies - AWS DocumentDB, MongoDB, Postgres and Snowflake experience preferred
5. Experience with building ETL solutions and transforming data between different types of sources
6. Experience with modern, Python-based data orchestration tools like Dagster, Prefect or Airflow
7. Experience building solutions for analytical reporting and business intelligence
8. Experience with a data visualization tool such as Tableau, Apache Superset or Looker
9. Experience building or working on reconciliation systems that compare data from multiple sources for verification.

Bonus Points For:

1. Experience working with large-scale distributed systems, developing real-time payments systems, and/or working with financial, accounting, or payments systems
2. Experience with CI/CD such as GitHub Actions or Jenkins
3. Experience working with data lakes and/or data warehouses
4. Experience with Docker and Kubernetes
5. Knowledge of microservices architectures
6. Experience developing software professionally following agile methodologies (e.g., Scrum, Kanban)

Annual Salary Range: $60,000 - $75,000 USD

Why Work For Us:

• Our mission matters. Your work will make life better for our government agency clients and the millions of residents they serve.
• You’ll do some of the best work of your career here. We tackle complex challenges that are interesting to solve, and you’ll grow a ton working at PayIt
• People are our most important resource. Everyone has a voice. Collaboration is our default setting. And we have fun together.
• We #payitforward with our corporate volunteer program, serving the communities where we work and live.
• Competitive salaries, excellent benefits, flexible working arrangements, and all the resources you will need to do your best work.

What We Care About:

We hire high aptitude, high integrity people who are great communicators and want to be part of a growing team.

Commitment to Equal Opportunity

PayIt is committed to diversity in its workforce and is proud to be an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, creed, gender, national origin, age, disability, veteran status, sex, gender expression or identity, sexual orientation or any other basis protected by applicable law.

PayIt is also committed to providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation because of a disability for any part of the employment process, please send an email to the People Operations Team and let us know the nature of your request and your contact information.

NOTE: U.S. Citizens and all those authorized to work for any employer in the U.S. are encouraged to apply. We are unable to provide sponsorship in the United States at this time. PayIt participates in E-Verify. To learn more, click here. Canadian Citizens and those authorized to work in Canada without sponsorship are also encouraged to apply.

Within the parameters of this position, ensure the confidentiality, integrity, and availability, and exercise due care of, company, client, and citizen data that is stored, processed, and transmitted by and for PayIt, as outlined in PayIt’s Business Code of Conduct and Information Security Policies.