Data Analyst

Pineswift Technologies; Gurugram District; On-site; INR 500,000 - 800,000; Full time

Job summary

Pineswift Technologies in Gurugram invites applications for a Data and Business Analyst. You will develop SQL queries, build dashboards in Excel, and translate business needs into data solutions.

You will validate data, cleanse datasets, and support ad-hoc analyses using MS Office and SQL; Python is a plus. Excellent communication and documentation skills are essential for collaboration with stakeholders.

Qualifications

• Degree in CS, IS, BA, or related field.
• Proficiency in Advanced SQL.
• Advanced Excel skills (formulas, PivotTables, VBA).
• Knowledge of MS Office Suite (Word, PowerPoint, Outlook).
• Excellent analytical and problem-solving skills.
• Strong communication and documentation abilities.
• Python is a plus.

Responsibilities

• Develop and maintain SQL queries to extract, transform data from various sources.
• Create and automate reports and dashboards using Excel (Pivot Tables, VBA/macros).
• Collaborate with stakeholders to translate business requirements into data solutions.
• Perform data validation, cleansing, and reconciliation to ensure accuracy and consistency.
• Support ad-hoc analysis and reporting needs using MS Office & SQL tools.
• Document processes, data definitions, and reporting standards.

Skills

Advanced SQL

Advanced Excel

Python

Communication

Documentation

Education

Degree in CS/IS/BA or related

Tools

MS Office Suite

Excel VBA

Job description

Hi

Greetings from Pineswift Technologies!!

We are hiring a Data and Business Analyst for Gurugram Location. Below are the details.

Roles And Responsibilities

• Develop and maintain SQL queries to extract, transform from various sources.
• Create and automate reports and dashboards using Excel (Pivot Tables, VBA/macros).
• Collaborate with stakeholders to understand business requirements and translate them into data solutions.
• Perform data validation, cleansing, and reconciliation to ensure accuracy and consistency.
• Support ad-hoc analysis and reporting needs using MS Suite & SQL tools.
• Document processes, data definitions, and reporting standards.

Qualifications

• Degree in Computer Science, Information Systems, Business Analytics, or related field.
• Proficiency in Advance SQL.
• Advanced Excel skills (formulas, pivot tables, VBA).
• Knowledge of Microsoft Office Suite (Word, PowerPoint, Outlook).
• Excellent analytical and problem-solving skills.
• Strong communication and documentation abilities.
• Additional skill of Python is plus.