Capital Markets Data Associate

Hyundai Capital•Irvine, CA

2d•Hybrid

About The Position

The Capital Markets Data Associate is responsible for maintaining Treasury databases, developing and maintaining Tableau dashboards and SQL queries, as well as preparing data for external reports. The associate will support data analytics and reporting for the best-in-class $10B+ secured capital markets platforms. This position conducts data analysis and extraction utilizing Excel, Tableau, SQL, and SAS. The associate also prepares data for audits and external reporting, which is required for funding transactions backed by consumer and commercial assets. Additionally, the associate will act as an IT liaison to support IT projects and servicing system upgrades.

Requirements

Minimum 2-4 years of related experience in a quantitative and/or system analytics using SQL and · SAS.
Bachelor’s degree in business, finance, mathematics or related field.
Proficient in MS Office Suites with advanced MS Excel skills
Strong database management and system querying knowledge using SQL and SAS.
Intermediate Tableau knowledge.
Ability to work in a highly time-sensitive, dynamic and growing team environment with superb time management and multi-tasking skills.
Excellent oral and written communication skills.
Proven dedication to excellence and work ethic.

Nice To Haves

Working knowledge of financial and securitization markets preferred.
Securitization and capital markets experience a plus.
Auto finance or banking industry experience a plus.

Responsibilities

Data Analytics: · Maintain and develop analytics for the $10B+ securitization program, maintain and update Treasury databases utilizing SQL, maintain Treasury Tableau dashboards, monitor and validate month-end queries for investor reporting.
Configure and implement all new securitizations into reporting suite (including both servicer report creation and implementation into SAS/SQL programs).
Optimize asset analysis processes to maximize utilization of ABS and conduit platforms.
Provide due diligence, internal compliance, and ad-hoc data analysis support.
Technical Support: · Act as a department liaison to support IT projects and servicing system upgrades.
Follow procedures to test, validate and maintain key processes that are critical to SEC compliance requirements related to RegABII asset level disclosures.
Support various funding platform audits.
Utilize querying tools for ad-hoc analysis and data required for ABS and conduit transactions.
Collaborate with IT and internal stakeholders to build new processes that would enhance current investor reporting processes and analytics.
Support all Treasury related special projects as needed.