Tariff Modeling Lead / Senior Analyst

About the job

Job Title : Tariff Modeling Lead / Senior Analyst Hiring Location : Pune (Hybrid) Job Description : Utility (electricity, gas… etc.) Tariff Analyst is responsible for creating, testing, and maintaining precise and accurate calculation models of utility tariff that guide billing and analysis for utility customers using proprietary tools. These Models will form the core of the end products, hence must be precise & Accurate. To achieve this Utility Tariff Analysts must be detail-focused, willing to work hard & quickly learn new tools & knowledge. The role requires a knowledge of database concepts and provides an opportunity to drive positive energy consumption habits and catalyze a clean energy future. Responsibilities • Understand complex utility tariffs, rates, and programs, converts them into a model, and maintains/updates it based on additional requirements. • Responsible for Communicating & Co-ordinating with the Delivery team. • Assist delivery team in validating the input data received from client for modelling work. • Work with Cross functional teams to resolve issues related to Tariff logic in internal tools & external Products. • Participates in sprint planning & other ceremonies, passionately works towards fulfilling the committed sprint goals. • Perform Validation & Regression testing on products & follow Change management process while releasing the tariff model updates to higher environments. • Monitor the shadow bills match rate against actual bills, investigate the root cause if it falls outside acceptable limits, and resolve the issue accordingly. • Participates in generating impactful ideas and implementing effective automations and efficiency improvement initiatives to reduce time consumption and the error-prone nature of labor-intensive manual tasks. • Share Knowledge & Provide expertise on modelling system, tariffs and existing models and processes to team members. • Continuous creation and maintenance of documentation for requirements, enhancements, and developed processes. Required Qualifications (Must Have) : • Overall Industry experience 4+ years • Education in any field or supported by relevant Data Analytics certification or relevant experience • Proficient with Advanced Microsoft Excel functions and pivot tables. • Understanding of relational database concepts and Experience working with SQL Queries. • Familiarity with writing programs using Python or Shell scripts. • Good Analytical & Logical skills. • Demonstrable aptitude for Innovation & Problem solving. • Good communication skills & ability to work across Cross-functional teams. Preferred Qualifications (Good to Have): • Experience in Energy Industry & familiar with basic concepts of Utility (electrical/gas...) tariffs • Experience & Knowledge with tools like; Microsoft Excel macros, Power query • Passionate about working with data and data analyses. • 1+ year experience in Agile SCRUM methodology.

Requirements

• SQL
• Python
• Data Analysis
• Microsoft Excel

Qualifications

• 4+ years of experience
• Proficient with Advanced Microsoft Excel functions

Preferred Technologies

• SQL
• Python
• Data Analysis
• Microsoft Excel