Overview
On Site
Full Time
Skills
Internal auditing
Regulatory reporting
Real estate
Soft skills
Business requirements
Business analysis
IT service management
SQL
JIRA
Microsoft Excel
Toad
Teradata
Alteryx
Apache Flex
Banking
Lingo
Data
Wholesale
Leadership
Finance
Reporting
Writing
Apex
Innovation
Collaboration
Training
Recruiting
Job Details
Job#: 2027857
Job Description:
Top 3 requirements: Y-14Q H1/H2 experience, strong SQL (complex queries), Jira, advanced excel, Plusses: Toad, Teradata, Alteryx Are any of them flexible? H1/H2 flex if they have Y-14Q experience and know the commercial banking lingo.
About the Team:
Risk and regulatory data -
To file regulatory submissions.
Risk space too. Building out models
Space he covers: WCDIR
Has 2 groups/areas BAU (core/corp) - Data... (Lee Vang, MN) iHub, 30 systems of record ? standardize them Kuntals team pulls that data LCSC (Loan, credit, spread cost?)About the Project
They just completed an internal audit and identified 72 issues that must be fixed over the next three quarters. These blended BA/DA's will be tasked with leading the entire remediation of those issues. They'll be working upstream at times, communicate with business and tech leaders, analyze the data, gather insights, and provide a solution.
Job Description: Looking for BA type roles. Will be creating requirements for remediations or simplification activities. All related to regulatory reporting - 14Qh1 h2 schedules
Strong SQL skills are a must. Using SQL to read through store procedures, see the gaps in the data, and know who can provide the data to resolve the issue. Should be able to write complex queries and analyze the data.
Background: Banking, Financial institution or consulting that focused on reg reporting & ranking or finance. Really understanding the lending products. To meet the requirement of the regulators. Anyone in finance that supports the regulatory reporting. Need to understand the commercial banking lingo (Ex: Do they know what consumer level data is? What is a commitment? Interest rates? Etc.)
Soft Skills
Able to work independently. Create business requirements for technology. Ability to dig into the details. Will be writing requirements and running through the business analysis- reviewing results from tech team. And socializing with others in the group.
What tools or technology? Jira, SQL (must), Excel (advanced = must), Toad (pref), Alteryx (plus). Really looking for controller type knowledge of Y-14Q
Yrs of experience? Maybe 2-3 years on Y-14Q H1/H2
Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.
Job Description:
About the Team:
Risk and regulatory data -
To file regulatory submissions.
Risk space too. Building out models
Space he covers: WCDIR
- Wholesale
- Credit
- Data
- Information
- Repository
Has 2 groups/areas
They just completed an internal audit and identified 72 issues that must be fixed over the next three quarters. These blended BA/DA's will be tasked with leading the entire remediation of those issues. They'll be working upstream at times, communicate with business and tech leaders, analyze the data, gather insights, and provide a solution.
Job Description: Looking for BA type roles. Will be creating requirements for remediations or simplification activities. All related to regulatory reporting - 14Qh1 h2 schedules
- H1 = commercial industry loans (CIE/CNI)
- H2 = CRE loans (Commercial real estate)
Strong SQL skills are a must. Using SQL to read through store procedures, see the gaps in the data, and know who can provide the data to resolve the issue. Should be able to write complex queries and analyze the data.
Background: Banking, Financial institution or consulting that focused on reg reporting & ranking or finance. Really understanding the lending products. To meet the requirement of the regulators. Anyone in finance that supports the regulatory reporting. Need to understand the commercial banking lingo (Ex: Do they know what consumer level data is? What is a commitment? Interest rates? Etc.)
- Too much of learning curve without that bg.
Soft Skills
Able to work independently. Create business requirements for technology. Ability to dig into the details. Will be writing requirements and running through the business analysis- reviewing results from tech team. And socializing with others in the group.
What tools or technology? Jira, SQL (must), Excel (advanced = must), Toad (pref), Alteryx (plus). Really looking for controller type knowledge of Y-14Q
Yrs of experience? Maybe 2-3 years on Y-14Q H1/H2
Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.