SQL Analyst with Regulatory Reporting

LOB: Counterparty Risk Management
Length of Assignment: 12 months
Location: Uptown CLT (hybrid schedule)

This group supports the Risk Officers in charge of Regulatory Reporting
Their focus is on data integrity and the truth of the data in real time.
They support reporting around Counterparty Risk - FRY Q Schedule L also FRY A

Looking for a SQL Analyst who can interact with the business to gather and understand regulatory requirements. This candidate must be "the guy who built the thing not the guy that ran the thing"
They will be supporting strategic initiatives and not just executing daily tasks. They use info from MARS (performing aggregation of data - engine behind front end system) and CORES (sourcing data from). NEXUS is used for common source data.

They have developed a lot of individual use cases to support reporting and this person will be taking those individual use cases and bringing them into the existing infrastructure. They will be reverse engineering the SQL code that exists today and rebuilding it into what it needs to be the new use cases moving forward. They are creating requirements and writing 50+ lines of stored procedures. The finished product should align with the Counterparty Risk standards.

Candidates must be able to adapt to change, work independently and be naturally curious