Reference #: R275 Position Summary The Data Integration Architect role is responsible for the planning, coordination, designing, and supervision of all architectural solutions related to the integration of data across disparate applications, and third-party solutions. The integration solutions are primarily focused on connecting data on-premises and multiple cloud-based solutions. This individual is also responsible for defining and maintaining an application integration architecture to support the data blueprint for the Bank.

Primary Success Factors

Design and execute strategies to move data solutions/technologies from on-premise systems to cloud environments (public, private, or hybrid)

Create scalable and efficient data architectures optimized for cloud services, considering factors like storage, compute, and data processing while adhering to industry regulations.

Implement robust security measures and ensure compliance with various regulations within cloud environments (e.g., encryption, access controls, and data governance)

Design data solutions that can dynamically scale to meet changing demands and optimize performance in cloud-based infrastructures

Architect cost-effective data solutions by leveraging cloud services efficiently, minimizing unnecessary expenses

Establish seamless integration between various cloud-based data services and applications, ensuring interoperability and data consistency

Develop architectures that support big data processing and analytics applications within the cloud environment

Design and implement robust backup and disaster recovery solutions to ensure data resilience and continuity in the cloud

Work closely with cybersecurity teams to fortify data protection measures against cyber threats and vulnerabilities

Create documentation and present data architecture concepts to diverse audiences.

Help set standards and comply with Bank and data governance policies, procedures, and regulations to ensure safe and sound business operations. Recognize and identify potential areas where existing policies and procedures require change, or where new ones need to be developed, especially regarding the security of financial data

Maintain understanding of data modeling and data integration technology trends and best practices and use this knowledge to bring solutions to business units and IT; make recommendations on buy vs. build decisions

Provide periodic reports on activities, accomplishments, issues and their solutions, as well as assisting in forecasts of future utilization, tools, and resource requirements

Ensure compliance with applicable policies, procedures and regulations to ensure safe and sound business operations

Required Experience

Seven or more years of experience using Cloud Data solutions in Amazon Web Services and/or Microsoft Azure

Seven or more years of experience with effectively architecting, managing, and optimizing data solutions to leverage the benefits offered by cloud technologies.

Bachelors or Master's degree in Computer Science, Information Systems, or related field, or equivalent work experience that includes knowledge of Cloud Data Solutions, Data Warehousing, Data Integration, and Database Management

Experience using 3rd party cloud data warehouse solutions such as Snowflake or Data Bricks is a plus

Knowledgeable in the strategy and design of Database Management and Data Warehousing solutions in a Cloud infrastructure.

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 accommo ation for applicants and employees with disabilities.