Role Overview

Squared Circle Ecom is looking for a Team Lead - Analytics & BI to lead the delivery of analytics, business intelligence, reporting, automation and data solutions for our e-commerce clients.

The role combines client management, team leadership, analytics delivery and technical expertise. The individual will work closely with client stakeholders across e-commerce, finance, marketing, operations, sales and product functions to understand business requirements and translate them into scalable dashboards, analytical solutions, automated reports and actionable insights.

The role will also be responsible for managing day-to-day delivery, ensuring SLA and quality adherence, improving team productivity, identifying automation opportunities and developing the analytics capability of the team.

This is a client-facing leadership role and requires a strong combination of analytical thinking, technical knowledge, communication, stakeholder management and people leadership.

Key Responsibilities

1. Client Management & Stakeholder Engagement

- Act as a key analytics point of contact for assigned clients.
- Understand client business objectives, requirements, priorities and reporting needs.
- Conduct regular client discussions to gather requirements, clarify expectations and provide project updates.
- Translate business requirements into clear analytical and technical solutions.
- Present dashboards, reports, insights, performance trends and improvement opportunities to client stakeholders.
- Manage client escalations and ensure timely resolution of issues.
- Build robust working relationships with client stakeholders across Finance, Marketing, Product, Operations, Sales and e-commerce teams.
- Identify opportunities to expand analytics, automation and reporting services based on client requirements.

2. Team Leadership & People Management

- Lead and manage a team of analysts, BI developers and analytics resources.
- Allocate work based on team capacity, skill sets, priorities and SLA commitments.
- Monitor individual and team performance, productivity, utilization and quality.
- Provide regular coaching, mentoring and technical guidance to team members.
- Conduct knowledge-sharing sessions and support continuous skill development.
- Participate in recruitment, interviews, onboarding and training of analytics resources.
- Identify skill gaps and create development plans for team members.
- Support performance reviews and career development discussions.
- Build a high-performing, collaborative and client-focused analytics team.

3. Analytics & BI Delivery

- Own end-to-end delivery of analytics and BI projects from requirement gathering through deployment.
- Develop and maintain Power BI dashboards, reports, semantic models and KPI frameworks.
- Develop advanced SQL queries for data extraction, transformation, analysis and reporting.
- Develop DAX measures and calculated metrics for operational, commercial, financial and e-commerce analytics.
- Design data models including Fact and Dimension structures where required.
- Define KPIs, metrics,



business definitions and reporting frameworks in collaboration with stakeholders.
- Perform data analysis to identify trends, opportunities, anomalies and business insights.
- Ensure analytical outputs are accurate, reliable and aligned with client requirements.

4. Data & Automation

- Lead development of ETL/ELT workflows and data transformation processes.
- Work with data platforms such as Google BigQuery, MS SQL Server, AWS S3 and Amazon Redshift as required by client projects.
- Use Python and other automation tools to streamline repetitive analytics and reporting activities.
- Develop automated reporting solutions using Python, Google Sheets and Google Apps Script.
- Identify opportunities to automate manual processes and improve delivery efficiency.
- Implement data validation and quality checks to ensure accuracy and consistency.
- Support data warehouse and query optimization, including partitioning, clustering and performance tuning where applicable.

5. E-commerce & Business Analytics

- Develop analytics solutions for e-commerce and marketplace businesses.
- Analyze sales, revenue, orders, SKU, category, campaign, pricing and customer performance.
- Support marketplace analytics across platforms such as Lazada, Shopee, Amazon, Shopify and other e-commerce platforms.
- Develop product, customer, funnel and journey analytics where applicable.
- Work with Google Analytics 4 (GA4) data for customer and website analytics.
- Integrate data from e-commerce platforms and business systems where required.
- Develop analytical solutions for marketing, commercial and operational performance.

6. Delivery, SLA & Quality Management

- Ensure all client deliverables are completed within agreed timelines and SLAs.
- Establish and monitor delivery plans, milestones and priorities.
- Track team productivity, utilization, quality and SLA performance.
- Conduct regular quality checks and review analytical deliverables before client submission.
- Identify delivery risks and proactively communicate them to stakeholders.
- Manage escalations and coordinate resolution of critical issues.
- Establish standard operating procedures, documentation and quality-control processes.
- Ensure business-critical reports and dashboards have appropriate validation and controls.

7. Process Improvement & Automation

- Identify opportunities to improve existing analytics processes and workflows.
- Standardize recurring reports, dashboards and analytical processes.
- Drive automation initiatives to reduce manual effort and improve turnaround time.
- Quantify productivity and efficiency improvements resulting from automation.
- Develop reusable analytics frameworks, templates and reporting standards.
- Conduct root-cause analysis for recurring quality or delivery issues.




- Promote continuous improvement across the analytics function.

8. Project & Resource Management

- Estimate effort and timelines for new analytics requirements.
- Support resource planning and capacity management across projects.
- Prioritize work based on client requirements, business impact and SLA commitments.
- Track project progress, dependencies, risks and deliverables.
- Manage scope and identify requirements that may require additional effort or change requests.
- Coordinate with internal teams such as Category Management, Platform Operations, Seller Operations, Ad Operations, Design and other functions when required.
- Support transition and knowledge-transfer activities for new client processes.

Required Skills & Experience

Core Analytics & BI

- Strong experience in SQL and data analysis.
- Strong hands-on experience with Power BI.
- Good knowledge of DAX and advanced DAX.
- Experience building dashboards, reports and KPI frameworks.
- Strong understanding of data modelling and analytical reporting.
- Ability to translate business requirements into analytical solutions.

Data & Automation

- Working knowledge of Python for analytics and automation.
- Experience with ETL/ELT and data transformation workflows.
- Experience with at least one cloud data platform such as BigQuery, AWS, Redshift or equivalent.
- Understanding of data quality, validation and reconciliation processes.
- Experience automating recurring reports and manual processes.

E-commerce Analytics

- Experience working with e-commerce, marketplace or digital commerce data.
- Understanding of metrics such as GMV, revenue, orders, conversion, traffic, CTR, ROAS, SKU performance and campaign performance.
- Experience with platforms such as Lazada, Shopee, Amazon, Shopify or similar is an advantage.
- Knowledge of GA4 and customer/funnel analytics is an advantage.

Client & Business Skills

- Strong client-facing communication skills.
- Excellent requirement-gathering and problem-solving ability.
- Ability to convert business problems into analytical solutions.
- Strong presentation and storytelling skills.
- Ability to communicate complex analytical findings to non-technical stakeholders.
- Strong stakeholder and escalation management skills.

Leadership

- Experience managing or mentoring an analytics/BI team.
- Ability to allocate work and manage multiple priorities.
- Strong coaching and team-development skills.
- Experience managing delivery, quality and SLA performance.
- Ability to make technical and business decisions independently.

Preferred Experience

Candidates with experience in the following areas will be preferred:

- BPO / KPO / Shared Services / IT Services / Consulting environment.
- Client-facing analytics delivery.
- E-commerce or marketplace analytics.
- Multi-client or multi-project environment.
- Power BI administration.
- BigQuery, AWS S3 or Amazon Redshift.
- GA4 analytics.
- Python-based automation.
- Data warehouse and performance optimization.
- Financial, commercial or operational analytics.
- Experience managing SLA-driven analytics delivery.

📌 TEAM LEAD – ANALYTICS & BI (Bengaluru)
🏢 Squared Circle E-Com
📍 Bengaluru