The Federal Home Loan Bank of Pittsburgh is looking for a Senior Data Analyst to translate data requirements into applications, manage complex database structures, and ensure efficient data integration between systems, ultimately supporting safe and sound business operations and leveraging data integration technologies for the bank's benefit.
Requirements
- 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.
- 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
Responsibilities
- 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.
- 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.
- Provide production support for the banks integrated batch processing.
Other
- 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
- 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.
- Helps set standards and complies with Bank and data governance policies, procedures, and regulations to ensure safe and sound business operations.
- Ensures compliance with applicable policies, procedures and regulations to ensure safe and sound business operations.
