Job Details

ID #40348785
State North Carolina
City Charlotte
Job type Contract
Salary USD TBD TBD
Source Signature Consultants
Showed 2022-05-06
Date 2022-05-05
Deadline 2022-07-04
Category Et cetera
Create resume

Data Controls w/ SQL + Excel/VBA

North Carolina, Charlotte, 28202 Charlotte USA

Vacancy expired!

Job Summary:

Signature Consultants is seeking a Data Controls w/ SQL + Excel/VBA for an opportunity with a client located in Charlotte, NC.

Responsibilities:

  • Assume ownership of current Treasury Data Management controls across multiple Banking / Treasury / Traded products
  • Involved with daily/monthly controls and governance routines supporting the completeness and accuracy of data consumed by downstream stakeholders
  • Contribute to multiple internal work streams in support of Treasury initiatives including but not limited to Liquidity reporting (Net Stable Funding Ratio (NSFR), FR2052a (Fed 5G), Liquidity Coverage Ratio (LCR) as well as Capital and Balance Sheet Management
  • Responsible for consistent, timely, and accurate delivery of controls results providing product and technical expertise
  • Manage relationships with business partners (Data Stewards, Treasury Business stakeholders, Technology, Governance) to ensure compliance with data quality and data fit for use requirements
  • Responsible for assisting in the design, development, testing and implementation of Data Quality, Data Validation, and reconciliation controls
  • 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
  • Work under minimal supervision on Corporate Treasury projects that require creative solutions and, possibly, automated solutions
  • Improving Treasury Data Management functions for production, data governance, data change and regulatory/audit activities

Required Skills:

  • Bachelor's degree / or equivalent work experience
  • 3+ years bank experience, 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
  • 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
  • Familiarity with BAC Enterprise Data Management Policy & Standards
  • Advanced experience with Microsoft Office (Excel, Outlook, Word, Visio) - pivot tables, Vlookups/Sumifs - & SQL
  • Data Analyst Experience (Acceptable experience includes - Financial Data Reporting, Data Governance or Data Control)
  • Banking or Financial 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.

EEO Employer

Signature Consultants is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Signature will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or

Vacancy expired!

Subscribe Report job