Data Analytics

Naukri E-hire; Pune District; On-site; INR 700,000 - 1,100,000; Full time

Job summary

Naukri E-hire in Pune, Maharashtra, seeks a data analytics professional to extract, cleanse, and model data from data lakes, warehouses, and APIs, building automated dashboards for company stakeholders.

You will use SQL across PostgreSQL/MySQL/BigQuery/Snowflake, Python or R for analysis, and BI tools like Tableau, Power BI, or Looker to empower decision-makers.

Strong attention to data quality and ability to translate metrics into actionable insights is essential for success in this role.

Qualifications

• Proficient in BI dashboard creation using Tableau, Power BI or Looker.
• Strong Excel skills including Power Query and pivot tables.
• Deep SQL proficiency for complex data retrieval.
• Experience with Python (Pandas) or R for data analysis.

Responsibilities

• Write complex SQL queries to pull data from data lakes, warehouses and APIs.
• Audit raw data pipelines to eliminate duplicates, resolve missing entries, and fix formatting before processing.
• Develop, refresh and maintain automated dashboards for stakeholders.
• Run diagnostic analysis to identify trends and evaluate KPIs.

Skills

Tableau

Power BI

Looker

Advanced Excel

SQL

Python

R

Tools

PostgreSQL

MySQL

BigQuery

Snowflake

Job description

Core Responsibilities

• Data Extraction & Ingestion: Write complex SQL queries to pull primary data from internal data lakes, warehouses, and secondary third-party APIs.
• Data Cleansing & Validation: Audit raw data pipelines to eliminate duplicates, resolve missing entries, and fix broken formatting before processing.
• Dashboard Design & Reporting: Develop, refresh, and maintain automated, self-serve visualization dashboards for company stakeholders.
• Trend & Statistical Analysis: Run diagnostic analysis using Python or R to identify historical trends, interpret KPIs, and evaluate business performance variances.

Required Technical Skills & Toolsets

An ideal candidate must be highly proficient across several distinct layers of the modern data stack:

• Business Intelligence (BI): Mastery of interactive dashboard creation using Tableau, Power BI, or Looker.
• Core Analytics: Strong foundational knowledge of Advanced Excel (Index/Match, Power Query, pivot tables).
• Database Management: Deep proficiency in SQL (PostgreSQL, MySQL, BigQuery, or Snowflake) for complex data retrieval.
• Programming Languages: Hands-on experience executing data manipulation workflows via Python (Pandas, NumPy) or R.

Soft Skills and Traits

• Critical Thinking: Asking the right questions of data rather than simply running queries.
• Problem-Solving: The capacity to look at messy data systems, track errors, and restructure pipelines logically.

Communication

Explaining why a metric dropped or spiked without overloading stakeholders with unnecessary technical jargon