Data & Software Engineer: Cloud Data Pipelines

Federal Reserve Bank of Kansas City; Philadelphia (Philadelphia County); 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 that transform raw data into trusted insights across Federal Reserve business lines. You will work in an Agile/DevOps environment and collaborate with staff in Economic Research and other divisions.

You should have hands-on experience with SQL in relational databases, AWS data services, Python, and PySpark, plus familiarity with modern data stacks and data warehousing.

Qualifications

• Recent accomplishments in developing and analyzing complex SQL on a variety of relational databases (PostgreSQL, MySQL).
• Advanced data analytics for designing, developing, and maintaining Tableau dashboards and reports.
• Experience using core AWS services to build and support data warehouse solutions.

Responsibilities

• Collects, cleanses, analyzes, and validates data for final use; develops standard statistical analyses.
• Configures and tests data processes to meet governance and quality requirements.
• Ensures data integrity through QA practices; documents data structures and formats.

Skills

SQL (PostgreSQL/MySQL)

AWS services

Python

PySpark

GitLab

Jupyter notebooks

CI/CD/DevOps

Education

Bachelor's degree in STEM

Tools

Databricks

Collibra

Starburst

Snowflake

Redshift

Job description

The Federal Reserve Bank of Kansas City seeks a Data/Software Engineer to design, build, and maintain scalable data pipelines that transform raw data into trusted insights across Federal Reserve business lines. You will work in an Agile/DevOps environment and collaborate with staff in Economic Research and other divisions.

You should have hands-on experience with SQL in relational databases, AWS data services, Python, and PySpark, plus familiarity with modern data stacks and data warehousing.