girl looking into her desktop
Back to search results

Client Reporting Senior Analyst

Plano, Texas;

Job Description:

A Senior Business Intelligence Developer within the Reporting CoE will enable partners with data-driven decision-making solutions that drive company performance and objectives. You will design and build innovative reporting and analytic self-serve capabilities that provide actionable insights and analytic capabilities to support Bank of America’s Business Banking organization. This includes collaborating with stakeholders to understand requirements and full implantation of data automation processes (ETL) to creation of well-designed and insightful visualizations of data.     

To perform this work, you will be required to analyze disparate data sources and design/build data extract, transform, and load processes (ETL/Data Preparation). You will design and build relational data models to support development of actionable reports, dashboards, and scorecards.  As such, the analyst must have strong communication skills and an ability to “translate” business and analytics requirements into technical specifications

The successful candidate will be expected to: 

  • Interface with business stakeholders and translate business requirements into technical specifications 
  • Analyze disparate database sources, including relational structures, dimensional data models and cubes 
  • Design, develop and maintain ETL/Data Preparation processes to store data in ‘Fit for Use’ relational tables that provide data insight required for reporting and analytic enablement 
  • Design, develop and maintain innovative reports, dashboards, and scorecards using MicroStrategy and Tableau 
  • Work collaboratively in a cross-functional team, learn from each other, and inspire each other to be the best we can be
     

Required Skills, Knowledge and Attributes: 

  • 5+ years of experience in Data Warehousing with architecture, design, development and implementation of automated data warehouse ETL processes 
  • 5+ years of experience in Data Warehousing projects 
  • 3+ years of experience in MicroStrategy and/or Tableau design, development, and implementation Proficient in data discovery using SQL query language to analyze data relationships and data mapping from source data required to code for business logic 
  • Experience in Oracle Databases 
  • JAMS/Autosys/Unix Shell Scripting or other scheduling tool experience 
  • Expertise in Performance Tuning of Queries and ETL code design optimization 
  • Excellent verbal and written communication, interpersonal, organizational, documentation, and presentation skills 
  • Excellent problem solving, troubleshooting, and debugging skills
     

Desired Skills, Knowledge and Attributes: 

  • Bachelor's Degree in Statistics, Finance, Computer Science, Information Systems, Mathematics, Engineering, or an analytical field, or equivalent experience 
  • Experience in financial services with emphasis on Business & Commercial Banking 
  • Experience with data visualization, storytelling with data, and design of reporting views that drive actionable decisions 
  • Experience with designing/developing MicroStrategy and/or Tableau Data Self-Service Solutions Experience with Alteryx or other data preparation tools 
  • Highly motivated, proactive and a self-starter; strong sense of ownership & ability to create and execute plans without daily oversight 
  • Experience with Hadoop is a plus
     

Job Band:

H4

Shift: 

1st shift (United States of America)

Hours Per Week:

40

Weekly Schedule:

Monday - Friday 8 am - 5 pm

Referral Bonus Amount:

0

Job Description:

A Senior Business Intelligence Developer within the Reporting CoE will enable partners with data-driven decision-making solutions that drive company performance and objectives. You will design and build innovative reporting and analytic self-serve capabilities that provide actionable insights and analytic capabilities to support Bank of America’s Business Banking organization. This includes collaborating with stakeholders to understand requirements and full implantation of data automation processes (ETL) to creation of well-designed and insightful visualizations of data.     

To perform this work, you will be required to analyze disparate data sources and design/build data extract, transform, and load processes (ETL/Data Preparation). You will design and build relational data models to support development of actionable reports, dashboards, and scorecards.  As such, the analyst must have strong communication skills and an ability to “translate” business and analytics requirements into technical specifications

The successful candidate will be expected to: 

  • Interface with business stakeholders and translate business requirements into technical specifications 
  • Analyze disparate database sources, including relational structures, dimensional data models and cubes 
  • Design, develop and maintain ETL/Data Preparation processes to store data in ‘Fit for Use’ relational tables that provide data insight required for reporting and analytic enablement 
  • Design, develop and maintain innovative reports, dashboards, and scorecards using MicroStrategy and Tableau 
  • Work collaboratively in a cross-functional team, learn from each other, and inspire each other to be the best we can be
     

Required Skills, Knowledge and Attributes: 

  • 5+ years of experience in Data Warehousing with architecture, design, development and implementation of automated data warehouse ETL processes 
  • 5+ years of experience in Data Warehousing projects 
  • 3+ years of experience in MicroStrategy and/or Tableau design, development, and implementation Proficient in data discovery using SQL query language to analyze data relationships and data mapping from source data required to code for business logic 
  • Experience in Oracle Databases 
  • JAMS/Autosys/Unix Shell Scripting or other scheduling tool experience 
  • Expertise in Performance Tuning of Queries and ETL code design optimization 
  • Excellent verbal and written communication, interpersonal, organizational, documentation, and presentation skills 
  • Excellent problem solving, troubleshooting, and debugging skills
     

Desired Skills, Knowledge and Attributes: 

  • Bachelor's Degree in Statistics, Finance, Computer Science, Information Systems, Mathematics, Engineering, or an analytical field, or equivalent experience 
  • Experience in financial services with emphasis on Business & Commercial Banking 
  • Experience with data visualization, storytelling with data, and design of reporting views that drive actionable decisions 
  • Experience with designing/developing MicroStrategy and/or Tableau Data Self-Service Solutions Experience with Alteryx or other data preparation tools 
  • Highly motivated, proactive and a self-starter; strong sense of ownership & ability to create and execute plans without daily oversight 
  • Experience with Hadoop is a plus
     

Shift:

1st shift (United States of America)

Hours Per Week: 

40

Learn more about this role

Full time

JR-22059119

Band: H4

Manages People: No

Travel: No

Manager:

Talent Acquisition Contact:

Kevin Ruskin

Referral Bonus:

0