Role description
UST Title: Lead II - Data Science
Location: Pune, India (Hybrid)
Job Summary
UST is looking for a highly analytical and detail-oriented Data Analyst. The Data Analyst will be responsible for creating, testing, maintaining, and enhancing accurate utility tariff calculation models that support billing and analytical solutions for utility customers.
Key Responsibilities
- Analyze complex utility tariffs, rates, and energy programs and convert them into accurate calculation models.
- Maintain and update tariff models based on business and regulatory changes.
- Ensure high levels of accuracy and consistency in tariff-based calculations used for billing and analytics.
- Own end-to-end delivery of tariff modeling engagements and ensure timely completion of assigned deliverables.
- Coordinate and communicate effectively with delivery teams and stakeholders.
- Support delivery teams in validating client data used for tariff modeling.
- Work with product, engineering, operations, and business teams to resolve tariff logic issues within internal tools and customer-facing products.
- Address discrepancies between shadow bills and actual utility bills and drive resolution.
- Lead sprint ceremonies and support Agile Scrum practices.
- Mentor team members and promote a collaborative, high-performance culture.
- Ensure team alignment toward sprint commitments and delivery goals.
- Share knowledge and best practices to develop analysts within the team.
- Ensure comprehensive validation and regression testing of tariff models and products.
- Adhere to change management processes before releasing updates to higher environments.
- Maintain accuracy, compliance, and quality standards throughout the modeling lifecycle.
- Identify opportunities for automation and process optimization.
- Design and implement solutions that reduce manual effort, improve accuracy, and enhance productivity.
- Drive continuous improvement initiatives across delivery and operational processes.
- Create and maintain detailed documentation for requirements, tariff logic, enhancements, and workflows.
- Ensure process knowledge and project documentation remain current and accessible.
Required Qualifications (Must Have)
- 6-8 years of overall industry experience.
- Proven experience leading and mentoring teams.
- Bachelor's Degree in Engineering, Statistics, Mathematics, Computer Science, Data Analytics, or other analytical disciplines.
- Strong proficiency in Advanced Microsoft Excel, including:
- Pivot Tables
- Advanced formulas
- Data analysis functions
- Strong understanding of relational database concepts.
- Hands-on experience writing and optimizing SQL queries.
- Experience developing solutions using Python and/or Shell Scripting.
- Strong analytical and logical problem-solving skills.
- Demonstrated innovation and continuous improvement mindset.
- Excellent communication and stakeholder management skills.
- Ability to collaborate effectively across cross-functional teams.
Preferred Qualifications (Good to Have)
- Experience in the Energy & Utilities industry.
- Understanding of utility tariffs related to electricity, gas, or other regulated energy sectors.
- Experience working with:
- Excel Macros (VBA)
- Power Query
- Data automation tools
- Passion for data analysis and deriving insights from large datasets.
- Experience working in Agile Scrum environments.
- Exposure to utility billing, energy analytics, or energy management platforms.
Technical Skills
- Python
- SQL
- Advanced Microsoft Excel
- Data Analytics
- Data Analysis
- Relational Databases
- Shell Scripting
- Power Query
- Excel VBA / Macros
- Agile Scrum
- Utility Tariff Modeling
- Energy Analytics
Soft Skills
- Leadership & Team Management
- Analytical Thinking
- Problem Solving
- Stakeholder Management
- Communication Skills
- Innovation & Continuous Improvement
- Attention to Detail
- Collaboration & Teamwork
Skills
Data Science,python,data analytics,microsoft excel,sql,
About UST
UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world’s best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients’ organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact—touching billions of lives in the process.