Database Engineer in Test (Philadelphia or NYC)

Federal Reserve Bank•New York, NY

41d•Onsite

About The Position

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.

Requirements

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.
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.

Nice To Haves

Product Specific Certifications as applicable are desired.

Responsibilities

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.
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.

Benefits

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…