BA/DA with Y-14Q H1/H2

Job#: 2027857

Job Description:

  1. Top 3 requirements:  Y-14Q H1/H2 experience, strong SQL (complex queries), Jira, advanced excel,
    1. Plusses: Toad, Teradata, Alteryx
    2. 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
  • Wholesale
  • Credit
  • Data
  • Information
  • Repository
 
Has 2 groups/areas
  1. BAU (core/corp) - Data… (Lee Vang, MN)
    1. iHub, 30 systems of record ? standardize them
  2. Kuntals team pulls that data
    1. 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
  • H1 = commercial industry loans (CIE/CNI)
  • H2 = CRE loans (Commercial real estate)
 Need to understand those schedules on the level of finance team.
 
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.

Employee Type:
Contract

Location:
Charlotte, NC, US

Job Type:

Date Posted:
May 6, 2024