Ops Consultant - MVSO - Data Reconciliation and Analysis

Company: Bank of America
Location: Fort Worth
Posted on: May 16, 2022

Job Description:

Ops Consultant - MVSO - Data Reconciliation and AnalysisFort Worth, Texas;Greensboro, North Carolina; Plano, Texas**Job Description:**Responsible for Reconciliation account work and performing data analytics within Excel on large to very large data sets for Mortgage Payments and Accounting. Will work on projects and other related duties and will assist other Analysts as needed.Duties include:*Working with large data sets in Excel to reconcile data.*Coordinating and running small projects.*Assisting with larger scale projects.*Providing operational instruction, follow up on situations and ensure bank policy is enforced*Assisting with research, documentation and analysis*Representing the unit at departmental meetings*Communicating to immediate Unit Manager as necessary to support unit operations and resolve unit issues*Acting as a coach, sharing knowledge, skills, and abilities.Required Skills and Experience:+ Reconciliation accounting / data analytics experience+ Experience working with large data sets+ Strong Excel skills - including pivots, vlookups, reporting, etc+ Strong communication skills+ Ability to coach others+ Strong research skillsDesired Skills and Experience:+ Experience with Investor Reconciliation accounting+ Mortgage knowledge+ Experience with SQL, Microstrategy, SAS, or other similar tool**Job Band:**H5**Shift:**1st shift (United States of America)**Hours Per Week:**40**Weekly Schedule:**M-F 8-5**Referral Bonus Amount:**0**Job Description:**Responsible for Reconciliation account work and performing data analytics within Excel on large to very large data sets for Mortgage Payments and Accounting. Will work on projects and other related duties and will assist other Analysts as needed.Duties include:*Working with large data sets in Excel to reconcile data.*Coordinating and running small projects.*Assisting with larger scale projects.*Providing operational instruction, follow up on situations and ensure bank policy is enforced*Assisting with research, documentation and analysis*Representing the unit at departmental meetings*Communicating to immediate Unit Manager as necessary to support unit operations and resolve unit issues*Acting as a coach, sharing knowledge, skills, and abilities.Required Skills and Experience:+ Reconciliation accounting / data analytics experience+ Experience working with large data sets+ Strong Excel skills - including pivots, vlookups, reporting, etc+ Strong communication skills+ Ability to coach others+ Strong research skillsDesired Skills and Experience:+ Experience with Investor Reconciliation accounting+ Mortgage knowledge+ Experience with SQL, Microstrategy, SAS, or other similar tool**Shift:**1st shift (United States of America)**Hours Per Week:**40Learn more about this roleFull timeJR-22044693Band: H5Manages People: NoTravel: Yes, 5% of the timeManager:Talent Acquisition Contact:Kerry LucasReferral Bonus:0Bank 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 .

Keywords: Bank of America, Fort Worth , Ops Consultant - MVSO - Data Reconciliation and Analysis, Professions , Fort Worth, Texas