Business Systems Analyst Sr. - Artech LLC
PITTSBURGH, PA 15222-2722
About the Job
Business Systems Analyst Sr.
Position Location:
1. Pittsburgh, PA 2-3 days in office
2. 100% Remote
Ability to work remote: yes
Acceptable time zone(s): EST
Working Hours (Flexible): core est business hours; 830EST stand up call
Travel: rare if any
Days of the week: Monday through Friday
This team is dedicated to developing innovative data products and business process solutions to support the Regulatory Reporting, Data Submissions and Finance Capital Reporting teams at the Bank. The Business Analytics Senior will work on business and regulatory requirements related to FRY 9c, FRY 14M/Q, Single counterparty Credit limit FR2590, Basel III. The role requires subject matter expertise in Asset Liability Management at Financial Institutions along with proficiency in financial modeling as well as tools and methodologies used for business analytics.
The role requires subject matter expertise in Financial and Regulatory Reporting for Financial Institutions well as tools and methodologies used for business analytics.
Focus on functional knowledge of the Regulatory Reports (9C/14M/14Q) and knowledge about loans.
Roles and Responsibilities:
Gather requirements from business units
Confer with clients regarding the nature of the information processing or computation needs.
Provides consulting services to internal business groups on process improvement projects designed to improve business results.
Analysis, definition and documentation of business and data requirements
Technical Skills:
5-8 years of experience working as a Business Analyst or a Data Analyst, with a minimum of 3 years of experience in financial analysis or modeling for Asset Liability Management, Treasury Management, Credit Risk Management or SCCL/Basel III Regulations
Relevant work experience in interpreting Fed instructions for specific regulatory reports and converting them to technical requirements for building the regulatory reports.
Good understanding of the Capital regulations for U.S Banks
Intermediate to advanced level SQL skills for data analysis in Oracle and Teradata databases
Proficiency in Excel, with exposure to BI tools such as Tableau / Client Power BI / Oracle BI
Extensive experience in the analysis, definition and documentation of business and data requirements.
Experience in FRY 9c, FRY 14M/Q, FR2590, Basel III and the corresponding regulatory submissions would be highly relevant. Detailed knowledge of the reports and report layouts pertaining to specific schedules within any of these regulatory reports in required.
Soft Skills:
Must possess strong communication skills, both written and verbal.
Degrees/Certifications:
Preferred - Masters in Finance
Relevant work experience
Pre-Screening Questions:
What s the difference between a left join and an inner join?
Describe an example of working through the Fed instructions to understand the impact of a change in requirements for the FR-Y9C, FR-14Ms, 14Qs, BASEL, FR 2590, or Call Report.
Describe a time where you had to work through several teams, with competing agendas to complete a project.
Position Location:
1. Pittsburgh, PA 2-3 days in office
2. 100% Remote
Ability to work remote: yes
Acceptable time zone(s): EST
Working Hours (Flexible): core est business hours; 830EST stand up call
Travel: rare if any
Days of the week: Monday through Friday
This team is dedicated to developing innovative data products and business process solutions to support the Regulatory Reporting, Data Submissions and Finance Capital Reporting teams at the Bank. The Business Analytics Senior will work on business and regulatory requirements related to FRY 9c, FRY 14M/Q, Single counterparty Credit limit FR2590, Basel III. The role requires subject matter expertise in Asset Liability Management at Financial Institutions along with proficiency in financial modeling as well as tools and methodologies used for business analytics.
The role requires subject matter expertise in Financial and Regulatory Reporting for Financial Institutions well as tools and methodologies used for business analytics.
Focus on functional knowledge of the Regulatory Reports (9C/14M/14Q) and knowledge about loans.
Roles and Responsibilities:
Gather requirements from business units
Confer with clients regarding the nature of the information processing or computation needs.
Provides consulting services to internal business groups on process improvement projects designed to improve business results.
Analysis, definition and documentation of business and data requirements
Technical Skills:
5-8 years of experience working as a Business Analyst or a Data Analyst, with a minimum of 3 years of experience in financial analysis or modeling for Asset Liability Management, Treasury Management, Credit Risk Management or SCCL/Basel III Regulations
Relevant work experience in interpreting Fed instructions for specific regulatory reports and converting them to technical requirements for building the regulatory reports.
Good understanding of the Capital regulations for U.S Banks
Intermediate to advanced level SQL skills for data analysis in Oracle and Teradata databases
Proficiency in Excel, with exposure to BI tools such as Tableau / Client Power BI / Oracle BI
Extensive experience in the analysis, definition and documentation of business and data requirements.
Experience in FRY 9c, FRY 14M/Q, FR2590, Basel III and the corresponding regulatory submissions would be highly relevant. Detailed knowledge of the reports and report layouts pertaining to specific schedules within any of these regulatory reports in required.
Soft Skills:
Must possess strong communication skills, both written and verbal.
Degrees/Certifications:
Preferred - Masters in Finance
Relevant work experience
Pre-Screening Questions:
What s the difference between a left join and an inner join?
Describe an example of working through the Fed instructions to understand the impact of a change in requirements for the FR-Y9C, FR-14Ms, 14Qs, BASEL, FR 2590, or Call Report.
Describe a time where you had to work through several teams, with competing agendas to complete a project.
Source : Artech LLC
