Data Analyst

Peoplefy Infosolutions; Pune District; Hybrid; INR 900,000 - 1,300,000; Full time

Job summary

Peoplefy Infosolutions in Pune, Maharashtra, seeks a Data Reporting Analyst III to support data-driven decision-making through data analysis, reporting, and BI solutions.

The role involves gathering, preparing, analyzing, and interpreting data from multiple sources and developing reporting solutions, working with business and technical stakeholders to understand requirements, build data models, and provide actionable insights.

Qualifications

• Experience in data analytics, reporting or BI development.
• Hands-on SQL querying and data manipulation.
• Experience with Databricks, ETL processes and data pipelines.
• Strong Power BI reporting, dashboards and data models.
• Knowledge of DAX, SQL or R or similar languages.
• Understanding of data modeling and databases.
• Ability to handle large datasets and derive insights.
• Knowledge of data cleansing, validation and consolidation.
• Foundations of statistics and hypothesis testing.
• Strong analytical and problem-solving skills.
• Good communication with technical and non-technical stakeholders.
• Familiarity with relational/multidimensional database concepts.

Responsibilities

• Gather, query, extract, merge and validate data from multiple sources.
• Prepare, clean, consolidate and validate datasets for analysis.
• Develop and maintain Power BI reports, dashboards and visuals.
• Build and maintain Power BI data models and reporting solutions.
• Use SQL and other languages to analyze large datasets.
• Work with Databricks and ETL for data prep and transformation.
• Translate business requirements into reporting and analytics solutions.
• Analyze data to provide actionable business insights.
• Perform data quality checks and troubleshoot issues.
• Prepare reports and presentations to communicate findings.
• Collaborate with technical teams and business stakeholders on reporting initiatives.
• Support end users with documentation, training and reporting assistance.

Skills

Data Analytics

Data Reporting

BI Development

SQL

Databricks

ETL

Power BI

Power BI Data Models

Data Modeling

R language

Data Extraction

Statistics basics

Communication

Relational DB Design

Tools

Databricks

ETL tools

Power BI

Job description

Job Summary

We are looking for a Data Reporting Analyst III to support data-driven decision-making through data analysis, reporting, and Business Intelligence solutions. The role involves gathering, preparing, analyzing, and interpreting data from multiple sources and developing reporting solutions.

The candidate will work with business and technical stakeholders to understand requirements, build data models and reports, ensure data quality, and provide actionable insights to support business decisions.

Must-Have Skills

• Strong experience in Data Analytics, Data Reporting, BI Development, or related fields.
• Strong hands-on experience with SQL for querying and data manipulation.
• Experience with Databricks and ETL processes for data extraction, transformation, and loading.
• Strong experience with Power BI reporting and visualization.
• Experience working with and creating Power BI Data Models.
• Knowledge of DAX, SQL, R, or similar statistical/data programming languages.
• Strong understanding of data modeling and database concepts.
• Experience working with large datasets and deriving meaningful business insights.
• Knowledge of data extraction, transformation, cleansing, validation, and consolidation.
• Foundational knowledge of statistical concepts such as regression, distributions, and statistical tests.
• Strong analytical and problem-solving skills.
• Good communication skills with both technical and non-technical stakeholders.
• Understanding of relational and multidimensional database design.

Key Responsibilities

• Gather, query, extract, merge, and validate data from multiple sources.
• Prepare, clean, consolidate, and validate datasets for analytical activities.
• Develop and maintain Power BI reports, dashboards, and visualizations.
• Build and maintain Power BI data models and reporting solutions.
• Use SQL and other analytical languages to manipulate and analyze large datasets.
• Work with Databricks and ETL processes for data preparation and transformation.
• Translate business requirements into reporting and analytics solutions.
• Analyze data and provide actionable insights to support business decisions.
• Perform data quality checks and troubleshoot data/reporting issues.
• Prepare reports and presentations to communicate analytical findings.
• Collaborate with technical teams and business stakeholders on reporting initiatives.
• Support end users through documentation, training, and reporting assistance.