Consultant

Location: Pune, India

Experience: 4 - 7 years

Role: Data Analyst

About the Role

We are looking for an experienced Data Analyst to join our dynamic team in Bangalore. The ideal candidate will have strong expertise in Python, SQL, and data manipulation libraries like NumPy and Pandas. You will work with large datasets, extract insights, and perform data analysis to support decision-making processes across various business functions. This role requires both technical and analytical skills, along with a passion for turning data into actionable insights.

Key Responsibilities

• Data Extraction & Transformation: Write efficient SQL queries to extract, transform, and load (ETL) data from multiple sources to analyze large datasets.
• Data Cleaning & Preprocessing: Use Python libraries (Pandas, NumPy) to clean, preprocess, and manipulate data for further analysis.
• Data Analysis & Insights: Perform descriptive and exploratory data analysis to identify trends, patterns, and key insights.
• Statistical Analysis: Apply statistical methods to test hypotheses, perform A/B testing, and generate reports on data-driven findings.
• Reporting & Visualization: Create insightful reports and data visualizations using Python libraries like Matplotlib, Seaborn, or external tools like Power BI/Tableau to communicate complex data insights to non-technical stakeholders.
• Automation & Scripting: Automate repetitive data processes and reporting tasks using Python.
• Collaboration: Work closely with cross-functional teams (Product, Marketing, Finance, etc.) to understand data needs and provide actionable insights.
• Documentation & Best Practices: Maintain detailed documentation of data processes, methodologies, and analysis workflows, ensuring clarity and consistency in reporting.
• Performance Optimization: Continuously improve the efficiency of queries, scripts, and data processing pipelines to handle increasing data volumes.

Key Skills & Qualifications

• Technical Skills:
• Python: Strong hands-on experience with Python programming for data analysis (Pandas, NumPy, Matplotlib, Seaborn).
• SQL: Advanced knowledge of SQL for querying, data extraction, and transformation. Experience working with relational databases like MySQL, PostgreSQL, or MS SQL Server.
• Data Analysis Libraries: Expertise in using Pandas and NumPy for data manipulation, cleaning, and analysis.
• Data Visualization: Ability to create visual representations of data using libraries like Matplotlib, Seaborn, or external tools such as Tableau, Power BI, etc.
• Statistical Knowledge: Understanding of core statistical concepts (mean, median, standard deviation, correlation, regression analysis, etc.).
• Experience:
• 4 - 7 years of experience working in a data analysis or business intelligence role.
• Proven experience in transforming large datasets into actionable insights and delivering business value.
• Hands-on experience in designing and optimizing ETL processes.
• Additional Skills:
• Strong problem-solving skills and a detail-oriented mindset.
• Ability to work with minimal supervision, be self-driven, and prioritize tasks effectively.
• Good communication skills to translate complex data into actionable business insights.
• Experience in working with big data tools or cloud platforms (AWS, GCP, etc.) is a plus.

Preferred Qualifications

• Bachelor’s or Master’s degree in a relevant field (e.g., Computer Science, Engineering, Mathematics, Economics, or similar).
• Familiarity with machine learning algorithms and tools is a plus.
• Experience working in an Agile environment or familiarity with Agile methodologies.

Why Join Us?

• Work in a fast-paced, dynamic environment with a collaborative team.
• Opportunity to work on challenging projects and make a direct impact on the business.
• Competitive salary and benefits package.
• Continuous learning and growth opportunities.