Lead Data Analyst - SQL/Python in Pune, India

We are seeking an experienced Lead Data Analyst to work on large-scale Energy & Utilities datasets. The ideal candidate will be responsible for analyzing tariff and pricing data, building data models, automating workflows, and delivering actionable insights to support business decisions.Role: Lead Data AnalystExperience: 6+ YearsLocation: Pune (WFO)Key Responsibilities:- Analyze complex datasets related to utility tariffs, rates, billing, and energy consumption.- Validate, cleanse, and transform data from multiple sources.- Develop and maintain data models and analytical reports.- Perform advanced analysis using Excel, SQL, and Python.- Build dashboards and visualizations for business stakeholders.- Automate repetitive processes and improve data workflows.- Identify trends, patterns, and anomalies in datasets.- Collaborate with cross-functional and global teams to deliver business solutions.- Mentor junior analysts and ensure timely project https://jobeax.com/link/SxaWoIptPtnP4xy1 Skills:- 6 to 10 years of experience in Data Analysis / Data Analytics.- Strong proficiency in SQL, Excel (Pivot Tables, Advanced Functions), and Python.- Experience in data modeling, reporting, and dashboarding.- Strong analytical and problem-solving skills.- Ability to work with large and complex datasets.- Excellent communication and stakeholder management https://jobeax.com/link/Cexs453KRiH2S1rJ Skills:- Experience in Energy, Utilities, Electricity, Gas, or Renewable Energy domains.- Exposure to Tariff Analysis, Pricing Models, Billing, or Forecasting.- Knowledge of Excel Macros, Power Query, or Python Automation.- Familiarity with Agile methodologies. (ref:hirist.tech)