Data Analyst

This role will be permanent with NAM info and deploy to client location Hyderabad & Pune.

Work Mode: WORK FROM OFFICE

Role Descriptions:

• Perform detailed data analysis and support business decision-making
• Gather and document business requirements and translate them into technical specifications
• Work closely with stakeholders to define data needs and reporting requirements
• Create user stories, functional specifications, and support UAT activities
• Ensure alignment between business objectives and data solutions

Required Skills:

• Strong expertise in SQL and data querying
• Proven experience in data analysis, requirement gathering, and stakeholder management
• Ability to translate business requirements into technical solutions and user stories
• Good understanding of data models, reporting, and analytics concepts

Skills: Business Analysis~ORACLE SQL

Locations: ~HYDERABAD~PUNE~

Desire candidate

• Candidate should have valid PF.

We're hiring a Data Analyst to turn raw data into clear, actionable insight. You'll partner with product, sales, marketing, and operations teams to answer their most important questions with data — building dashboards, running deep-dive analyses, and defining the metrics the business runs on. The ideal candidate is fluent in SQL, comfortable wrangling messy datasets, and just as strong at telling the story behind the numbers as they are at producing them. You'll own the accuracy and trustworthiness of the reporting stakeholders rely on to make decisions.

Key Responsibilities

• Design, build, and maintain dashboards and recurring reports across business functions
• Write and optimize SQL queries to extract, join, and transform data from multiple sources
• Run ad-hoc and deep-dive analyses to answer specific business questions
• Define, document, and standardize metrics and KPIs alongside stakeholders
• Investigate data-quality issues and ensure the numbers people see are accurate
• Translate analysis into clear recommendations and present them to non-technical audiences
• Support experimentation and A/B test analysis where relevant
• Automate repetitive reporting to free up time for higher-value analysis

Requirements

• 3+ years in a data analyst or business-intelligence role
• Strong SQL and hands-on experience with Power BI and/or Tableau
• Working knowledge of Python (pandas/numpy) for analysis
• Solid grounding in statistics and analytical methods
• Advanced Excel and strong data-visualization / storytelling skills
• Ability to work independently with stakeholders across functions

Nice to have

• Experience with cloud data warehouses (BigQuery, Snowflake, Redshift)
• Exposure to dbt or other ETL/transformation tooling

Strong Data Analyst Profile with advanced Excel and SQL expertise

2

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

3

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

4

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

5

Mandatory (Tech skill 3): Must be able to automate routine tasks using Python (for automation purposes)

6

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

7

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)

8

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.

9

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

10

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

We are looking for a detail-oriented and analytical Data Analyst to join our team. The ideal candidate will be responsible for collecting, analyzing, and interpreting data to identify trends, generate insights, and support business decision-making.

The candidate should be comfortable working with large datasets, creating reports and dashboards, and communicating findings clearly to business stakeholders.

Key Responsibilities

• Collect, clean, organize, and analyze data from multiple sources.
• Identify trends, patterns, anomalies, and business opportunities from data.
• Create dashboards, reports, and visualizations for business teams.
• Track and report key performance indicators (KPIs).
• Perform ad-hoc analysis to support business and management decisions.
• Develop and maintain automated reports where possible.
• Work with stakeholders to understand reporting and analytical requirements.
• Ensure data accuracy, consistency, and quality.
• Present analytical findings in a clear and actionable manner.
• Maintain documentation for reports, dashboards, and data processes.

Position title: Business Intelligence and Data Analyst

Summary -

• Operate and continuously improve the CARS/BI backend within the global Enterprise Data and Business Intelligence platform, ensuring system stability, continuous data loading, and Warehouse the timely delivery of business-critical reports.

• Own the underlying data foundation — SQL pipelines, relational data models, and data warehouse structures — that internal reporting teams and global Data Management initiatives depend on, and act as 1st and 2nd level support for internal customers such as SCM and Sales.

• The role is needed to secure daily BI availability in the Asian time zone, reduce the risk of late or incorrect reporting, and add dedicated database and ETL capacity to the global BI team, including support to the Data Centre team on infrastructure-related issues.

Responsibilities:

• Operate, monitor, and maintain the CARS/BI data integration and data processing workflows, ensuring continuous data loading and stable daily business operations.

• Provide 1st and 2nd level support for CARS/BI, including user support, incident handling, and root-cause analysis of data issues.

• Develop, maintain, and optimise SQL-based data pipelines and transformations within the Enterprise Data Warehouse.

• Design and maintain relational data models and data warehouse structures for CARS BI.

• Integrate data from ERP and other enterprise systems into the BI backend.

• Ensure data consistency, integrity, and performance at the database level, including query tuning and database efficiency improvements.

• Administer the BI technical environment and contribute to its continuous enhancement as part of a global team.

• Support reporting teams by providing structured, reliable datasets and safeguarding the timely delivery of business-critical reports.

• Contribute to global Data Management initiatives, with a focus on Master Data Management and the development of a Common Data Model within the Business Integration Platform.

• Collaborate with the Data Centre team to resolve infrastructure-related issues affecting BI availability.

Education and Experience:

Bachelor's degree in Engineering (BE/B.Tech) or equivalent in Computer Science, Information Technology, or a comparable technical field.

Minimum 3 years of relevant professional experience in Business Intelligence, data warehousing, or database development, including hands-on SQL and ETL work in an enterprise environment.

Experience supporting business users in a global or multi-time-zone IT organisation is an advantage.

Competencies:

• Knowledge about either BI platforms (e.g. IBM Cognos BI suite) or ETL tools (e.g. Informatica PowerCenter)

• Database, data modeling and SQL (preferred Oracle PLSQL)

• Good analytical and communication skills

• Teamplayer

• English

• Strong hands-on experience with SQL (advanced level)

• Solid understanding of relational databases and data warehouse concepts

• Experience with ETL tools and database technologies (e.g., Oracle, SQL Server, SAP BW,Informatica or similar)

• Performance tuning and query optimization skills

• Structured, detail-oriented, and quality-focused working style

• Good understanding of enterprise data flows (SAP/CARS is a plus)

Key Interfaces and Stakeholders:

Only internal customers with different topics: e.g. SCM, Sales etc.

Geography to cover and Travel requirements:

Asian Time Zone, Sometimes travel is required

Behavioral Characteristics

Reliability and accountability — the role safeguards daily reporting availability, so dependable ownership of monitoring and issue follow-up is expected. Structured, analytical problem solving with the patience for thorough root-cause analysis. Service orientation and clear communication towards internal customers such as SCM and Sales. Initiative taking and self-reliance, given largely independent work in the Asian time zone. Cooperation and team spirit within a globally distributed BI team across cultures and time zones. Flexibility and resilience under time pressure, including occasional off-hours support during critical data loads. Integrity and discretion when handling confidential business data. Quality focus and attention to detail, with a continuous improvement mindset.

Interview process

2 rounds - Virtual interview and 1 round Face to Face

Any other Criteria

• Notice Period: Below 60 or 90 Days . No Negotiation on Notice Period
• Gender: Female and Male; Female preferred
• Qualification:Bachelor's degree in Engineering (BE/B.Tech) or equivalent in Computer Science, Information Technology,