Senior Data Analyst (Informatica Developer)

Federal Home Loan Bank of Pittsburgh • Pittsburgh, PA • 6h ago

Reference #: R374 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.

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 proto@types, 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 is a must

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.

It is the policy of the Federal Home Loan Bank of Pittsburgh to ensure equal employment opportunity (EEO) for all employees and applicants for employment without regard to race, religion, color, sex, national origin, age, disability status, genetic information, veteran's status, ancestry, sexual orientation or status as a parent as defined by applicable law. It is the Bank's policy to comply with applicable laws concerning the employment of persons with disabilities, including reasonable accommodation for applicants and employees with disabilities.

Similar Jobs

Technician 2

Sunbelt Rentals Inc. • Irwin, PA • 5h ago

IT & Engineering

Reference #: 2025-14394 Join Our Team! Sunbelt Rentals strives to be the customer's first choice in the equipment rental industry. From pumps to scaffolding to general construction tools, we aim to be the only call neede...

5h ago

Go to Apply

Networking Engineer

Emerson • Pittsburgh, PA • 12h ago

IT & Engineering

Power & Water Solutions is an industry-leading controls automation company that provides applications in the renewable (solar, hydro, wind), fossil (natural gas and coal) power generation, and water treatment plant s...

12h ago

Go to Apply

Staff Software Engineer, AI/ML, Google Ads

Google • Pittsburgh, PA • 12h ago

IT & Engineering

Staff Software Engineer, AI/ML, Google Ads corporatefare_ Google place Mountain View, CA, USA; Pittsburgh, PA, USA Advanced Experience owning outcomes and decision making, solving ambiguous problems and influencing stake...

12h ago

Go to Apply

Experienced Electrical Engineer

Bechtel Plant Machinery, Inc. • Monroeville, PA • 12h ago

IT & Engineering

Location: Monroeville, Pennsylvania Job Title: Experienced Electrical / Computer Engineer Status: Full-time Professional Annual Salary Range: $97,700 - $170,720 *Salary commensurate with education and experience. Job Sum...

12h ago

Go to Apply

Systems Engineer

First National Bank • Pittsburgh, PA • 12h ago

IT & Engineering

Reference #: 2025-02932 Primary Office Location:626 Washington Place. Pittsburgh, Pennsylvania. 15219. Join our team. Make a difference - for us and for your future. This position is part of the team supporting our conve...

12h ago

Go to Apply

Supervisor of Secondary Market Pricing and Analytics

First National Bank • Pittsburgh, PA • 12h ago

IT & Engineering

Reference #: 2025-02966 Primary Office Location:626 Washington Place. Pittsburgh, Pennsylvania. 15219. Join our team. Make a difference - for us and for your future. Position Title:Supervisor of Secondary Market Pricing...

12h ago

Go to Apply

Senior Traffic Engineer

Langan Engineering and Environmental Services, Inc. • Canonsburg, PA • 12h ago

IT & Engineering

Langan provides expert land development engineering and environmental consulting services for major developers, renewable energy producers, energy companies, corporations, healthcare systems, colleges/universities, and l...

12h ago

Go to Apply

Automation Engineer

Genesis Corp dba Genesis10 • Pittsburgh, PA • 17h ago

IT & Engineering

Reference #: 25-27733 Automation Engineer Level 1 Systems Summary The successful Automation Engineer will develop and execute automation solutions for the modernization and new installation of Level 1 control systems for...

17h ago

Go to Apply

Civil Engineer

Langan Engineering and Environmental Services, Inc. • Canonsburg, PA • 17h ago

IT & Engineering

17h ago

Go to Apply

Automation Engineer

Genesis Corp dba Genesis10 • Pittsburgh, PA • 17h ago

IT & Engineering

17h ago

Go to Apply

Subscribe to get new jobs sent directly to you
(no charge, cancel anytime)

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.