Business Intelligence Analyst

Company:
Marsh McLennan Agency

Description:

Marsh McLennan Agency's East Region is a leader in the employee benefits marketplace. Our associates simplify employee health and welfare benefits and risk management for regional, national, Fortune 500 and Fortune 1000 companies. We value integrity, collaboration, passion, innovation, and accountability, and we are committed to making a difference in the moments that matter for our colleagues, clients, and communities.

The Business Intelligence Analyst will be responsible for building solutions to business problems using Microsoft 365 suite of products including advanced Excel, Power BI and Access and creating ad-hoc reports using multiple data sources. This position offers opportunities to strengthen skills in data analysis, business intelligence and data visualization while providing production support and user training for business systems and proprietary technical solutions.

ESSENTIAL DUTIES AND RESPONSIBILITIES include, but are not limited, to the following:

• Support the development and maintenance of solutions using Excel, Power BI, Power Query and Microsoft Access
• Create ad-hoc reports from multiple data sources to inform business decisions
• Analyze data sets to identify trends and insights
• Collaborate with stakeholders to understand needs and translate them into technical solutions
• Design and develop dashboards and visualizations to communicate findings
• Ensure data accuracy and consistency, contributing to continuous improvement
• Provide basic support and training for business systems and proprietary tools
• Assist with other projects and tasks as needed

REQUIRED EDUCATION AND EXPERIENCE

• Bachelor's degree in Computer Science, Information Systems, Business Administration, or related field, or equivalent experience
• Experience in business intelligence or data analysis is desired
• Demonstrated ability independently and proactively learn new tools and technology
• Basic proficiency in Microsoft 365 products, especially Excel, Power BI, and Access
• Experience in Power Query and VBA is a plus
• Nice-to-have: Experience with Salesforce
• Basic understanding of SQL and data modeling
• Strong analytical, problem-solving, and communication skills
• Ability to work independently, take initiative, and adapt quickly
• Attention to detail and commitment to data accuracy
• Ability to take ownership of time management and prioritization of tasks

KNOWLEDGE, SKILLS AND ABILITIES

• Exercise's judgment, tact, and diplomacy. Has experience handling confidential matters in a highly professional manner.
• Strong organizational, analytical skills and strong attention to detail;
• Excellent troubleshooting, decision making and problem solving skills;
• Solid interpersonal, verbal and written communication skills;
• Ability to work well independently and as a team member;
• Ability to multitask and successfully operate in a fast-paced work environment;
• Ability to prioritize projects and meet deadlines;
• Ability to follow through on and successfully execute tasks while adhering to specified quality standards;
• Demonstrated ability to provide superior customer service and maintain positive relationships with client contacts;
• Proficiency in Microsoft Office Suite, including MS Word (Intermediate), Excel (Intermediate) and PowerPoint (Intermediate);
• Proficiency in use of PC such as keyboard skills and electronic folder/file organization and management;
• Aptitude for learning internal systems, applications and internal work flow of the department;
• Must be able to effectively interact with people at all levels inside and outside of the company.

PHYSICAL DEMANDS AND WORK ENVIRONMENT

• The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
• While performing the duties of this job, the employee is:
  • Frequently required to sit; speak or hear; use hands to finger, handle, feel objects, and reach with hands and arms;
  • Occasionally required to stand and walk;
  • Extensive use of computer and keyboard and viewing of computer screen is required;
  • Specific vision abilities required by this job include vision, and ability to adjust focus.
• Other working conditions are normal for an office environment.

WORK LOCATION

• Work is typically performed in a hybrid manner at MMA East's Conshohocken, PA office.

The applicable base salary range for this role is $67,900 to $80,000.
The base pay offered will be determined on factors such as experience, skills, training, location, certifications, and education. Decisions will be determined on a case-by-case basis. In addition to the base salary, this position may be eligible for performance-based incentives.
We are excited to offer a competitive total rewards package which includes health and welfare benefits, tuition assistance, 401K savings and other retirement programs as well as employee assistance programs.

Marsh McLennan is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age background, disability, ethnic origin, gender orientation or expression, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, veteran status (including protected veterans), or any other characteristic protected by applicable law. If you have a need that requires accommodation, please let us know by contacting

Marsh McLennan and it affiliates are

EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers.

#MMAE

#LI-Hybrid