Senior Business Intelligence Engineer

Bank of America; Wilmington (DE); On-site; USD 80,000 - 120,000; Full time

Job summary

Join a forward-thinking company as a Senior Business Intelligence Engineer, where you will leverage your expertise in data warehousing and visualization to enhance decision-making processes. In this role, you will design and implement innovative reporting solutions that drive business performance and engage stakeholders. Collaborate with a dynamic team to create insightful dashboards and automate data processes, all while contributing to an inclusive and supportive work environment. This is an exciting opportunity to make a significant impact in a leading financial institution, fostering your career growth and development.

Qualifications

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

Responsibilities

• Develop and maintain ETL/Data Preparation processes.
• Create dashboards and reports for data insights.
• Interface with stakeholders to gather business requirements.

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

JAMS

Autosys

BASH Scripting

Spark SQL

Job description

Senior Business Intelligence Engineer page is loaded

Senior Business Intelligence Engineer

Apply locations Wilmington Richmond Charlotte Plano Boston time type Full time posted on Posted Yesterday job requisition id 25019421

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

About Us

Bank of America is committed to help employees through the transition period when they’re displaced as a result of a workforce reduction, realignment or similar measure. Please review the resume writing and interviewing tips provided below to help prepare you for your next career opportunity.

Regardless of the position you are interested in, the starting points to building your resume are the same:
1.Determine the job or types of jobs you want to do and research their responsibilities and qualifications.
2.Think about why you can do the job and make a list of your skills that are relative to the job.
3.Identify experiences or accomplishments that show your proficiency in the skills required for the job.
4.Summarize your abilities, accomplishments and skills into a brief, concise document.

Considerations when writing a resume
•Do be brief. Resumes should be 1-2 pages in length.
•Do be upbeat and active in your wording.
•Do emphasize what you have done clearly and concretely.
•Do be neat and well organized.
•Do have others proofread and critique your resume. Spell check. Make it error free.
•Do use high quality, white or light colored 8½ x 11 paper. Use a laser printer if possible.
•Don't be dishonest, always tell the truth about yourself in the most flattering light.
•Don't include salary history or requirements.
•Don't include references.
•Don't include accomplishments that do not support your professional goals.
• Don't include anything that isn't relevant. (For example, don't mention your fondness for swimming unless you want to work on the water.)
•Don't use italics, underlining, shadows or other fancy treatments.

Seven steps to a successful interview
1.Anticipate –Put yourself in the interviewer's position. What do you believe the interviewer is most interested in? Why do you think you have been invited to interview?
2.Research –What are the primary functions of the line of business? What are the success factors for the job? Is there a job description available?
3.Assess –Think about your skills, abilities, knowledge, interests, traits, values and accomplishments. Match them to what you know about the job. Consider which ones you should highlight.
4.Prepare Answers –Think about what the interviewer may ask, determine what the best answer is and write it down.
5.Prepare Questions – Interviewing is a two-way street. By asking thoughtful questions, you communicate your interest and learn a lot about the job. Choose two or three questions to ask your interviewer. Avoid asking a lot of questions about vacation time or breaks.
6.Practice – It may seem awkward, but it is the best way to come across well in an interview. Practice your own "great responses" with others or in front of a mirror until you appear relaxed and at ease.
7.Follow-up – Send a brief follow-up letter to the interviewer. Keep in mind that the many job searchers will not send a follow-up letter. Sending one can become a competitive advantage.