Working at Bank of America will give you a great career with opportunities to learn, grow and make an impact, along with the power to make a difference. Join us!

Job Description:
This job is responsible for supporting analytical work efforts for various projects within a Line of Business or business discipline. Key responsibilities include leveraging databases to acquire client and performance data, transforming extracted data into meaningful insights and trends, and delivering those insights to leaders to make complex business decisions. Job expectations include working with business partners to understand, coordinate, and deliver agreed upon priorities while communicating complex data outputs and delivering the appropriate summary and data required.

The Operations Data Control (ODC) team provides support to various Global Operations LOBS by providing data analysis in order to detect data anomalies. Our goal is to provide an automated-alert, data-anomaly, detection system. This system will utilize various data storage technologies across the bank, perform statistical analysis techniques on subject data, and deliver reports and alerts through BI and email to subject matter experts for potential remediation.

Responsibilities:

• Supports the extraction of data using a variety of a programming languages, such as SQL, SAS, Python, or Spark/Scala, and applies knowledge of relational and non-relational database systems housed on both on-premise and off-premise (hybrid) platforms
• Connects provisioned data across multiple sources and performs necessary transformations utilizing both technical, business, and process knowledge to transform data into meaningful values and insights
• Performs quantitative techniques and analysis on customer, transaction, and performance data with the guidance from other analysts and supervisors, based on questions provided by business partners, and provides actionable insights for business partners to make informed decisions.
• Follows requirements developed by other analysts and supervisors to perform required research, analytics, and exploration on appropriate and accurate data sources to provide appropriate deliverables
• Communicates complex subjects in a simple and engaging manner to non-technical and technical business partners using software such as Power Point, Word, Excel, and Tableau
• Assists with conducting quality comparison checks on analysis output and escalates data inconsistencies, gaps, or issues to leadership
• Follows quality workflow process and documentation requirements to adhere to standards and provide business continuity

Required Skills:

• 4+ years of data prep experience using coding, such as MS SQL, Teradata SQL, Oracle SQL, Impala or Hive.

• Designs, develops, and maintains automated data Extract, Transform, and Load (ETL) processes from various database platforms, storing data in 'Fit for Use' relational tables.

• Designs and builds relational data models to support the development of actionable reports, dashboards, and scorecards.

• Ensure accuracy of information; perform validation, quality assurance and timely resolution.

• Works collaboratively in a cross-functional team, learns from colleagues, and provides routine updates on calls related to projects.

• Strong attention to detail, problem solving, strategic thinking, and analytical skills.

Desired Skills:

• Strong written, verbal, and presentation communication skills.

• Deep understanding on automation; Autosys, Alteryx, etc.

• Strong problem solving, conceptual thinking, attention to detail, and sense of urgency.

• Ability to manage through ambiguity and agile to process change.

• Self-starting, organized, proactive, and requiring minimal management oversight.

• Time management, analytical and organizational skills.

• Working knowledge of software version control systems such as BIT/GIT Bucket

• Experience with BI platforms, i.e. Tableau, MicroStrategy, Alteryx, etc.

Shift:
1st shift (United States of America)

Hours Per Week:
40