Data Analyst with Treasury Products in Charlotte, NC at Signature Consultants

Date Posted: 11/9/2020

Job Snapshot

Job Description

Data Analyst with Treasury Products experience summary:

Signature Consultants is seeking a Data Analyst for an opportunity with a client in Charlotte, NC.

  • Advanced experience with Microsoft Office (Excel, Outlook, Word, Visio) - pivot tables, Vlookup and Microsoft Visual Basic (VBA), SQL
  • Data Analyst or Project Management Experience (Acceptable experience includes - Financial Data Reporting, Data Governance or Data Control)
  • Banking or Financial Experience

Candidates should have extensive work history in several of the following key responsibilities:

  • Assume ownership of current Treasury Data Management controls across multiple Treasury products. Ownership will include building, delivering and monitoring daily data controls essential for Liquidity / Regulatory Reporting.
  • Generate daily and monthly reports on data quality breaks and data validation shifts outside of thresholds
  • Drives and participates in design, development and implementation of future Treasury data controls
  • Liaise between Treasury lines of business and Technology team and other Data Management analysts to communicate control status and escalate issues according to defined process
  • Data Control Governance - Ensuring process controls, data validation activities, and measurement processes remain timely and relevant
  • Create and maintain required documentation and evidence to ensure adherence to EDM Standards and RDA requirements
  • Work under minimal supervision on Corporate Treasury projects that require creative solutions under very tight deadlines
  • Operational Excellence - Improving Treasury Data Management functions for production, data governance, data change and regulatory/audit activities
  • Change Management - Validates data and signs off on reports within test environments to confirm application accuracy, functionality and EDM Standards are met
  • Manage relationships with diverse data partners and technology teams to support initiative work that demand aggressive timelines
  • Collaborate with PMO Leads to and provide updates on project timelines, deliverables and obstacles / challenging
  • Create reporting for senior management that proactively provides project status, issue / enhancement tracking and project implementation
  • Work primarily on the Corporate Investments Data Warehouse (CIDW). CIDW encompasses a vast number of treasury products including derivatives, debt, cash, loans, etc.

Required Skills:

  • Bachelor's degree
  • 3+ years bank experience, project management or other data control environment
  • Advanced knowledge of Microsoft software (Excel, Word, Power Point) including advanced excel functions such as pivot tables, Vlookup and Microsoft Visual Basic (VBA) to supplement SQL skills in data analysis exercises
  • Hands-on experience querying and analyzing large sets of data using SQL (data warehouse is Oracle)
  • Ability to work in a fast-paced environment, be creative, and be able to balance multiple priorities simultaneously
  • Strong analytical and problem solving capabilities skills needed to perform complex data analysis
  • Must possess very strong communication skills with teammates and leadership within Treasury Data Management (TDM)
  • Ability to create executive-ready presentations
  • Ability to work independently and take lead on addressing issues

Desired Skills:

  • Knowledge and prior experience with Liquidity Reporting / Regulatory reporting
  • Basic working knowledge of Tableau
  • Strong knowledge and prior experience with Data Controls monitoring and/or Data Control governance practices
  • Banking or Financial Experience
  • Familiarity with BAC Enterprise Data Management Policy & Standards
  • Treasury background
  • Familiarity with ETL tools (Informatica)
  • BI Tools (PowerPivot, Tableau)
  • Reconciliation experience
  • Data Warehouse experience

About Signature Consultants, LLC

Headquartered in Fort Lauderdale, Florida, Signature Consultants was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. For the ninth consecutive year, Signature was voted as one of the "Best Staffing Firms to Work For" and is now the 14th largest IT staffing firm in the United States (source: Staffing Industry Analysts). With 28 locations throughout North America, Signature annually deploys thousands of consultants to support, run, and manage their clients' technology needs. Signature offers IT staffing, consulting, managed solutions, and direct placement services. For more information on the company, please visit www.sigconsult.com. Signature Consultants is the parent company to Hunter Hollis and Madison Gunn.