Marsh McLennan Agency's East Region is looking to simplify employee health and welfare benefits and risk management for regional, national, Fortune 500 and Fortune 1000 companies by leveraging data analytics and visualization.
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.
- Requires an understanding of the application of Agile development methodology.
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 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.
- Good presentation and report-writing skills.
- Analytical and problem-solving abilities.
- Ability to perform tasks independently.
