GovTech Data Engineer: ETL, Data Warehousing & BI

PayIt; Kansas City (MO); On-site; USD 100,000 - 125,000; Full time

Job summary

PayIt in the United States is seeking a Data Engineer to ensure high-quality, accessible data across reporting, data visualization, and data warehouse platforms. You will collaborate with engineers to deliver reliable data pipelines and analytics capabilities for government clients and residents.

You will apply SQL prowess, Python expertise, and modern orchestration tools to build scalable ETL processes, optimize data quality, and enable BI reporting with Tableau, Looker, Superset, or similar

Qualifications

• Strong SQL experience with large data volumes.
• Experience building ETL pipelines and transforming data between sources.
• Experience with modern Python data orchestration and BI tools.

Responsibilities

• Ensure access to high-quality, accurate data via reporting, data warehouse, and BI tools.
• Contribute to data models and ETL solutions and support analytics needs.

Skills

SQL

Python

Data modeling

ETL development

Data orchestration

BI reporting

Data visualization

Reconciliation systems

Analytical thinking

Strong communication

Tools

dbt

AWS DocDB

MongoDB

Postgres

Snowflake

Dagster

Prefect

Airflow

Tableau

Superset

Looker

Docker

Kubernetes

GitHub Actions

Jenkins

Job description

PayIt in the United States is seeking a Data Engineer to ensure high-quality, accessible data across reporting, data visualization, and data warehouse platforms. You will collaborate with engineers to deliver reliable data pipelines and analytics capabilities for government clients and residents.

You will apply SQL prowess, Python expertise, and modern orchestration tools to build scalable ETL processes, optimize data quality, and enable BI reporting with Tableau, Looker, Superset, or similar