Sales Operations Data Analyst

Bengaluru - India

Monthly Salary: Not Disclosed

Posted on: 30+ days ago

Vacancies: 1 Vacancy

Job Summary

Description

About CleanHarbors:

Clean Harbors Inc. () is a NYSE listed US based $6.5 billion company. Clean Harbors was founded in 1980 near Boston by Mr. Alan S. McKim who today remains the companys Chairman and CTO.

Everywhere industry meets environment Clean Harbors is on-site providing premier environmental energy and industrial services. Clean Harbors employs a dedicated workforce of 23000 employees and has over 750 service locations across the U.S. Canada and Mexico. Beyond addressing the environmental needs of its more than 300000 customers the Company has been on the front lines of addressing some of the largest emergency response events in North America of the past several decades including the BP Oil Spill in the Gulf of Mexico the anthrax attacks in New York the 2015 avian flu outbreak that devastated the poultry industry Hurricanes Katrina Rita and Sandy and the oil pipeline breaks that affected the Yellowstone and Kalamazoo rivers along with other major chemical releases into the environment.

Clean Harbors India has been strategically established as the Global Capability Center (GCC) to serve our parent company. We take pride in serving some of the most tech savvy business stakeholders at Clean Harbors. The GCC employees form part of our globally integrated teams that provide cutting-edge IT solutions and production support across platforms. Our shared services teams work seamlessly with their global counterparts in providing critical 24x7 support in various functions including Finance HR Procurement IT and Operations. Our aggressive growth plans open significant career advancement opportunities for our employees.

Job Title:Analyst Sales Operations

Experience: 8 Years
Location: Hebbal Bengaluru
Working Hours: 3:00 PM 12:00 AM IST (Cab provided both ways)

Must have Skills: Advanced Excel Power BI SQL VBA Coding Excel Macros Sales Forecasting Sales Budgeting Sales pipeline management Sales Dashboard creations.

Role Brief:

Work collaboratively with the Sales Operations Inside Sales and Sales teams onshore to improve salesforce efficiency and effectiveness. The key responsibility will entail effective & efficient delivery of sales processes and performing analysis on sales and sales related data

Responsibilities

The primary objective of the position is standardizing ad-hoc Sales reports i.e. converting as many ad-hoc reports into standard reports through a pre-defined standardization methodology. (Ad-hoc reports can be across different processes in the sales operations organization) enable process/report transformation through high end automation
Provide value added insights to the Sales team through ad hoc analysis & data deep dives
Develop a detailed understanding of Sales processes and pipeline
Monthly/Quarterly/ Yearly Sales Target Setting adaptation & tracking
Resolve Sales queries/appeals related to Targets & Variable compensation
Stakeholder management
Identify training to improve self issue & escalation management
Identify business opportunities & process gaps
Develop a detailed understanding of the Companys Sales Budgeting system and processes
Delivery of Ad-hoc Reports for US Ticket Entry & Log Assessment Automation using VBA & SQL queries
Build new and transform existing reports in Power BI / Tableau/ Qlik / Similar BI tools end to end
Working knowledge of SFDC Reporting

Qualifications

Highly Proficient in using applications like Word Excel and PowerPoint etc.
Attention to detail and able to maintain confidentiality
Prior experience in developing complex dashboards using Power BI/ Tableau/ Macros & VBA
Running & building SQL queries to extract the relevant data required for reporting
Experience in liaising with multiple stakeholders & Change Management

Experience:

8 years of professional experience with at least 2 years using SQL and Power BI
Prior experience in developing complex dashboards using Power BI
Running & building SQL queries to extract the relevant data required for reporting
Experience in liaising with multiple stakeholders & change management
Fluent English (speaking reading and writing)
Proficient in MS Office Suite especially Advanced MS Excel (Pivots calculated fields Conditional formatting charts dropdown lists etc.)
Proficient in MS SQL (Advanced)
Proficient in VBA Coding Excel Macros (Advanced)

Academic Background:

Graduation in Technical Education/ Business (BE MBA Programming certification)

Required Experience:

DescriptionAbout CleanHarbors:Clean Harbors Inc. () is a NYSE listed US based $6.5 billion company. Clean Harbors was founded in 1980 near Boston by Mr. Alan S. McKim who today remains the companys Chairman and CTO.Everywhere industry meets environment Clean Harbors is on-site providing premier envi...