Senior Data & Software Engineer - ETL & Cloud Platform

Federal Reserve Bank of Kansas City; St. Louis (MO); On-site; USD 114,000 - 182,000; Full time

Job summary

The Federal Reserve Bank of Kansas City is seeking an experienced Data/Software Engineer to design, build, and maintain scalable data pipelines and analytics infrastructure. You will work on ETL projects across the data stack, collaborating with stakeholders to deliver trusted insights for supervision, regulation, and research.

Ideal candidates will have 6–15+ years in data/engineering, strong SQL, Tableau, AWS, Python/PySpark, and experience with modern data tools such as Databricks and

Qualifications

• 6-15+ years of relevant experience.
• SQL on relational databases (PostgreSQL, MySQL).
• Experience designing and maintaining Tableau dashboards/reports.
• Experience with AWS data warehouse solutions and deployments.
• Proficiency with GitLab for version control and project management.
• Knowledge of AWS Cloud deployments and processes.
• Experience with tools like Databricks, Collibra, Starburst.
• Experience with Python and PySpark.
• Experience with Jupyter notebooks and unit testing.
• Familiarity with modern data stack (S3, Spark, Airflow, Lakehouse, RedShift, Snowflake).
• Senior to advanced understanding of subject; independent work capability.

Responsibilities

• Design, build, and maintain scalable data pipelines and ETL processes.
• Analyze data integrity, perform QA, and generate reports/insights.
• Collaborate with stakeholders to translate requirements into technical solutions.
• Participate in Agile rituals and adhere to CDP processes.
• Develop guidelines and documentation for data governance and practices.
• Identify data collection/process improvements and implement changes.
• Work on data warehouse projects in collaboration with DB/warehousing teams.
• Partner with customers to develop innovative data solutions.

Skills

SQL

Tableau

Python

PySpark

Jupyter notebooks

Agile/DevOps

Education

Bachelor's degree in STEM

Tools

PostgreSQL

MySQL

AWS

Databricks

Collibra

Starburst

RedShift

Snowflake

GitLab

S3

Spark

Job description

The Federal Reserve Bank of Kansas City is seeking an experienced Data/Software Engineer to design, build, and maintain scalable data pipelines and analytics infrastructure. You will work on ETL projects across the data stack, collaborating with stakeholders to deliver trusted insights for supervision, regulation, and research.

Ideal candidates will have 6–15+ years in data/engineering, strong SQL, Tableau, AWS, Python/PySpark, and experience with modern data tools such as Databricks and