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.
Primary Success Factors
• Translates data requirements into applications that employ appropriate data
models and ETL solutions. Analyzes, defines, develops, and maintains complex
database structures and ETL architectures and applications. Creates data flows
and ETL models defining the data transformation needs of projects. Ensures
effective and efficient utilization of ETL processes when accessing,
integrating, and delivering data between systems.
• Develops and implements data validation, auditing, reconciliation, testing
methodologies, and integration processes. Coordinates with business/data
analysts on data cleansing and data profiling activities to improve quality of
data.
• Works closely with DBA Team and Operations to establish ETL job workflow with
reliable error/exception handling and rollback framework, including scheduling,
error management, restartability, email notifications, and information
publishing.
• Develops and maintains accurate system documentation including information
about attributes, lineage, and business rules. Assists in the gathering of
metadata and maintenance of repositories and data dictionaries.
• Helps set standards and complies with Bank and data governance policies,
procedures, and regulations to ensure safe and sound business operations.
Recognizes and identifies potential areas where existing policies and
procedures require change, or where new ones need to be developed, especially
regarding the security of financial data.
• Works with IT groups to implement a disaster recovery and business
continuance solutions for ETL processes, including the installation,
configuration, and testing of software.
• Participates in the development and maintenance of strategic, architectural,
and tactical plans for the Bank's data integration technologies. Conversant
with and cognizant of the future direction of systems, how that direction
impacts the Bank, and how future and current systems can be exploited for the
benefit of the Bank.
• Maintains understanding of data modeling and data integration technology
trends and best practices and uses this knowledge to bring solutions to
business units and IT; makes recommendations on buy vs. build decisions.
Mentors Team members and is a technical resource on data integration and ETL
technologies.
• Maintains understanding of information flows and the data integration technology
to support the documentation of the all of the banks structured data flows.
• Provide production support for the banks integrated batch processing.
• Provides periodic reports on activities, accomplishments, issues and their
solutions, as well as assisting in forecasts of future utilization, tools, and
resource requirements.
• Ensures compliance with applicable policies, procedures and regulations to
ensure safe and sound business operations.
• Prefer to be knowledgeable in Data Warehousing and Change Data Capture
lifecycles and methodologies. Performs modeling of data sources and flows and
works with Data Services staff to identify, design, and implement data
warehouse objects – star schemas, multidimensional tables, and BI Universes –
using best practices. Designs and develops prototypes, data classifications,
and database tables and views to aggregate data as required for reporting
optimization.
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)
Very stable organization with
government bank and exposure to m
Information
Locations Position Open to Only localsIndustry Information TechnologyStatus OpenJob Age 11 Day'sCreated Date 11/18/2025No.of Positions 2Duration 12 MonthsZip Code
