Description

Job Summary:

 

As a Data Analyst in the Centralized Operations Data Analytics group, you will be responsible for using Analytics tools to derive information from data stored in silos. Develop use cases and data visualizations. Deliver value to the business from data analysis and document, catalog, profile, cleanse and audit the data.

 

Create simple schemas and search indexes for each data set. Create standard profiles, and continually advocate for new data and improved data.

 

Responsibilities:

  • Provide reporting on the status of severity issues, actions, and resolutions during shift. Review incidents, changes and requests, making recommendations on trends such as excessive aging or incomplete troubleshooting of tickets. Maintain compliance to avoid risks of system outages or compromised data.
  • Perform in-depth analysis and problem determination/resolution as it relates to trends in areas such as Backup, incidents, change orders and system metrics including capacity planning. Report and analyze system event and monitoring data and identify areas for automation
  • Assist Data Center Operations managers in reviewing incidents, changes and requests, making recommendations on trends such as excessive aging or incomplete troubleshooting of tickets through the use of data visualization and dashboards
  • Conducts statistical analysis on data and information to ensure correct predictive forecasting or classification. Manages all aspects of end-to-end data processing utilizing customized report building functions of systems. Maintains analytical systems, data repositories and verifies the accuracy of the data, and acts as liaison with data owners.
  • Gather reporting and analysis requirements and translate into reporting structures data models, including aggregate tables, relational and dimensional. Profile and analyze source data to determine the best reporting structures.

Qualifications

Education:

  • Bachelor's degree in related area (Computer Science, Information Systems, Engineering, Statistics) or an equivalent combination of education and experience.

Experience:

  • 4+ years of successfully designing and implementing data-centric applications, such as data warehouses, operational data stores, analytical engines and data integration projects.

Knowledge and skills:

  • 2+ years of relevant experience working with ETL software; Talend is a plus
  • Experience with MS SQL Server and enterprise analytics platforms that deliver dashboards, visualizations; Tableau is a plus
  • Experience or educational background in Statistics using R, R Studio and / or SAS
  • Experience working with Open Source Databases Management systems – MongoDB, MySQL and other.
  • Strong development skills in python
  • Experience with Hadoop, Sqoop, Flume, Hive, Kafka

Other requirements:

 

Work with Operations teams to understand business requirements, independently design, develop, unit test and implement processes to extract data from sources such as SQL Databases, unstructured data sources, Kafka, JSON and XML sources and load into a SQL, NOSQL and Hadoop Data platforms using Talend Studio.

  • Analysis of business requirements and defining technical specifications
  • Use of Advanced SQL for data analysis and validating loaded data.
  • Develop the data integration pipeline with Talend Studio and conduct needed unit and integration testing.
  • Provide support to QA and UAT teams during testing of solutions.

Marsh & McLennan (NYSE: MMC) is the world’s leading professional services firm in the areas of risk, strategy and people. The company’s more than 60,000 colleagues advise clients in over 130 countries. With annual revenue over $13 billion, Marsh & McLennan helps clients navigate an increasingly dynamic and complex environment through four market-leading firms. Marsh advises individual and commercial clients of all sizes on insurance broking and innovative risk management solutions. Guy Carpenter develops advanced risk, reinsurance and capital strategies that help clients grow profitably and pursue emerging opportunities. Mercer delivers advice and technology-driven solutions that help organizations meet the health, wealth and career needs of a changing workforce. Oliver Wyman serves as a critical strategic, economic and brand advisor to private sector and governmental clients. For more information, visit mmc.com, follow us on LinkedIn and Twitter @mmc_global or subscribe to BRINK.

 

Marsh & McLennan Companies offers competitive salaries and comprehensive benefits and programs including: health and welfare, tuition assistance, 401K, employee assistance program, domestic partnership benefits, career mobility, employee network groups, volunteer opportunities, and other programs. For more information about our company, please visit us at: http://www.mmc.com/. We embrace a culture that celebrates and promotes the many backgrounds, heritages and perspectives of our colleagues and clients. For more information, please visit us at: www.mmc.com/diversity.

 

Marsh & McLennan Companies and its Affiliates are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers.

Job

Information Technology/Software Development

Primary Location

United States

Other Locations

United Kingdom-Liverpool, US-TX-Dallas, US-MA-Franklin are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers.

Read Full DescriptionHide Full Description
Confirmed 11 hours ago. Posted 30+ days ago.

Discover Similar Jobs

Suggested Articles

One Step Register
Need an account? Sign Up