Job Information
Bank of America Research Data Services Associate – Management Reporting in New York, New York
Research Data Services Associate – Management Reporting
New York, New York
Job Description:
Description
The Research Data Services Associate will be a member of the Global Research Data Services team and will work with internal business and technology associates across regions to provide data, analysis, and reporting solutions to management, support partners and analysts.
Responsibilities
Work with internal partners to understand business requirements and design reporting solutions to recurring data needs.
Support management team and other internal partners with specific data inquiries and ad hoc analysis
Ensure data quality by developing data cleansing routines and working with technology team to organize data for optimal efficiency
Review existing reports and reporting team procedures; recommend and implement improvements
Automate existing SQL-based reporting routines; assist with migration of routines from non-permitted technology to enterprise standard platforms
Support technology-related reporting projects by: analyzing and documenting data lineage, documenting business requirements, reviewing requirements with developers and stakeholders, performing data reconciliation and testing.
Troubleshoot and track data and reporting issues
Required Skills
Undergraduate Degree or equivalent years of experience
3+ years of full-time experience working with data
Strong Excel skills including lookups, pivot tables, common formulas, VBA macros and working with large data sets.
Ability to write intermediate-level SQL queries to retrieve data (aggregate functions, multiple joins)
Experience with Tableau preferred
Experience with Trifacta or Alteryx, Python, MS Power Query/BI or other data manipulation and visualization tools a plus
Excellent verbal and written communication skills
Strong attention to detail; exercise strong quality control over own work
Superior problem-solving and analytical skills
Ability to prioritize and manage multiple projects and meet deadlines in a dynamic setting
Ability to work effectively with others in a collaborative environment, as well as the ability to work autonomously
Shift:
1st shift (United States of America)
Hours Per Week:
40
Bank of America and its affiliates consider for employment and hire qualified candidates without regard to race, religious creed, religion, color, sex, sexual orientation, genetic information, gender, gender identity, gender expression, age, national origin, ancestry, citizenship, protected veteran or disability status or any factor prohibited by law, and as such affirms in policy and practice to support and promote the concept of equal employment opportunity and affirmative action, in accordance with all applicable federal, state, provincial and municipal laws. The company also prohibits discrimination on other bases such as medical condition, marital status or any other factor that is irrelevant to the performance of our teammates.
To view the "EEO is the Law" poster, CLICK HERE (https://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf) .
To view the "EEO is the Law" Supplement, CLICK HERE (https://www.dol.gov/ofccp/regs/compliance/posters/pdf/OFCCP_EEO_Supplement_Final_JRF_QA_508c.pdf) .
Bank of America aims to create a workplace free from the dangers and resulting consequences of illegal and illicit drug use and alcohol abuse. Our Drug-Free Workplace and Alcohol Policy (“Policy”) establishes requirements to prevent the presence or use of illegal or illicit drugs or unauthorized alcohol on Bank of America premises and to provide a safe work environment.
To view Bank of America’s Drug-free workplace and alcohol policy, CLICK HERE .