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

- Client Management Stakeholder Engagement
- Team Leadership People Management
- Analytics BI Delivery
- Data Automation
- E-commerce Business Analytics
- Delivery, SLA Quality Management
- Process Improvement Automation
- Project Resource Management
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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

Education

- Bachelors degree in Computer Science, Engineering, Statistics, Mathematics, Business Analytics, Data Analytics or a related field.
- MBA / Masters degree in Analytics, Business, Technology or a related discipline is an advantage.

Experience

- 5-8 years of overall experience in Analytics, Business Intelligence, Data Analytics, Data Engineering or related fields, with demonstrated experience in:
- Client: Understand the clients business, communicate confidently and deliver solutions that create measurable value.
- Team: Lead, mentor and develop a high-performing analytics team while managing productivity, quality and delivery.
- Technology: Have sufficient technical depth in SQL, Power BI, data modelling, automation and data platforms to design solutions, review technical work and guide the team.
- The ideal candidate should be business-oriented rather than purely technical, with the ability to connect data, technology and business outcomes in a client-service environment.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 TEAM LEAD - ANALYTICS & BI (Bengaluru)
🏢 Squared Circle Ecom
📍 Bengaluru