CADRE Data/Software Engineer

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

Company Federal Reserve Bank of Kansas City When you join the Federal Reserve—the nation's central bank—you’ll play a key role, collaborating with leading professionals to strengthen and protect our economic, financial and payments systems. We invest in contemporary and emerging technology each year to support the Federal Reserve and our economy, and we’re building a dynamic and diverse team for our future. As an embedded IT group, the Center for the Advancement of Data and Research in Economics (CADRE) supports data or computationally intensive research and analytics for staff in the Economic Research division of the Federal Reserve Bank of Kansas City and across the Federal Reserve System. Our technology services include multiple high performance computing environments, research data warehousing and curating services, and endpoint support. We are committed to personal development, training, and research. The Federal Reserve System is modernizing its data infrastructure through initiatives like the Common Data Platform (CDP)—a cloud-based, end-to-end data management platform.

Key Activities

• Collects, cleanses, analyzes, and validates data prior to it being stored in application databases for final use by the organization and/or its clients.
• Constructs and applies standard statistical analysis and/or models to verify data acceptability/accuracy.
• Configures, operates, and develops manual and/or automated methods, processes, and procedures to test output or input based on data compliance, quality and use requirements as established by product management, client specifications, and governance programs.
• Ensures data integrity by implementing quality assurance practices.
• Plans, designs, develops, and performs quality assessments on data elements and structures to document and evaluate integrity, completeness, quality, and appropriateness of formats, records, and structures.
• Gathers and enters missing data and resolves any anomalies.
• Performs regular and ad hoc reviews, audits, and investigations of data activity and integrity; prepares reports and summaries of findings.
• Produces, updates and implements guidelines and documentation of policies, processes, procedures, and standards.
• Identifies areas of improvement in data collection processes or systems and make recommendations to correct any deficiencies.
• Works on Extract, Transform, and Load (ETL) processes/projects, individually or as part of or in conjunction with a database/data warehouse team.
• Partners with customers in the development of innovative solutions that achieve business goals.
• Reviews and analyzes business and technical requirements and implements technical solutions to meet those requirements.
• Actively participate in Agile rituals and follow Scaled Agile processes as set forth by the CDP Program team.

Qualifications

• Typically requires at least 6-15+ years of relevant experience, depending on the level.
• Bachelor’s degree specializing in STEM (Science, Technology, Engineering, Mathematics), or a closely related field, from an accredited college or university, or equivalent combination of directly related education and/or experience.
• Recent accomplishments in developing and analyzing complex SQL on a variety of relational databases (PostgreSQL, MySQL) for data querying and manipulation.
• Advanced data analytics experience for designing, developing, and maintaining the Tableau dashboards and reports that align with business requirements.
• 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 tools such as Databricks, Collibra, and Starburst.
• Experience with Python and PySpark.
• Experience using Jupyter notebooks, including coding and unit testing.
• Experience with a modern data stack (Object stores like S3, Spark, Airflow, Lakehouse architectures, real-time databases) and cloud data warehouses such as RedShift, Snowflake.
• Senior to advanced understanding of subject.
• Has in-depth and/or breadth of knowledge in discipline.
• Performs work independently with limited supervision and direction.
• Serves as a resource for less experienced staff.

Additional Information

How We Work: The selected candidate will reside within a reasonable commuting distance, as defined by the employing Reserve Bank, and will work full-time onsite.

Location(s)

Boston, MA- New York, NY- Philadelphia, PA- Cleveland, OH- Richmond, VA- Atlanta, GA- Chicago, IL- St. Louis, MO- Minneapolis, MN- Kansas City, MO- Dallas, TX- San Francisco, CA or any Branch Offices.

Remote Eligible

No

Relocation Assistance

No

Salary

Salary: $113,500 - $161,600 / Senior Level $127,500 - $181,500 / Advanced Level The listed salary is applicable to the Federal Reserve Bank of Kansas City. Final offers are determined by factors including the candidate’s qualifications, internal alignment considerations, district assignment, and geographic location.

Citizenship Requirements

United States citizenship or lawful permanent resident alien status, with at least three (3) or more years of United States residency from the date of legal entry to the United States is required for this position.

Screening Requirements

This position has additional screening requirements due to the information accessed while performing the job. These additional screenings would be initiated at the time of offer acceptance and could take up to a couple of months to complete. You can begin work before the screening is completed; however, continued employment is contingent on acceptable screening results. The areas screened may include education/employment verification, criminal history, credit history, and reference checks.

Sponsorship

The Federal Reserve Bank of Kansas City will not sponsor a new applicant for employment authorization for this position. Applicants must be currently authorized to work in the United States without the need for visa sponsorship now or in the future.

About the KC Fed Total Rewards & Benefits

Who We Are

What We Do

Employment Details

Full Time / Part Time Full time Regular / Temporary Regular Job Exempt (Yes / No) Yes Job Category Information Technology Family Group Work Shift First (United States of America)

Equal Employment Opportunity

The Federal Reserve Banks are committed to equal employment opportunity for employees and job applicants in compliance with applicable law and to an environment where employees are valued for their differences.

Privacy Notice

OUR BANK has one of the most recognizable brands around the world. The Federal Reserve is the central bank of the United States—one of the world's most influential, trusted and prestigious financial organizations. The Federal Reserve is charged with the important mission of promoting a strong economy and a stable financial system and fulfills this responsibility by formulating national monetary policy, supervising and regulating banks and bank holding companies, and providing financial services for banks and the U.S. government. OUR PEOPLE are diverse in background and ideas, which allows for ongoing creativity and innovation. Ultimately, they are the ones who push our high-performance, exchange-driven culture forward. Why Our People Choose Us: Our reputation precedes us There will always be room for personal growth Our people are first You’ll find the right balance Your responsibilities will be meaningful We hope that you will be our future colleague.