Roles & Responsibilities

● Understands complex utility tariffs, rates and programs and converts these into a model.

● Responsible for analysis of the energy utilization data for cost and usage patterns and derive meaningful patterns

● Responsible for Maintaining the tariff models with timely updates for price, logic or other enhancements as per client requirement.

● Assist delivery team in validating the input data received from client for modelling work.

● Responsible for Communicating & Co-ordinating with Delivery team

● Work with Cross functional teams to resolve issues in the Modelling tool.

● Build and deliver compelling demonstrations/visualizations of products

● Be a lifelong learner and develop your skills continuously

● Contribute to the success of a rapidly growing and evolving organization

Ideal Candidate

Robust Data Analyst Profile with advanced Excel and SQL expertise

Mandatory (Experience 1): Must have 4+ years of overall experience as a hands-on Data Analyst

Mandatory (Tech skill 1): Must be highly proficient in advanced Excel — complex functions, macros, calculations, and pivots

Mandatory (Tech skill 2): Must have strong hands-on SQL and a good understanding of relational database concepts

Mandatory (Tech skill 3):



Must be able to automate routine tasks using Python (for automation purposes)

Mandatory (Skill 1): Must have exceptional analytical, problem-solving, and logical skills, with strong attention to detail and accuracy

Mandatory (Skill 2): Must be able to understand complex data and business logic and convert it into a model (the role models complex utility tariffs, rates, and programs)

Mandatory (Communication): Must have strong verbal and written communication, able to work independently with India- and US-based team members and articulate problems and solutions over calls and email.

Mandatory (Location): Must be based locally in Pune (or the nearby Maharashtra belt — Mumbai, Nagpur), as the final round is in person

Preferred (Domain): Experience in the Energy/Utility industry and familiarity with basic utility (electrical/gas) tariff concepts.

Preferred (Tools): Excel macros; Python or shell scripting; 1+ year of Agile methodology experience.

Pay: ₹551,865.59 - ₹1,500,000.00 per year

Application Question(s)

- Are you ok for a F2F final round?
- What is your notice period in days? (30)
- What is your current CTC in LPA?
- What is your expected CTC in LPA? (15)

Experience:
- overall: 4 years (Required)

Work Location: Hybrid remote in Pune, Maharashtra

📌 Sr Data Analyst (Tariff Data) (Pune)
🏢 OptimHire
📍 Pune