Data Analytics at Planet Spark · Gurugram · 1 - 3 years · Posted 21 Aug 2024

PlanetSpark is Hiring !!
Title of the Job : Data Analyst ( FULL TIME)
Location : Gurgaon
Roles and Responsibilities/Mission Statement:
We are seeking an experienced Data Analyst to join our dynamic team. The ideal candidate will possess a strong analytical mindset, excellent problem-solving skills, and a passion for uncovering actionable insights from data. As a Data Analyst, you will be responsible for collecting, processing, and analyzing large datasets to help inform business decisions and strategies and will be the source of company wide intelligence
The responsibilities would include :
1) Creating a robust Sales MIS
2) Tracking key metrics of the company
3) Reporting key metrics on a daily basis
4) Sales incentive and teacher payout calculation
5) Tracking and analyzing large volume of consumer data related to customers and teachers
6) Developing intelligence from data from various sources
Ideal Candidate Profile -
- 1-4 years of experience in a data-intensive position at a consumer business or a Big 4 firm
- Excellent ability in advanced excel
- Knowledge of other data analytics tools and software such as SQL, Python, R, Excel, and data visualization tools will be good to have.
- Detail-oriented with strong organizational skills and the ability to manage multiple projects simultaneously.
- Exceptional analytical ability
- Detail-oriented with strong organizational skills and the ability to manage multiple projects simultaneously.
Eligibility Criteria:
- Willing to work 5 Days a week from office and Saturday - work from home
- Willing to work in an early-stage startup .
- Must have 1-3 years of prior experience in a data focused role at a consumer internet or a Big 4
- Must have excellent analytical abilities
- Available to Relocate to Gurgaon
- Candidate Should his own laptop
- Gurgaon based candidate will be given more preference
Join us and leverage your analytical expertise to drive data-driven decisions and contribute to our success. Apply today!

About Planet Spark
About
PlanetSpark is on its journey to becoming the global leader in the large and untapped communication skills segment. We are Series A funded by some top VCs and are on a 30% month-on-month growth curve. We have our footprint in India, the Middle East, North America, and Australia. Come join a passionate team of over 500 young and energetic members and 400+ expert and handpicked teachers on this roller coaster ride to build the most loved brand for kids who will move the world!
Connect with the team
Company social profiles
Similar jobs (6)
About Us
Corporate Web Solutions provides technology-driven solutions involving data analysis, automation, web development, and digital transformation.
Role Overview
As a Data Analyst Intern, you'll assist in analyzing datasets, preparing reports, identifying trends, and exploring AI-assisted analytics workflows.
Key Responsibilities
- Collect and organize data.
- Analyze datasets and identify trends.
- Prepare reports and visualizations.
- Work with Excel, spreadsheets, or analytical tools.
- Assist with dashboards and data-driven insights.
- Explore AI tools for data analysis.
Requirements
- Basic understanding of data analysis.
- Familiarity with Excel or Google Sheets.
- Basic knowledge of SQL or Python is a plus.
- Analytical mindset.
- Good attention to detail.
Perks
- Certificate of Internship
- Flexible work hours
- Mentorship and real project exposure
- Potential for PPO
- Letter of Recommendation
- Performance-Based Stipend available up to ₹18,000/month
About the Role
We are looking for enthusiastic Data Analytics Interns to join our team remotely for a 3-month internship. This is an excellent opportunity to gain hands-on experience in data analysis, data visualization, database management, and reporting. The selected candidates will have the opportunity to work on real projects, analyze datasets, and develop their technical and analytical skills.
Responsibilities
- Assist in collecting, cleaning, organizing, and analyzing datasets.
- Work with SQL and databases for data retrieval, manipulation, and analysis.
- Use Microsoft Excel to organize data, perform calculations, and prepare reports.
- Assist in creating dashboards and visualizations using Power BI or Tableau.
- Work with Python libraries such as Pandas and NumPy for data analysis.
- Perform exploratory data analysis to identify trends, patterns, and insights.
- Prepare reports and presentations based on analytical findings.
- Assist in tracking key performance indicators (KPIs) and monitoring business data.
- Maintain accurate documentation of data analysis activities and project contributions.
- Collaborate with team members on data-related projects and analytical tasks.
Requirements
- Basic knowledge of Data Analytics and data analysis concepts.
- Understanding of SQL and database fundamentals.
- Familiarity with Microsoft Excel and data management.
- Basic knowledge of Python is preferred.
- Familiarity with data visualization tools such as Power BI or Tableau is an advantage.
- Strong analytical and problem-solving skills.
- Good research and organizational abilities.
- Attention to detail and accuracy.
- Ability to work independently in a remote environment.
- Good communication skills and eagerness to learn.
What You'll Gain
- Real-world experience in data analytics and business intelligence.
- Hands-on experience with data cleaning, analysis, and visualization.
- Exposure to industry-relevant tools such as SQL, Python, Excel, and Power BI.
- Mentorship and exposure to practical analytical processes.
- Completion Certificate at the end of the internship.
- Letter of Recommendation based on performance.
- Opportunity to strengthen your portfolio with real-world data projects.
Internship Details
- Duration: 3 months
- Location: Remote (Work from Home)
- Perks: Completion Certificate + Letter of Recommendation

Job Title: Senior Data Analyst
Location: Sharnam Metrolinks, Amraiwadi, Ahmedabad
Working Days: 6 Days a Week
Department: MDO
Reporting To: COO
Employment Type: Full-Time
Job Summary
We are seeking a highly analytical and detail-oriented Senior Data Analyst to lead data management, reporting, automation, and system development initiatives across the organization.
The role focuses on transforming raw data into meaningful insights, designing and implementing automated systems, strengthening data structures, and supporting cross-functional teams with accurate, actionable intelligence to drive strategic and operational business decisions.
Key Responsibilities
1. Data Management & Reporting
● Collect, clean, validate, and consolidate data from multiple internal and external sources.
● Prepare and deliver daily, weekly, and monthly MIS reports for management and departments.
● Design, develop, and maintain dashboards to track KPIs, performance metrics, and operational trends.
2. Database & Data Accuracy Management
● Manage and regularly update internal databases, spreadsheets, and reporting systems.
● Ensure data accuracy, consistency, integrity, and confidentiality across all platforms.
● Implement best practices for data validation, version control, and audit checks.
3. Data Analysis & Business Insights
● Analyze large and complex datasets to identify trends, patterns, gaps, and anomalies.
● Translate data findings into clear, actionable insights and recommendations to support
strategic and operational decision-making.
4. Reporting Automation, System Recommendation & Implementation
● Identify opportunities to replace manual or semi-manual processes with automated, data-driven systems.
● Design and implement automated reporting frameworks, dashboards, and data pipelines using Excel (Power Query, VBA, Macros), SQL, BI tools, and Python.
● Proactively suggest new automation tools, system enhancements, or integrations to
improve efficiency, accuracy, and scalability.
● Lead the end-to-end implementation of approved automation initiatives, including requirement gathering, system design, testing, deployment, and stabilization.
● Continuously monitor and optimize automated systems in line with business growth and evolving data needs.
5. Cross-Functional Coordination & Support
● Collaborate with Sales, HR, Finance, Operations, and other departments to understand
reporting and data requirements.
● Provide support for ad-hoc analysis, custom reports, and special data requests.
● Act as a data partner to department heads for decision support and performance tracking.
6. Documentation & Compliance
● Maintain complete and updated documentation for MIS processes, reports, data models,
automation logic, and system changes.
● Ensure compliance with company data governance policies and applicable data protection standards.
System Development & Data Structuring Responsibilities
● Study and understand departmental workflows to evaluate how data is generated, processed, and utilized.
● Review existing manual and digital data systems to identify operational gaps, risks, and
mprovement opportunities.
● Recommend structured data models, reporting formats, and storage solutions aligned with
business requirements.
● Coordinate with department heads to define data structures, access levels, and reporting
standards.
● Implement new or upgraded data systems (Excel-based models, cloud platforms, ERP
integrations) with minimal operational disruption.
● Design structured data formats and role-based access controls to ensure secure and
organized data management.
● Train employees on newly implemented systems and provide post-implementation
support.
● Monitor system performance, resolve issues, and continuously improve systems based on
user feedback and organizational growth.
Qualifications & Experience
● Bachelor’s degree in Commerce, Statistics, Computer Applications, or a related field.
● 3–5 years of experience in data analytics, reporting, or system automation roles.
● Strong analytical thinking, logical reasoning, and problem-solving abilities.
● High attention to detail with excellent organizational and documentation skills.
Technical Skills (Must Have)
● Advanced Excel: Power Query, Power Pivot, VBA basics, Macros, Charts
● BI Tools: Power BI or Tableau (DAX, data modeling, dashboard optimization)
● Google Apps Script: Automation in Google Sheets, custom functions, triggers, API integrations, workflow optimization
● Vlook
Preferred Skills
● Strong verbal and written communication skills
● Ability to handle sensitive and confidential information responsibly
● Quick learner with a tech-savvy, improvement-driven, and solution-oriented mindset
Strong Data Analyst Profile with Python, SQL, and data-pipeline expertise, ideally with retail / e-commerce datasets
2
Mandatory (Experience 1): Must have 4+ years of hands-on data-analyst experience, working with large datasets across areas such as sales, inventory, pricing, promotions, and customer behaviour.
3
Mandatory (Tech skill 1): Must have strong hands-on Python for data processing, transformation, automation, and analysis
4
Mandatory (Tech skill 2): Must have strong SQL skills, including complex queries, joins, aggregations, and data validation.
5
Mandatory (Tech skill 3): Must have a solid understanding of Data Lake architecture, ingestion, storage, and processing workflows
6
Mandatory (Tech skill 4): Must have hands-on experience with ETL / ELT pipelines, data integration, and transformation
7
Mandatory (Tech skill 5): Must have experience with Azure or GCP data services.
8
Mandatory (Tech skill 6): Must have understanding of or experience with Databricks and distributed data processing.
9
Mandatory (Tech skill 7): Must have knowledge of data modeling, data warehousing, and Lakehouse architecture
10
Mandatory (Tech skill 8): Must have experience with Power BI, Tableau, or Excel for reporting.
11
Mandatory (Communication): Must have strong analytical, documentation, and stakeholder-communication skills.
12
Mandatory (Education): Must hold a Bachelor’s degree in Computer Science, IT, Engineering, or a related field.
13
Mandatory (Note1): This is a 6-month contract role. Candidate must be comfortable with the contract engagement and able to join immediately (urgent — onboarding within ~a week)

Required Qualifications & Skills:
- Bachelor's or Master's degree in Life Sciences, Pharmacy, Biotechnology, Clinical Research, Statistics, Data Science, Computer Science, Engineering, Business or a related field.
- 5–8 years of experience in Clinical Data Analysis, Clinical/R&D Analytics, Data Analysis, Business Analysis, or related roles.
- Proven experience working with Biopharma / Pharmaceutical / Life Sciences clients.
- Strong understanding of Clinical/R&D processes, systems, and data.
- Experience working with or analyzing data from systems such as CTMS, EDC, RIM/Regulatory systems, clinical planning systems, and other R&D platforms.
- Understanding of clinical product hierarchies, study/trial structures, site and subject data, milestones, and related R&D data domains.
- Strong SQL and data analysis capabilities.
- Experience with data quality, validation, reconciliation, data mapping, and root-cause analysis.
- Understanding of data warehousing, BI, reporting, data integration, and analytical data models.
- Strong communication, stakeholder management, documentation, and problem-solving skills.
- Experience working with cross-functional and geographically distributed teams.
- Familiarity with Agile/Scrum and tools such as Jira or Azure DevOps.
Must-Have Skills:
- Biopharma/Life Sciences Client Experience – proven experience working with Biopharma, Pharmaceutical, Biotechnology, Clinical Research, or Life Sciences clients.
- Clinical/R&D Domain Knowledge – strong understanding of clinical development, clinical operations, clinical trials, and R&D processes.
- Clinical/R&D Systems & Data – practical understanding of systems such as CTMS, EDC, RIM, eTMF, Study Startup, and clinical planning/portfolio management systems such as Planisware, along with the data generated and consumed across these systems.
- Clinical Data Structures – understanding of clinical product/asset hierarchies, study/trial structures, sites, subjects, milestones, and relationships between key R&D data domains.
- SQL & Data Analysis – ability to independently query, analyze, validate, reconcile, and troubleshoot complex datasets.
- Data Quality & Validation – experience with data profiling, reconciliation, business-rule validation, issue investigation, and root-cause analysis.
- Data Mapping & Lineage – understanding of source-to-target mapping, data transformations, data definitions, and data lineage across systems.
- Requirements & Analytical Thinking – ability to translate Clinical/R&D business needs into data requirements, business rules, metrics, and analytical specifications.
- Stakeholder Management – ability to work effectively with Clinical/R&D SMEs, business stakeholders, data engineers, architects, and BI teams.
Key Skills:
- Gather, analyze, and translate Clinical/R&D business requirements into data requirements, business rules, metrics, and analytical specifications.
- Analyze clinical and R&D datasets to identify trends, anomalies, inconsistencies, and data- quality issues.
- Understand data across key Clinical/R&D source systems, their relationships, data flows, and downstream analytical use.
- Perform data profiling, reconciliation, validation, source-to-target analysis, and root-cause analysis using SQL and other analytical tools.
- Define and validate clinical/R&D KPIs, metrics, data definitions, and reporting logic.
- Collaborate with Data Engineers, Data Architects, BI Developers, and Clinical/R&D stakeholders to deliver analytics solutions.
- Contribute to analytical datasets, semantic models, data products, and data lineage initiatives.
- Support UAT, test case development, defect investigation, and business sign-off.
- Facilitate workshops and stakeholder discussions to clarify requirements and resolve data-related issues.
- Maintain functional, data, and analytical documentation throughout the delivery lifecycle.
- Support data governance activities including data quality, Critical Data Elements (CDEs), metadata, and lineage.
- Support Agile delivery activities including backlog refinement, user stories, acceptance criteria, and sprint execution.
About VerbaFlo.ai:
VerbaFlo.ai is a fast-growing AI SaaS startup revolutionizing how businesses leverage AI-powered solutions. As a part of our dynamic team, you’ll work alongside industry leaders and visionaries to drive innovation and execution across multiple functions.
Role Overview:
We are seeking a Senior Business Data Analyst with strong experience in analytics, SQL, and dashboarding (preferably Metabase) who can independently lead complex analytical initiatives, translate business problems into scalable data solutions, and mentor junior analysts. This role demands someone who can think strategically, operate with high ownership, and ensure the company runs on accurate, timely, and actionable insights.
Responsibilities:
Strategic & Cross-Functional Ownership
- Partner with leadership (Product, Ops, Growth, Finance) to translate business goals into analytical frameworks, KPIs, and measurable outcomes.
- Influence strategic decisions by providing data-driven recommendations, forecasting, and scenario modeling.
- Drive adoption of data-first practices across teams and proactively identify high-impact opportunity areas.
Analytics & Dashboarding
- Own end-to-end development of dashboards and analytics systems in Metabase (or similar BI tools).
- Build scalable KPI frameworks, business reports, and automated insights to support day-to-day and long-term decision-making.
- Ensure data availability, accuracy, and reliability across reporting layers.
Advanced Data Analysis
- Write, optimize, and review complex SQL queries for deep-dives, cohort analysis, funnel performance, and product/operations diagnostics.
- Conduct root-cause analysis, hypothesis testing, and generate actionable insights with clear recommendations.
Data Infrastructure Collaboration
- Work closely with engineering/data teams to define data requirements, improve data models, and support robust pipelines.
- Identify data quality issues, define fixes, and ensure consistency across systems and sources.
Leadership & Process Excellence
- Mentor junior analysts, review their work, and establish best practices across analytics.
- Standardize reporting processes, create documentation, and improve analytical efficiency.
Core Requirements:
- 5–8 years of experience as a Business Analyst, Data Analyst, Product Analyst, or similar role in a fast-paced environment.
- Strong proficiency in SQL, relational databases, and building scalable dashboards (Metabase preferred)
- Demonstrated experience in converting raw data into structured analysis, insights, and business recommendations.
- Strong understanding of product funnels, operational metrics, and business workflows.
- Ability to communicate complex analytical findings to both technical and non-technical stakeholders.
- Proven track record of independently driving cross-functional initiatives from problem definition to execution.
- Experience with Python, Git, or BI tools like Looker/Power BI/Tableau.
- Hands-on with data warehouses (BigQuery, Redshift, Snowflake).
- Familiarity with product analytics tools (Mixpanel, GA4, Amplitude).
- Exposure to forecasting, financial modeling, or experimentation (A/B testing).
Why Join Us?
- Work directly with top leadership in a high-impact role.
- Be part of an innovative and fast-growing AI startup.
- Opportunity to take ownership of key projects and drive efficiency.
- A collaborative, ambitious, and fast-paced work environment.
- Perks & Benefits: gym membership benefit, workation policy, and company-sponsored lunch.
If you’re looking for an exciting role that combines strategy, execution, and leadership exposure, we’d love to hear from you!
Apply now to join VerbaFlo.AI on this journey.









