Senior Data & Software Engineer - Cloud Data Pipelines

Federal Reserve Bank of Kansas City; San Francisco (CA); On-site; USD 114,000 - 182,000; Full time

Job summary

The Federal Reserve Bank of Kansas City, through the CADRE program, seeks a Data/Software Engineer to design, build, and maintain scalable data pipelines and dashboards. You will work with AWS, Spark/PySpark, and a modern data stack to transform raw data into trusted insights for multiple Fed business lines.

You will participate in Agile practices, collaborate with customers, and contribute to data governance and documentation across projects.

Qualifications

• Recent accomplishments in developing and analyzing complex SQL on PostgreSQL and MySQL.
• Advanced data analytics for Tableau dashboards and reports aligned to business needs.
• Experience with AWS data warehouses and cloud deployments (Redshift/Snowflake).
• Proficient with GitLab project workflows and version control.

Responsibilities

• Collect, cleanse, analyze, and validate data for storage and client use.
• Design, implement, and maintain ETL pipelines and data quality controls.
• Develop and maintain dashboards and reports in Tableau to meet business requirements.
• Collaborate with stakeholders and follow Agile rituals in CDP program.

Skills

SQL

Python

PySpark

Tableau

AWS

Databricks

GitLab

Jupyter

Spark

ETL

Education

Bachelor's degree in STEM

Tools

PostgreSQL

MySQL

AWS

Databricks

Collibra

Starburst

Snowflake

GitLab

Jupyter

Spark

Job description

The Federal Reserve Bank of Kansas City, through the CADRE program, seeks a Data/Software Engineer to design, build, and maintain scalable data pipelines and dashboards. You will work with AWS, Spark/PySpark, and a modern data stack to transform raw data into trusted insights for multiple Fed business lines.

You will participate in Agile practices, collaborate with customers, and contribute to data governance and documentation across projects.