Senior Business Analyst

– Senior Business Analyst

Company: makeO (toothsi | skinnsi)
Department: Business Analytics
Reporting To: Business Analytics Manager

makeO is India’s leading clinical beauty platform, backed by experts and driven by technology. Our brands, toothsi and skinnsi, are revolutionising the way Indians get the smile makeovers and skin they’ve always wanted.

Present in over 17 cities across India and the GCC, we’ve designed close to 2,50,000 smiles and completed over 2,00,000 Laser Hair Reduction sessions.

With 28+ Experience Centres across India, we are expanding our offline presence to ensure convenience and accessibility for our valued customers.

We are a Series C-funded start-up, established in 2018 and backed by Eight Roads Ventures, Paramark Ventures, 360 ONE Asset, the investment office of Ashish Kacholia, and the family office of Medlife founders. This funding supports our mission to revolutionise the clinical beauty space in India and the GCC.

#smilekhulke

We are looking for a Senior Business Analyst with strong technical capabilities and hands-on experience in marketing and business analytics.

The ideal candidate will combine expertise in SQL, Python, data pipelines, and business intelligence with a strong understanding of marketing funnels, campaign performance, attribution, and customer conversion.

The role involves working closely with Marketing, Sales, and Leadership teams to drive data-backed business decisions.

1. Marketing & Funnel Analytics

• Analyse end-to-end conversion funnels, from lead generation to final customer conversion.

• Track month-on-month performance across marketing channels and business segments.

• Conduct source-level campaign analysis across Meta, Google, Organic, Partnerships, and App channels.

• Analyse marketing attribution, campaign effectiveness, and customer acquisition performance.

• Identify funnel leakages and recommend opportunities to improve conversion rates and optimise marketing spend.

2. Data Analytics & Business Intelligence

• Write complex SQL queries to extract, transform, and analyse large datasets.

• Build and maintain interactive dashboards using Tableau Cloud.

• Develop automated reports and performance trackers for business stakeholders.

• Use Python and advanced Excel for data analysis, reporting, and automation.

• Deliver actionable business insights through regular performance reviews.

3. Data Pipelines & Reporting Infrastructure

• Maintain and optimise data pipelines using Apache Airflow and Amazon Redshift.

• Work with databases, backend data systems, and stored procedures to ensure reliable reporting.

• Troubleshoot data discrepancies and improve data quality.

• Automate recurring data extraction, transformation, and reporting workflows.

4. Stakeholder Management & Business Insights

• Partner with Marketing, Sales, and Leadership teams to understand analytical requirements.

• Provide regular updates on campaign performance, conversion funnels, and business KPIs.

• Conduct ad hoc analyses to support strategic and operational decisions.

• Translate complex analytical findings into clear business recommendations.

• 3–5 years of experience in Business Analytics, Marketing Analytics, Data Analytics, or a related role.

• Advanced SQL expertise, preferably with Amazon Redshift.

• Strong proficiency in Python and advanced Excel.

• Hands-on experience with Apache Airflow, Tableau Cloud, and data pipelines.

• Solid understanding of relational databases, backend data systems, and stored procedures.

• Mandatory experience in marketing analytics, including funnel analysis, source attribution, campaign analysis, and GA4/web analytics.

• Strong analytical, problem-solving, and stakeholder communication skills.

• Experience with Meta Ads, Google Ads, and multi-channel marketing analytics.

• Experience in sales analytics, dialer analytics, or lead management systems.

• Familiarity with AI tools for coding, data analysis, reporting, and workflow automation.

• Experience in D2C, consumer internet, healthtech, or high-growth startup environments.

SQL | Amazon Redshift | Python | Apache Airflow | Tableau Cloud | Marketing Analytics | Funnel Analysis | GA4 | Google Analytics | Marketing Attribution | Campaign Analytics | Data Pipelines | Stored Procedures | Advanced Excel | Business Intelligence | ETL