TEAM LEAD – ANALYTICS & BI

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 strong 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.