Data Analyst

Contactx Resource Management; Gurugram District, Bengaluru; On-site; INR 600,000 - 900,000; Full time

Job summary

Contactx Resource Management is seeking a skilled Data Analyst to drive data-driven decisions. The role focuses on SQL-based data extraction, Python-powered data transformation, and creating insightful Power BI dashboards and reports.

You will develop data models, implement DAX measures, and validate data across multiple sources to ensure accuracy and reliability of KPIs and insights.

Qualifications

• Proficient in SQL for data extraction from relational databases.
• Strong Python skills (Pandas/NumPy) for data transformation.
• Experience building dashboards and reports in Power BI.
• Ability to develop data models and establish relationships between sources.
• Adept at data validation and QA to ensure data accuracy.

Responsibilities

• Extract, transform, and analyze data using SQL from relational databases.
• Write complex SQL queries with JOINs, subqueries, CTEs, window functions, and stored procedures.
• Clean, transform, and analyze datasets using Python (Pandas/NumPy).
• Perform exploratory data analysis to identify trends and opportunities.
• Build interactive Power BI dashboards and reports with DAX measures.

Skills

SQL

Python

Power BI

Pandas

NumPy

DAX

Job description

Job Summary

We are looking for a skilled Data Analyst with strong hands-on experience in SQL, Python, and Power BI. The candidate will be responsible for analyzing business data, developing dashboards and reports, identifying trends, and providing actionable insights to support data-driven decision-making.

Key Responsibilities

• Extract, transform, and analyze data using SQL from relational databases.
• Write complex SQL queries involving JOINs, subqueries, CTEs, window functions, aggregations, and stored procedures.
• Clean, transform, and analyze datasets using Python, primarily with Pandas and NumPy.
• Perform exploratory data analysis (EDA) and identify trends, patterns, anomalies, and business opportunities.
• Build interactive and visually compelling Power BI dashboards and reports.
• Create and optimize DAX measures and calculated columns in Power BI.
• Develop data models and establish relationships between multiple data sources.
• Perform data validation and quality checks to ensure accuracy and consistency.
• Automate repetitive data-processing and reporting tasks using Python.
• Monitor and report business KPIs and performance metrics.