Data Science - Lead

Key Skills

Java Programming, Python Programming, C++, C Programming, SQL, Cloud computing, Scala Programming, Machine learning techniques, Data science techniques, MATLAB Programming, PyTorch, TensorFlow, R Programming

Job Description

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

Data Science - Lead

What can you expect?

• Becoming a part of a high performance team
• Being bold in thinking and bringing innovative solutions to any barriers faced
• Use the 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
• Work with collaborative, intelligent, solutions-focused colleagues who truly 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
• 10+ years of experience in business intelligence and performance management in Services Industry, supply chain or logistics
• Experience managing agile development (or any other key project management approach for data sciences and engineering dev)
• 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
• Experience with HDFS technologies like Apache NIFI, Dremio
• Experience with Data Visualization tools like Qlikview, Power BI
• Experience with no/low code apps development
• Knowledge of customer relationship management practices
• Problem-solving attitude
• Excellent analytics skills
• Excellent communication skills

What makes you stand out?

• Aptitude for fostering positive relationships
• Teamwork and leadership skills
• Customer-oriented mind-set