Senior Data Analyst

Job Description:

At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. We do this by driving Responsible Growth and delivering for our clients, teammates, communities and shareholders every day.

Being a Great Place to Work is core to how we drive Responsible Growth. This includes our commitment to being an inclusive workplace, attracting and developing exceptional talent, supporting our teammates’ physical, emotional, and financial wellness, recognizing and rewarding performance, and how we make an impact in the communities we serve.

Bank of America is committed to an in-office culture with specific requirements for office-based attendance and which allows for an appropriate level of flexibility for our teammates and businesses based on role-specific considerations.

At Bank of America, you can build a successful career with opportunities to learn, grow, and make an impact. Join us!
 

Job Description: 

• Assume ownership of current CFO Data Management controls across multiple Treasury products. Ownership will include building, delivering, and monitoring daily data controls essential for Liquidity / Regulatory Reporting.
•  Unwind SQL and ETL layers in Oracle database to identify issues/root cause analysis, understand logic/derivations and work with internal and upstream tech partners to resolve issues in a timely manner.
• Design data solutions based on reporting and capability needs of business partners.
• Drives and participates in design, development, and implementation of future 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 CFO 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.
• Work primarily on the Corporate Investments Data Warehouse (CIDW). CIDW encompasses a vast number of treasury products including derivatives, debt, cash, loans, etc.

Required Qualifications:

• Bachelor's degree or equivalent experience
• Advanced knowledge of Microsoft software (Excel, Word, Power Point) including advanced excel functions such as pivot tables, VLOOKUP 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 work independently and take lead on addressing issues.
• Familiarity with ETL tools (Informatica)

Desired Qualifications:

• Knowledge of Treasury Banking products (Securities, Derivatives, Debt, Loans, Deposits, Repurchase Agreements)
• 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
  - BI Tools (PowerPivot, Tableau)
  - Reconciliation experience
  - Data Warehouse experience

Skills:

• Data Collection and Entry
• Data Management
• Data Modeling
• Issue Management
• Policies, Procedures, and Guidelines Management
• Analytical Thinking
• Collaboration
• Data Governance
• Data Quality Management
• Data and Trend Analysis
• Business Acumen
• Controls Management
• Production Support
• Regulatory Compliance
• Solution Design

Shift:

Hours Per Week: