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.
Requirements
- 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.
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.
Other
- 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.
- 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.
