Data Science Analyst

At Mercer, we deliver innovative solutions that address needs of our clients and their employees. Mercer is seeking a Data Science - Analyst who can be based in our Franklin, MA or Urbandale, IA office. This role can be performed remotely.

Data Scien ce - Analyst

What can you expect?

• Become a part of a high-performance team
• Use data to prepare regular and insightful reports which should show the key trends
• Use business acumen to be able to analyze, drive insights and create meaningful reports using large datasets

What is in it for you?

• Work for a global company with excellent benefits and a dynamic culture
• Excellent growth/advancement opportunity
• Workwith collaborative,intelligent, solutions-focusedcolleagueswhotruly care about the work, and each other, while maintaining work-life balance

We will count on you to:

• Gain solid knowledge of all US&C business lines
• Understand customer needs, resolve customer BI/MI complaints quickly and effectively
• Cross-pollination of best practices and ideas across operating teams in other Geographies of Mercer
• Use business acumen to be able to analyze, drive insights and create meaningful reports using large datasets
• Directs and troubleshoots database issues to keep existing databases running efficiently.
• Troubleshoots a wide range of issues including server availability and coding issues for database configurations.
• Directs, plans and executes strategic database activities including installation, configuration and upgrading of SQL server software and products.
• Creates and sizes database storage structures and objects.
• Supports strategic direction for database platforms by evaluating and making recommendations for new platforms.
• Source data from disparate systems with good understanding of Qlik/ other BI tool architecture
• Extract, transform and load (ETL) data from proprietary SQL databases into BI application
• Advanced knowledge of script editor to connect and retrieve data from various data sources at the extraction stage
• Data transformation using advanced joints, functions and sets on SQL database
• Migrate code across production, development and testing environments

What you need to have:

• Bachelor's degree in Business Administration, Math, Engineering or Economics from accredited university or equivalent experience
• 4+ years of experience in business intelligence and performance management
• Experience managing agile development (or any other key project management approach for data sciences and engineering dev)
• Experience with Data Visualization tools like Qlikview, Power BI
• Strong quantitative and analytical skills with ability to translate data into meaningful insights using SSRS, SQL databases

What makes you stand out?

• Balanced approach with technology and business who is able to translate business needs to technology
• Detailed knowledge of data warehouse technical architecture, data modelling, infrastructure component, ETL/ELT and reporting/ analytics tools
• Strong quantitative and analytical skills with ability to translate data into meaningful insights using SSRS, SQL databases
• Experience with API based connections like REST API

The base pay offered will be determined on factors such as experience, skills, training, location, certifications & education. We do not anticipate candidates hired into this role would immediately earn a salary at or near the top end of the range however, such a decision will be dependent 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.

Mercer believes in building brighter futures by redefining the world of work, reshaping retirement and investment outcomes, and unlocking real health and well-being. Mercer's more than 25,000 employees are based in 44 countries and the firm operates in over 130 countries. Mercer is a business of Marsh McLennan (NYSE: MMC), the world's leading professional services firm in the areas of risk, strategy and people, with 76,000 colleagues and annual revenue of $17 billion. Through its market-leading businesses including Marsh , Guy Carpenter and Oliver Wyman , Marsh & McLennan helps clients navigate an increasingly dynamic and complex environment. For more information, visit https://www.mercer.com/ . Follow Mercer on Twitter @Mercer .

Marsh McLennan and its Affiliates are EOEMinority/Female/Disability/Vet/SexualOrientation/Gender Identity employers.

The applicable base salary range for this role is $59,000 to $118,100.

The base pay offered will be determined on factors such as experience, skills, training, location, certifications, education, and any applicable minimum wage requirements. 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.