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, Python, Databricks, Apache Spark, Tableau, and AWS cloud platform will be immediately applicable, as well as working with a dynamic Agile team.

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 experience 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 projects of high to highest complexity.

Demonstrate Core Competency skills for grade and position. 
Involved in the accomplishment of departmental and Bank wide quality initiatives.

Comply with all applicable information security policies, guidelines and practices.
 

What You Have:

• Excellent written and oral communications skills. Independently, presents both orally and in writing, findings, and assessments; prepare and present information and responses to complex inquiries; demonstrate the ability to manage the communication process; communicate with clients, colleagues and management to explain complex issues; transfer technical knowledge; diffuse conflict and build consensus.
• Excellent analytical and problem-solving skills.
• Have a logical, analytical and creative approach to problems; Demonstrate expert level analytical and problem-solving skills; organize data and information in a manner that communicates issues; identify underlying issues and recognizes symptoms that indicate more severe issues.
• Excellent interpersonal skills.
• Demonstrate the ability to lead and participate effectively on a team; lead complex and diverse team efforts by virtue of both technical expertise and leadership skills of influence; recognize the value that different perspectives and cultures bring to an organization; draw on experience to resolve complex issues; display strong interpersonal skills in dealing with people at all levels of an organization.
• Excellent time management skills. Has a meticulous and organized approach to work. Identifies and assesses complex supervisory issues; effectively manages highly complex situations to meet the department’s objectives and goals.
• Excellent knowledge o