Senior Business Intelligence Engineer

Bank of America; Boston (MA); On-site; USD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a Senior Business Intelligence Engineer to enhance decision-making through data-driven solutions. This role involves developing innovative dashboards and reports, collaborating with stakeholders, and utilizing advanced data technologies to drive business performance. The ideal candidate will have a strong background in data warehousing and visualization, along with excellent communication skills. Join a dynamic team where your insights will shape the future of financial services and help foster an inclusive workplace culture. If you're passionate about data and eager to make an impact, this opportunity is for you.

Qualifications

• 5+ years in Data Warehousing with ETL processes.
• Expertise in MicroStrategy and data visualization.
• Strong SQL skills for data analysis and mapping.

Responsibilities

• Develop reporting solutions from data acquisition to delivery.
• Collaborate with stakeholders to understand requirements.
• Design and maintain ETL processes for data insights.

Skills

Automation

Data Mining

Data Quality Management

Data Visualization

Technical Troubleshooting

Agile Practices

Business Acumen

DevOps Practices

Reporting

Technical Documentation

Change Management

Continuous Improvement

Innovative Thinking

Production Support

Technical Strategy Development

Education

Bachelor's Degree in Statistics

Bachelor's Degree in Finance

Bachelor's Degree in Computer Science

Bachelor's Degree in Information Systems

Bachelor's Degree in Mathematics

Bachelor's Degree in Engineering

Tools

MicroStrategy

Tableau

Teradata

Hadoop

SQL

Alteryx

Spark SQL

BASH Scripting

ETL Tools

Job description

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!

Job Description :

Responsible for developing reporting from data acquisition through report development and delivery. Can also be responsible for complex components of large reporting platforms. Frequent client engagement at all levels is required as part of day-to-day work. Participates in client meetings to understand needs and occasionally is asked to contribute specialized knowledge. Leads smaller reporting projects or components of a larger effort. Little to no direct associate management. Expert at tools and process used to build reports end to end. Seen as having good working experience, knows data and business well. May have an area of expertise others look to for coaching and best practices.

A Senior Business Intelligence Engineer within Enterprise Data, Digital, and Marketing will enable leadership with data-driven decision-making solutions that drive company performance and objectives. You will be responsible implementing business intelligence solutions that inform the design, development, and delivery of the most effective digital solutions to drive engagement and business results. This includes collaborating with stakeholders to understand requirements and full execution of data automation processes. Creation of beautiful dashboards and insightful data self-service solutions.

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 dashboards, and scorecards using MicroStrategy (Strategy) Dashboards and Tableau
• Work collaboratively in a cross-functional team, learn from each other, and inspire each other to be the best we can be

Skills :

• Automation
• Data Mining
• Data Quality Management
• Data Visualization
• Technical Troubleshooting
• Agile Practices
• Business Acumen
• DevOps Practices
• Reporting
• Technical Documentation
• Change Management
• Continuous Improvement
• Innovative Thinking
• Production Support
• Technical Strategy Development

Required Qualifications :

• 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 using Teradata and Hadoop
• 5+ years of experience in MicroStrategy design, development, and implementation
• Experience with data visualization, storytelling with data, and design of dashboards that drive actionable decisions,
• Proficient in data discovery using SQL query language to analyze data relationships and data mapping from source data required to code for business logic
• Expertise in Performance Tuning of Queries and ETL code design optimization
• Experience in TERADATA Utilities: BTEQ, Fast load, Multiload, TPUMP and Fast export
• JAMS/Autosys/Unix BASH Scripting or other scheduling tool experience
• Experience with Hadoop, Hive SQL, Impala, Spark SQL, Python, LUNIX, & BASH Scripting
• Experience in ETL Data Preparation Tools such as Alteryx
• Excellent verbal and written communication, interpersonal, organizational, documentation, and presentation skills
• Excellent problem solving, troubleshooting, and debugging skills

Desired Qualifications :

• Experience in financial services with emphasis on digital data analysis; specific experience with digital feature adoption, sales, and services
• Experienced Microstrategy BI professional with proven track records of designing, developing and delivering large, complex enterprise Microstrategy Business Intelligence system solutions from end to end for large companies.
• Full BI System Development Life Cycle (SDLC - Waterfall and Agile) experience including Business Requirements Gathering & Analysis, Data Analysis & Modeling, Solution Design, Development, Testing, Deployment, and Production Support
• Hands-on technical experience and thorough knowledge of all capabilities of Microstrategy BI Suite as well as solid knowledge of other major BI/DW tools and technologies – Tableau, Teradata, Starburst, SQL Server, Alteryx, Hadoop, OLAP, Dimensional Modeling (Star Schema/Snowflake), ETL Process, JAMS/Autosys
• Excellent business communication, and presentation skills with a consultative approach to business challenges and client engagements
• An excellent storyteller that understands business thought process and helps business to make intelligent business decision.
• Strong relationship building, project and team leadership, interpersonal, problem solving and analytical skills.
• Demonstrated can-do attitude and ability to work

Minimum Education Requirement: Bachelor's Degree in Statistics, Finance, Computer Science, Information Systems, Mathematics, Engineering, or an analytical field, or equivalent work experience

For internal employees; participation in a work from home posture does not make you ineligible to post

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Shift:

1st shift (United States of America)

Hours Per Week:

40