Database Engineer in Test (Philadelphia or NYC)

Company

Federal Reserve Bank of Philadelphia

The Federal Reserve Bank of Philadelphia is one of the 12 regional Reserve Banks that, together with the Board of Governors in Washington, D.C., make up the Federal Reserve System.

It helps formulate and implement monetary policy, supervises banks and bank and savings and loan holding companies, and provides financial services to depository institutions and the federal government.

The Federal Reserve Bank of Philadelphia serves eastern and central Pennsylvania, southern New Jersey, and Delaware.

You will work full-time on site in Philadelphia, PA.

or New York, NY The job description below is a multi-grade job posting.

Candidates who have a slightly lower level of experience, education, or qualifications may also be considered.

Job Summary:

You will design and enhance testing, data validation, and quality assurance processes for automated data -centric applications supporting highly complex business scenarios.

You possess comprehensive operational knowledge across all testing phases and work independently on sophisticated quality assurance initiatives.

You will direct low-level engineers, review their work and may perform as an individual contributor and/or lead data testing for complex systems.

With your proficiency in testing and quality assurance, you'll handle critical projects with significant decision-making autonomy.

What You Will Do:

Data/ETL Test Design and Execution
Design and develop comprehensive data verification and validation for backend data-oriented systems and ETL processes using modern tools, languages, data processing frameworks, and databases approved for use at FRS as applicable.

Technical skills including complex SQL, Databricks, Apache Spark, Tableau, and AWS cloud platform will be immediately applicable.

Knowledge of Python, Linux scripting, and REST APIs will also be relevant.

Experience working with a dynamic Agile team is helpful.

Use scripting/programming languages with a modern IDE and source code management.

Develop automated solutions, using scheduling, CI/CD jobs, or application event triggers as available.

Work with structured and unstructured data from a variety of data stores, such as data lakes, relational database management systems, and data warehouses.

Technical Leadership
Investigate and implement technologies and frameworks that could contribute to process improvements.

Take the lead in improving best practices that benefit all team members performing data testing.

Recommend methods based on your experiences in testing and exploring new technologies.

Data Visualization Testing
Develop solutions for testing data visualizations using common visualization platforms.

Team Collaboration and Knowledge Sharing
Mentor less-experienced team members by providing direction and guidance.

Participate and promote team discussions and contribute to a collaborative work environment.

Participation and Compliance
Participate in Bank, department, or system proj...