Company:
Marsh McLennan Agency
Description:
Graham Company a division of Marsh & McLennan Agency is an insurance brokerage and consulting firm committed to creating a healthy safe and prosperous tomorrow.
We value empathy discipline integrity courage and tenacity and we are seeking candidates who shares these values to join our team.
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.
- Design develop and maintain data visualization solutions that utilize data from across cloud and onpremise 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 nontechnical 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 Grahams 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:
- Bachelors 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.
- Handson experience in Soap/Rest API/web service including hands on experience in building point to point integration and building integration using middleware.
- 23 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
- 23 years of experience with Data Visualization tools such as Power BI & Qlik required.
- 12 years of experience in or a working understanding of Python BigQuery Applied EPIC.
- Broad stateoftheart 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 vendorsupplied technologies that may strengthen Grahams ability to visualize and report on data.
- Good presentation and reportwriting skills.
- Analytical and problemsolving 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 fitforduty which includes not being under the influence of and/or alcohol. This includes any that might impact an employees ability to safely perform their job.
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 its affiliates are EOEMinority/Female/Disability/Vet/SexualOrientation/Gender Identity employers.
#MMAE