Reporting Specialist

Introduction

Welcome to Gallagher - a global community of people who bring bold ideas, deep expertise, and a shared commitment to doing what's right.

We help clients navigate complexity with confidence by empowering businesses, communities, and individuals to thrive.

At Gallagher, you'll find more than a job; you'll find a culture built on trust, driven by collaboration, and sustained by the belief that we're better together. Experience a workplace where you're encouraged to be yourself, supported to succeed, and inspired to keep learning. That's what it means to live The Gallagher Way.

Founded in 2006, the Gallagher Center of Excellence (GCoE) upholds the values of quality, innovation, and teamwork. With 10,000+ professionals across five India locations, GCoE is where knowledge-driven individuals make a significant impact and build rewarding, long-term careers.

Overview

Gallagher Center of Excellence is seeking to hire a Reporting Specialist professional for the GCoE Business Enablement vertical. As part of the GCoE Business Enablement team, you will be responsible for analyzing complex data sets to provide actionable insights that drive business decisions. You will manage the collection, processing, and analysis of data to support strategic initiatives and improve operational efficiency. You will lead a team of analysts and ensure the seamless delivery of data-driven solutions to internal stakeholders. Your role will involve driving data excellence and innovation. Additionally, you will be responsible for fostering a culture of collaboration, continuous improvement, and customer focus within the analytics team. You will interact with team members located in various regions across the globe. We are looking for someone who is very strong at MS Excel, possesses automation, good communication skills, and has keen attention to detail. We will provide the necessary training to support your development in this role. Exposure to advanced analytics tools, data visualization techniques, and predictive modeling is a definite plus.

How You'll Make An Impact

Responsibilities :

• Data Verification : Review and verify data submissions from clients to ensure accuracy and completeness. Identify and resolve any discrepancies or errors in the data.
• Client Interaction : Communicate effectively with clients to follow up on data submissions, clarify any issues, and ensure timely and accurate data delivery.
• End-to-End Data Management : Acquire and scrape structured / unstructured data using Python, SQL, and automation tools, ensuring compliance with data policies. Clean and transform datasets using Python (Pandas), SQL, and Excel for analysis readiness. Integrate data from enterprise platforms like Salesforce and EPIC to enable comprehensive reporting. Development and Maintain - VBA macros, worked on large data set.
• Database Management : Assist in the maintenance and updating of databases to ensure data integrity and accessibility. Write complex SQL queries to extract, transform, and load data from multiple sources. Ensure data integrity and accuracy across reporting platforms.
• Data Visualization & Reporting : Create interactive dashboards and reports using Power BI and Excel to support data-driven decisions. Automate recurring reports with Python, VBA, and Macros to improve efficiency and reduce manual effort.
• Stakeholder Collaboration : Partner with cross-functional teams to understand reporting needs and deliver tailored solutions. Present insights and recommendations to senior leadership in a clear, compelling manner.
• Advanced Analytics & Insights : Analyze complex datasets to uncover trends and insights that inform business strategy. Build dynamic dashboards using Power BI with advanced DAX formulas and MS Excel. Apply statistical modeling and forecasting using Python and SQL to support data-driven decisions across business units.
• Process Improvement : Identify opportunities to streamline reporting processes and reduce manual effort. Lead initiatives to improve data quality and governance
• Training and Development : Participate in training sessions to enhance skills in data analytics tools and methodologies.
• Documentation : Maintain comprehensive documentation of data processes and procedures to ensure consistency and transparency.
• Tool Integration & Workflow Automation : Integrate data from Salesforce, EPIC, and other enterprise systems. Build scalable solutions for data ingestion and transformation using Python and Excel automation.

COMPETENCIES (OPTIONAL)

About You

Qualifications :

Minimum Required Degree : Bachelor's degree in a relevant field such as Data Science, Statistics, Mathematics, Computer Science, Information Technology, or a related discipline.

Preferred Degree : Master's degree in data science, Statistics, Business Analytics, Computer Science, or a related field. Advanced degrees can provide deeper expertise and a competitive edge in the field.

Certificate(s) / Special Training :

Experience (Career Level Guide)

Knowledge :

Skills :

Ability :

Additional Information

Compensation and benefits

On top of a competitive salary, great teams and exciting career opportunities, we also offer a wide range of benefits.

Below are the minimum core benefits you'll get, depending on your job level, these benefits may improve :

Other benefits include :

We value inclusion and diversity

Inclusion and diversity (I&D) is a core part of our business, and it's embedded into the fabric of our organization. For more than 95 years, Gallagher has led with a commitment to sustainability and to support the communities where we live and work.

Gallagher embraces our employees' diverse identities, experiences and talents, allowing us to better serve our clients and communities. We see inclusion as a conscious commitment and diversity as a vital strength. By embracing diversity in all its forms, we live out The Gallagher Way to its fullest.

Equal employment opportunity will be extended in all aspects of the employer-employee relationship, including, but not limited to, recruitment, hiring, training, promotion, transfer, demotion, compensation, benefits, layoff, and termination.

Skills Required

Ms Excel, Automation Tools, Predictive Modeling, Data Cleaning, Data Management, Power Bi, Vba, Data Visualization, Sql, Python