Database Engineer in Test (Philadelphia or NYC)

CompanyFederal 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 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 of different computer systems and technologies with an ability to learn new skills and technology quickly. An awareness of current issues affecting the industry and its technologies.
• Subject to minimal or no oversight in work performed; serves as mentor and coach and provides constructive feedback to less experienced staff; engage other stakeholders in collecting feedback and input to complete work activities.

Education and Experience:

• Bachelor's degree with a concentration in Information Technology or Computer Science or equivalent significant experience in information technology and software testing is required.
• Minimum of 7 years of experience designing and developing tests for ETL and Data Warehouse solutions using a software development approach.
• Minimum of 5 years of automation development experience with technologies required.
• Product Specific Certifications as applicable are desired.

This posting is a multi-grade job posting. Candidates who have a slightly lower level of experience, education, or qualifications may also be considered.
The salary grade for this position is: 14, 15, 16. Final salary and offer will be determined by the applicant's background, experience and skills, as well as internal equity and alignment with market data.

We offer a great benefits package that features:

• Medical (4 options), Prescription, Dental (3 options), and Vision Insurance with no waiting period
• 401k/Thrift Plan with generous employer match
• Employer-funded Pension Plan
• Paid Vacation/Sick Time & Holidays
• Monthly $200 Commuter Allowance
• Flexible Spending Accounts and Healthcare Spending Accounts
• Flexible Work Schedule available in most departments
• Life Insurance and Long-Term Disability Insurance
• Tuition Reimbursement (undergraduate and graduate)
• Parental Leave
• Free onsite 24/7 Fitness Center including training classes, Peloton bikes and locker room / shower facilities
• Onsite Cafeteria & Coffee Shop
• Additional Convenience Benefits, Discounts and More…

Additional Information:

• The Federal Reserve Bank of Philadelphia takes your information privacy seriously. Federal Reserve Bank of Philadelphia staff will only email you from the “@phil.frb.org” domain or through the Workday system “[email protected]”. If you are initially contacted by phone, feel free to request that the caller provide you with their email address to validate their identity. If you have any questions about the validity of someone who contacts you regarding this position, please email the Talent Acquisition team at [email protected].
• We are an equal opportunity employer committed to hiring the best candidates and to providing equal employment opportunity to all persons without regard to race, color, religion, sex, pregnancy, national origin, age, genetic information, disability, military service, or any other basis protected by law.
• We will ensure that individuals with disabilities are provided reasonable accommodations to participate in the job application or interview process, to perform essential job responsibilities, and to receive other benefits and privileges of employment. If you need assistance or an accommodation due to a disability, please email us at [email protected].
• All Federal Reserve Bank of Philadelphia employees must comply with the Bank's ethics rules, which generally prohibit employees, their spouses/domestic partners, and minor children from owning securities, such as stock, of banks or savings associations or their affiliates, such as bank holding companies and savings and loan holding companies. If you or your spouse/domestic partner or minor child own such securities and would not be willing or able to divest them if you accepted an offer of Bank employment, you should raise this issue with the Recruiter for this posting, who can provide you contact information for our ethics officer if necessary. You should review the Bank's Employee Code of Conduct to ensure compliance with conflict-of-interest rules and personal investment restrictions.
• Background investigations and drug testing are required for all new hires as a condition of employment, after the job offer is made. Candidates for positions deemed as "safety sensitive" will also be screened for the presence of marijuana. Employment may not begin until the Bank accepts the results of the background investigation.
• Due to the nature of the information, you will have access to, we require that you also complete a more in-depth enhanced background screening (Peraton high).
• All employees will be subject to FBI fingerprint / criminal background and Patriot Act/ Office of Foreign Assets Control (OFAC) watch list checks at least once every five years.
• Certain eligibility rules apply. You will provide work authorization to prove your eligibility to work in the United States.
• The above statements are intended to describe the general nature, level of work and the requirements of this position. They are not intended to be an exhaustive list of all responsibilities associated with this position or the personnel so classified. While this job description is intended to be an accurate reflection of this position, management reserves the right to revise this or any job description at its discretion at any time.
• Employee will work full-time on site at the Philadelphia Federal Reserve Bank or the New York Federal Reserve Bank. By applying to this position, you agree you will be available to work on-site in a full-time capacity.
• Learn more about the Philly Fed and its culture. Learn more about working for the Philly Fed.

#LI-Onsite

Full Time / Part TimeFull time

Regular / TemporaryRegular

Job Exempt (Yes / No)Yes

Job CategoryInformation Technology Family Group

Work ShiftFirst (United States of America)

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.

Always verify and apply to jobs on Federal Reserve System Careers (https://rb.wd5.myworkdayjobs.com/FRS) or through verified Federal Reserve Bank social media channels.

Privacy Notice