Data Engineer

PayIt; Missouri; On-site; USD 100,000 - 125,000; Full time

Benefits offered by this job

Competitive salaries

Flexible working arrangements

Volunteer program

Job summary

PayIt is seeking a Data Engineer in the United States to collaborate with the Data Engineering team and ensure high-quality data is accessible through reporting, data visualization, data warehouse, and BI tools. You will help build ETL pipelines, data models, and reconciliation systems across multiple data sources.

The role requires strong SQL, Python, and cloud experience (AWS preferred). You will work with dbt, Dagster or Airflow, Snowflake, PostgreSQL, Tableau, and Looker to enable analytical

Qualifications

• Strong SQL experience handling large volumes of data and data modeling with dbt.
• Expertise in Python with test-driven development.
• Experience deploying software to public cloud infrastructure – AWS (preferred).
• Experience with RDBMS, NoSQL and cloud data storage – Postgres, Snowflake, MongoDB as applicable.
• Experience building ETL solutions and transforming data between sources.
• Experience with data orchestration tools like Dagster, Prefect or Airflow.
• Experience building solutions for analytical reporting and business intelligence.
• Experience with data visualization tools like Tableau, Looker or Superset.
• Experience building or working on reconciliation systems for data verification.

Responsibilities

• Collaborate with the data engineering team to provide high-quality data access across reporting, BI tools, and data warehouses.
• Contribute to building scalable data pipelines and data models.
• Support data quality initiatives and reconciliation across sources.

Skills

SQL

Python

AWS

GCP

Azure

NoSQL

ETL

Data modeling

Data visualization

Tableau

Tools

dbt

Dagster

Airflow

Looker

Snowflake

PostgreSQL

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:
$100,000—$125,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.