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.

JOB FUNCTIONS & RESPONSIBILITIES:

Managing analytics projects from start to finish (data integration, analysis, reporting).Carrying out requirements gathering, prototyping new systems, and finding new ways of gathering, cleaning, and analyzing data.Extract data from multiple sources, integrate disparate data into a common data model, and integrate data into a target database, application, or file using efficient ETL processes.esign, develop and maintain data visualization solutions that utilize data from across cloud and on-premise platforms.Troubleshoot issues with Qlik and Power BI dashboards.Consult with internal teams and external clients to determine their ongoing business needs. Skilled in requirement elicitation to assist non-technical employees in describing user stories that have a tangible impact on and allow for the creation of data and visualizations that align with end user expectations.Build and maintain relationships with Graham’s partners and other vendors; serve as liaison to bridge gaps between users and systems.Document scope of work in all stages of integration; noting customizations, routing rules, data mapping, etc.Work on assignments that are complex in nature in which judgment and initiative are required in resolving problems and making recommendations.Remains up to date on industry trends.

JOB SPECIFICATIONS:

Bachelor’s Degree in Computer Science, Information Systems, or Mathematics, or equivalent years of professional experience in lieu of a degree.Data Analytics certification preferred, but not required.Hands-on experience in Soap/Rest API/web service including hands on experience in building point to point integration and building integration using middleware.2-3+ years’ experience with SQL (data analysis, data prep, ETL, ELT, etc.) required.Strong relational database skills, preferably experience with writing stored procedure, functions, triggers, and data modeling.Experience integrating data from structured and unstructured formats: flat files, XML, EDI, JSON, EXCEL.2-3+ years of experience with Data Visualization tools such as Power BI & Qlik required.1-2+ years of experience in, or a working understanding of, Python, BigQuery, Applied EPIC.Broad, state-of-the-art technology awareness that can be applied creatively to business problems and opportunities.Expertise in investigating, vetting, and forming recommendations and perspective on outside services and vendor-supplied technologies that may strengthen Graham’s ability to visualize and report on data.Good presentation and report-writing skills.Analytical and problem-solving abilities.Ability to perform tasks independently.Requires an understanding of the application of Agile development methodology. Professional demeanor.Proficient in Graham standard computer applications.Regular and predictable attendance in accordance with the limitations and reporting procedures established by The Graham Company from time to time.Employees are required to be fit-for-duty which includes not being under the influence of drugs and/or alcohol.  This includes any drugs that might impact an employee’s ability to safely perform their job.

The applicable base salary range for this role is $110,000 to $140,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 reasonableaccommodations@mmc.com

Marsh McLennan and it affiliates are

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

#MMAE

#LI-Hybrid