Quality Engineering Data Specialist
Federal Reserve Bank of Atlanta
CompanyFederal Reserve Bank of New YorkWorking at the Federal Reserve Bank of New York positions you at the center of the financial world with a unique perspective on national and international markets and economies. You will work in an environment with a diverse group of experienced professionals to foster and support the safety, soundness, and vitality of our economic and financial systems.
The Bank believes in work flexibility to balance the demands of work and life while also connecting and collaborating with our colleagues in person. Employees can expect to be in the office a couple of days per week as needed for meetings and team collaboration and should live within a commutable distance.
What we do:
The Quality Engineering function within Enterprise Platforms and Capabilities organization is responsible for overall Quality Engineering practices in each squad. The Quality Engineers in the squad collaborate with Developers, Product Owners, and Scrum Master to create a quick feedback loop for Quality through Test Automation and Continuous Testing.
Your role as Quality Engineering Data Specialist:
Collaborating in Agile cross-functional teams with to deliver solutions with high quality across different technical environments in accounting domain.
Testing API, data profiling included end to end starting with data ingestion and all related data tasks. Ability to create analytical data view by gathering data from various sources based on the logical use cases and rules related to accounting and underlying operations validate data, calculations at various stages including validation of attributes and transformation using data tools technology.
Validating existing user scenarios in old system, performing good debugging/analytical reasoning skills including application log validations.
Data Profiling and test data creation mapping back to the accounting use cases and rules.
Dissecting transformation rules and validating the data migration/onboarding on old versus new system.
Developing test automation and enabling DevOps through continuous testing.
Working knowledge of AWS based data sources such as Aurora Postgres and Athena, Data Glue, Snowflake, Data Bricks and Collibra data quality system to deliver strong Quality solutions.
What we are looking for:
Working experience in Investment bank preferably in accounting domain.
Hands-on experience designing and masking test data based on the user scenarios/rules and building scripts to test data pipelines for data lake/ data warehouse ecosystem.
Data validations using SQL, strong understanding of the relational database concepts and models.
Experience building test automation have used automated frameworks, tools, and strong SQL, data management concepts including data profiling, data mapping and data integration.
Strong debugging/analytical skills including dissecting transformation rules, data inconsistencies, incompleteness of data.
Demonstrated ability of working with AWS services understanding such as Data Glue, Data Bricks, Snowflake, Aurora Postgres, Athena, and Collibra Data Quality Platform.
Experience working in a DevOps environment, SCD and hands on experience using CI/CD systems preferred to enable test data pipeline.
Experience in hands-on Python programming language experience used to build test automation.
Salary Range: $148400 – $207900 / year
We believe in transparency at the NY Fed. This salary range reflects a variety of skills and experiences candidates may bring to the job. We pay individuals along this range based on their unique backgrounds. Whether you’re stretching into the job or are a more seasoned candidate, we aim to pay competitively for your contributions.
Our Touchstone Behaviors—Communicate Authentically, Collaborate Inclusively, Drive Progress, Develop Others, and Take Ownership—help shape the culture of the Bank. They also provide a shared language for how we work together and achieve success, and they set clear expectations for leading with impact at every stage of your career with us. Learn more.
Our organization offers benefits that are the best fit for you at every stage of your career:
Fully paid Pension plan and 401k with Generous Match
Comprehensive Insurance Plans (Medical, Dental and Vision including Flexible Spending Accounts and HSA)
Subsidized Public Transportation Program
Tuition Assistance Program
Onsite Fitness & Wellness Center
Please note that the position requires access to confidential supervisory information and/or FOMC information, which is limited to "Protected Individuals" as defined in the U.S. federal immigration law. Protected Individuals include, but are not limited to, U.S. citizens, U.S. nationals, and U.S. permanent residents who either are not yet eligible to apply for naturalization or who have applied for naturalization within the requisite timeframe. Candidates who are permanent residents may be eligible for the information access required for this position if they sign a declaration of intent to become a U.S. citizen and pursue a path to citizenship and meet other eligibility requirements.
In addition, all candidates must undergo an enhanced background check, comply with all applicable information handling rules, and will be tested for all controlled substances prohibited by federal law, to include marijuana.
The Federal Reserve Bank of New York is committed to a diverse workforce and to providing equal employment opportunity to all persons without regard to race, color, religion, national origin, sex, sexual orientation, gender identity, age, genetic information, disability, or military service.
This is not necessarily an exhaustive list of all responsibilities, duties, performance standards or requirements, efforts, skills or working conditions associated with the job. While this is intended to be an accurate reflection of the current job, management reserves the right to revise the job or to require that other or different tasks be performed when circumstances change.
Full Time / Part TimeFull time
Regular / TemporaryRegular
Job Exempt (Yes / No)Yes
Job CategoryInformation Technology
Work ShiftFirst (United States of America)
The Federal Reserve Banks believe that diversity and inclusion among our employees is critical to our success as an organization, and we seek to recruit, develop and retain the most talented people from a diverse candidate pool. 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.