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.

Key Performance Indicators The successful candidate will be measured across both technical delivery and service delivery.

Area	Key Measures
Client Delivery	SLA adherence, on-time delivery
Quality	Accuracy, error rate, rework
Productivity	Team productivity and output
Utilization	Team utilization / capacity management
Client Management	Client feedback, escalations and issue resolution
Analytics	Dashboard/report quality and business impact
Automation	Manual hours reduced / automation initiatives
Process Improvement	Process improvements implemented
People Management	Team performance, capability development and retention
Project Management	Timely delivery, scope and resource management

Education

• Bachelor's degree in Computer Science, Engineering, Statistics, Mathematics, Business Analytics, Data Analytics or a related field.

• MBA / Master's 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:

• • Analytics/BI delivery
  • Team leadership or mentoring
  • Client/stakeholder management
  • Power BI and SQL
  • Data and reporting automation
  • E-commerce/business analytics

What We Are Looking For:-

Client

Understand the client's 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.