The Junior Data Engineer will build robust data processing capabilities – databases, data pipelines and ETL processes for balance sheet modeling, risk analytics and optimization. The core tools are Python, SQL and Snowflake
Essential Job Function:
Data Infrastructure Development:
• Design and build reliable and efficient processes for the loading, transformation, and storage of complex financial data from various sources.
• Utilize SQL, Python, and Snowflake for data handling and management.
• Build processes for data verification and take responsibility for ensuring data quality.
• Collaborate with colleagues in employing the data to enable the development of Balance Sheet modeling and analytics tools which will promote data-driven decision-making across the Bank.
Financial Concepts Understanding:
• Over time, the Junior Data Engineer will develop an understanding of financial concepts associated with the analysis of bond, swap and option instruments (e.g. pricing, risk exposures, market dynamics), and use such knowledge to inform the construction of data processes and analytical tools relevant to Balance Sheet management.
Collaboration:
• Work closely with the Data Management Office, Financial Risk Management, I.T. and business teams in developing and launching in production multiple analytical tools.
Skills:
• Must be skilled in Python programming with meaningful experience using Python in data processing tasks. Such experience may be derived from either professional or educational settings. Familiarity with object-oriented programming concepts is required
• Proficiency in building SQL queries for data processing is required, with some exposure to database design principles. Must be able to create database tables, build robust processes to update them, and guide colleagues on using them for data extraction. Exposure to cloud-based data platforms (e.g. Snowflake) and ETL software tools would also be helpful.
• Capability to analyze complex sets of data and provide actionable insights.
• Excellent communication skills for effective cross-team collaboration.
Education:
Bachelor’s or Postgraduate degree in Computer Science, Data Science, Engineering, Financial Engineering, Quantitative Finance or related STEM discipline
Salary: $100K to $115K
The Federal Home Loan Bank of New York is committed to recruit, hire, develop, motivate, promote, retain, and compensate all applicants and employees in a nondiscriminatory manner without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, status as a parent, disability, genetic information, military or veteran status, or any other characteristic protected by applicable law (including title VII of the Civil Rights Act of 1964).
Top Skills
What We Do
The Federal Home Loan Bank of New York (FHLBNY) is a privately-owned wholesale bank that helps community lenders in New Jersey, New York, Puerto Rico and the U.S. Virgin Islands advance housing and community growth. The FHLBNY membership is comprised of commercial banks, savings banks, savings and loans, credit unions, insurance companies and community development financial institutions.
The FHLBNY is part of the Congressionally-chartered, nationwide Federal Home Loan Bank System, which was created in 1932 to provide a flexible liquidity source for member community lenders engaged in home mortgage and neighborhood lending. The mission of the FHLBNY is to advance housing opportunity and local community development by maximizing the capacity of community-based member lenders to serve their markets.
Since the FHLBNY is a secured lender, all of its credit products require real estate related collateral. The FHLBNY enables local lenders to extend affordable credit to their communities. Thanks to the Federal Home Loan Bank System, communities across the country have access to more affordable housing, small business, and community development programs.
