Lead Data Analyst - SQL/Python

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 Analyst

Experience: 6+ Years

Location: 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 delivery.

Required 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 skills.

Preferred 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.