Senior Data & Software Engineer - ETL, AWS & Analytics

Federal Reserve Bank of Kansas City; Richmond (VA); On-site; USD 114,000 - 182,000; Full time

Job summary

The Federal Reserve Bank of Kansas City seeks a data/software engineer to design, build, and maintain scalable data pipelines and dashboards. You will work in a modern data stack, leveraging AWS services and SQL on relational databases to deliver trusted analytics for multiple Federal Reserve business lines.

Ideal candidates bring 6–15+ years of experience, strong Python/PySpark skills, and hands-on experience with Tableau and data warehousing.

Qualifications

• 6–15+ years of relevant experience.
• Bachelor’s degree in STEM or related field.
• Experience with SQL on relational databases (PostgreSQL, MySQL).
• Advanced analytics for Tableau dashboards and reports.
• Experience with AWS data warehousing solutions.

Responsibilities

• Design, build, and maintain scalable data pipelines (ETL/ELT).
• Develop and validate data quality and integrity measures.
• Collaborate with stakeholders to deliver data-driven solutions.
• Participate in Agile/DevOps practices and CDP initiatives.

Skills

SQL (PostgreSQL/MySQL)

Tableau dashboards

Python

PySpark

AWS

GitLab

Databricks

Collibra

Starburst

Jupyter

Education

Bachelor’s degree in STEM

Tools

AWS

GitLab

Databricks

Collibra

Starburst

Snowflake

Redshift

PostgreSQL

Job description

The Federal Reserve Bank of Kansas City seeks a data/software engineer to design, build, and maintain scalable data pipelines and dashboards. You will work in a modern data stack, leveraging AWS services and SQL on relational databases to deliver trusted analytics for multiple Federal Reserve business lines.

Ideal candidates bring 6–15+ years of experience, strong Python/PySpark skills, and hands-on experience with Tableau and data warehousing.