Senior Data & Analytics Engineer (ETL, AWS, Tableau)

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

Job summary

The Federal Reserve Bank of Kansas City is seeking an experienced data engineer/analyst to support data analytics, data quality, and data architecture initiatives within the CADRE program. You will work on ETL, data validation, and reporting to enable staff across the Federal Reserve System to access trusted data.

The role requires strong SQL, Python, PySpark, AWS, and BI tooling experience, plus collaboration in an Agile environment.

Qualifications

• Bachelor’s degree specializing in STEM from an accredited college or university, or equivalent combination of related education and experience.
• Recent accomplishments in developing and analyzing complex SQL on relational databases (PostgreSQL, MySQL) for data querying and manipulation.
• Advanced data analytics experience for designing, developing, and maintaining Tableau dashboards and reports.
• Experience using core AWS services to build and support data warehouse solutions leveraging AWS architecture best practices.
• Proven ability to use GitLab for creating a project, cloning a repository, creating a branch, staging, committing and pushing changes.
• Knowledge of AWS Cloud deployments and processes.
• Experience with Python and PySpark.
• Experience using Jupyter notebooks with coding and unit testing.
• Experience with a modern data stack and cloud data warehouses such as RedShift, Snowflake.
• Senior to advanced understanding of the subject and ability to work independently.

Responsibilities

• Collects, cleanses, analyzes, and validates data prior to storage in application databases.
• Constructs and applies standard statistical analysis and/or models to verify data accuracy.
• Configures and develops methods to test data input/output based on governance requirements.
• Ensures data integrity with quality assurance practices.
• Plans and designs data elements and structures for integrity and quality.
• Performs regular and ad hoc reviews and prepares data reports.
• Produces guidelines and documentation for policies and standards.
• Identifies improvements in data collection processes and recommends changes.
• Works on ETL processes with data warehouse teams.
• Collaborates with customers to develop innovative data solutions.
• Reviews requirements and implements technical solutions to meet them.

Skills

SQL

Tableau

Python

PySpark

AWS

GitLab

Data Warehousing

Jupyter Notebooks

Airflow

Cloud Data

Education

Bachelor's degree in STEM

Tools

PostgreSQL

MySQL

RedShift

Snowflake

Databricks

Collibra

Starburst

GitLab

Jupyter

Job description

The Federal Reserve Bank of Kansas City is seeking an experienced data engineer/analyst to support data analytics, data quality, and data architecture initiatives within the CADRE program. You will work on ETL, data validation, and reporting to enable staff across the Federal Reserve System to access trusted data.

The role requires strong SQL, Python, PySpark, AWS, and BI tooling experience, plus collaboration in an Agile environment.