What are the responsibilities and job description for the Data Analyst position at Smart IMS?
BACJP00186410
Data Consultant V
6 months- Extension Possible
Description
1. Advanced experience with Microsoft Office (Excel, Outlook, Word, Visio) - pivot tables, Vlookups/Sumifs
2. Data Analyst Experience (Acceptable experience includes – Financial Data Reporting, Data Governance or Data Control)
3. Banking or Financial Experience
Data Consultant V
6 months- Extension Possible
Description
- Assume a key role in the Treasury Data Management reconciliation process across Banking / Treasury / Traded products.
- Treasury Data Management (TDM) Controls Analyst will be involved with daily/monthly controls and governance routines supporting the completeness and accuracy of data consumed by downstream stakeholders
- Analyst will 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. Candidate must 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.
- 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
- Work under minimal supervision on Corporate Treasury projects that require creative solutions and, possibly, automated solutions
- Operational Excellence – Improving Treasury Data Management functions for production, data governance, data change and regulatory/audit activities
- 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
- 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 Client Enterprise Data Management Policy & Standards
1. Advanced experience with Microsoft Office (Excel, Outlook, Word, Visio) - pivot tables, Vlookups/Sumifs
2. Data Analyst Experience (Acceptable experience includes – Financial Data Reporting, Data Governance or Data Control)
3. Banking or Financial Experience
Data Analyst
Everlight Solar -
Charlotte, NC
Data Analyst
Creamos Solutions Inc -
Charlotte, NC
Data Analyst
Actify Systems LLC -
Charlotte, NC
