Senior Data Analyst

Job Description

Senior Data Analyst (Informatica developer)

Position Summary
The Senior Data Analyst role is responsible for translating data requirements into applications that employ appropriate data models and ETL solutions (Informatica, including multi-cloud integration) as well as analyzes, defines, develops, and maintains complex database structures and a viable integration ETL architecture. and applications.

Organization Overview

FHLBank Pittsburgh provides reliable funding and liquidity to its member financial institutions, which include commercial and savings banks, community development financial institutions, credit unions and insurance companies in Delaware, Pennsylvania and West Virginia. FHLBank products and resources help support community lending, housing and economic development. As one of 11 Federal Home Loan Banks established by Congress, FHLBank has been an integral and reliable part of the financial system since 1932. 

Required Experience

• Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field. Or equivalent work experience that includes knowledge of Data Warehousing, Data Integration, Data Transfer methodologies, and Database Management
• Seven or more years leveraging Informatica Cloud toolset (IICS/IDMC) to build and orchestrate data pipelines, ensuring secure and efficient data exchange between cloud and/or on-premise platforms
• Design, develop, and maintain scalable RESTful APIs to support data integration and application interoperability across enterprise systems
• Prefer at least three years of experience in Data Modeling, or Data Integration, including experience using relational, star-schema, and multidimensional data models. Knowledge of current practices, theories, and approaches to performance tuning and optimization, collection of metadata, table partitioning, materialized views, and parallel processing. Proficiency in PL/SQL, SQL, and UNIX scripting
• Prefer three or more years of experience as ETL Architect/Designer, including experience installing and configuring database and ETL software. Advanced-level experience in designing, developing, and maintaining data transfer maps and processes and database structures, including measure, dimension, and hierarchy objects. Ability to analyze and interpret financial information and data to implement business/transformation rules, data profiling, data cleansing, and reconciliation processes to ensure data quality
• Knowledge of operating systems hardware and software, relational databases, and software development tools including but not limited to Linux, Windows, Oracle, SQL-Server, Erwin, MS-Access, and MS-Excel
• Strong interpersonal, communication, and writing skills; able to work independently or in a team environment
• Experience with Agile methodologies to effectively participate in cross functional teams.

Additional Skills & Qualifications

Snowflake is preferred. Will accept Informatica on-prem. Would prefer Informatica cloud experience. API experience with CI/CD highly desired. Communication skills necessary. Could be new development all the way through production support.

Employee Value Proposition (EVP)