Data Engineer

PayIt; United States; On-site; USD 120,000 - 180,000; Full time

Job summary

PayIt is seeking a data engineer to partner with the engineering team to ensure access to high-quality data across reporting, data visualization tools, data warehouse, and BI platforms. You will contribute to robust data pipelines and scalable data solutions for government clients.

In this role you will work with large data volumes, collaborate cross-functionally, and apply test-driven development and cloud best practices to deliver accurate insights and trusted data assets.

Qualifications

• Strong SQL experience and handling large data volumes.
• Python proficiency with test-driven development knowledge.
• Experience deploying to public cloud infrastructure (AWS preferred).
• Experience with RDBMS, NoSQL and cloud data storage tech like MongoDB/Postgres/Snowflake.
• Experience building ETL solutions and data transformations.
• Experience with data orchestration tools (Dagster/Prefect/Airflow).
• Experience in analytical reporting and BI tooling (Tableau/Superset/Looker).
• Experience with data reconciliation across sources.

Responsibilities

• Collaborate with Data Engineers and the broader Engineering org to provide high-quality data via reporting, data warehouse, and BI tools.
• Build and maintain robust data pipelines and analytics-ready datasets.
• Contribute to scalable data solutions and data quality initiatives.

Skills

SQL

Python

ETL pipelines

Tableau/Superset/Looker

Data reconciliation

NoSQL

PostgreSQL

Snowflake

MongoDB

Dagster/Prefect/Airflow

Tools

AWS

GCP

Azure

Docker

Kubernetes

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.

About the 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:

• Strong SQL experience and proven expertise handling large volumes of data, including 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.

Bonus Points For:

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

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.

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.

Canadian Citizens and those authorized to work in Canada without sponsorship are also encouraged to apply.

To all recruitment agencies:

PayIt does not accept agency resumes. Please do not forward resumes to our careers’ alias, PayIt employees or any other company location. PayIt is not responsible for any fees related to unsolicited resumes.

Stay Current on PayIt Happenings: Follow Us On LinkedIn, Facebook, and Instagram.

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.