Bank of America
Overview
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!
Responsibilities
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
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
Bachelor's degree
1-3 years experience in data analysis or equivalent role with transferrable skillsets
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 1st shift (United States of America)
Hours Per Week 40
#J-18808-Ljbffr
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!
Responsibilities
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
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
Bachelor's degree
1-3 years experience in data analysis or equivalent role with transferrable skillsets
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 1st shift (United States of America)
Hours Per Week 40
#J-18808-Ljbffr