Sales Operations - Data Analyst

About CleanHarbors:

Clean Harbors Inc. (www.cleanharbors.com) 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 company’s 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 23,000 employees and has over 750 service locations across the U.S., Canada and Mexico. Beyond addressing the environmental needs of its more than 300,000 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 Company’s 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)