MIS & Automation Lead

Primary Responsibilities

Strong knowledge of T-SQL programming.

Develop, implement and optimize stored procedures.

Analyze existing SQL queries for performance improvements.

Executing and monitoring existing SQL processes.

Create and maintain data visualizations and reports using SQL Server Reporting Services (SSRS).

Able to analyze and enhance existing SSRS reports.

Design, Develop and maintain ETL packages to load data from various data sources using SQL Server Integration Services (SSIS).

Should be able to create Power BI dashboards, KPI’s, visualizations.

Knowledge of DAX queries would be added advantage.

Designing and implementing SQL Server Analysis Services (SSAS) tabular models for data analysis. Knowledge of MDX (Multidimensional Expressions) queries would be added advantage.

Working closely with MIS Team to support their month end activities and Ad-Hoc requests.

Involved in multiple automation project of premium and claims through SSIS and SSRS.

Maintenance of MIS Server and Co-ordinating with Infra and DBA team for the same.

Competencies

T-SQL, SSRS, SSIS, SSAS, Power BI.

Experience: 10-12 years

Bachelor’s Degree in relevant field.

(B.E.I.T. / BSc. IT / BCA / MCA)

At Liberty Mutual, our purpose is to help people embrace today and confidently pursue tomorrow. That’s why we provide an environment focused on openness, inclusion, trust and respect. Here, you’ll discover our expansive range of roles, and a workplace where we aim to help turn your passion into a rewarding profession.   

Liberty Mutual has proudly been recognized as a “Great Place to Work” by Great Place to Work® US for the past several years. We were also selected as one of the “100 Best Places to Work in IT” on IDG’s Insider Pro and Computerworld’s 2020 list. For many years running, we have been named by Forbes as one of America’s Best Employers for Women and one of America’s Best Employers for New Graduates—as well as one of America’s Best Employers for Diversity. To learn more about our commitment to diversity and inclusion please visit: https://jobs.libertymutualgroup.com/diversity-equity-inclusion/

We value your hard work, integrity and commitment to make things better, and we put people first by offering you benefits that support your life and well-being. To learn more about our benefit offerings please visit: https://LMI.co/Benefits  

Liberty Mutual is an equal opportunity employer. We will not tolerate discrimination on the basis of race, color, national origin, sex, sexual orientation, gender identity, religion, age, disability, veteran’s status, pregnancy, genetic information or on any basis prohibited by federal, state or local law.