Data Analyst (SQL) at Takealot Group

Cape Town, Western Cape, South Africa -

Full Time

Start Date

Immediate

Expiry Date

13 Apr, 26

Salary

0.0

Posted On

13 Jan, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Data Analysis, ETL, Automation, BI Fundamentals, Data Cleansing, Data Modelling, Looker, Google BigQuery, AWS, Python, Excel, Google Sheets, Communication, Analytical Thinking, Problem Solving

Industry

Software Development

Description

Takealot Fulfilment Solutions (TFS), a division of Takealot Online (RF) (Pty) Ltd, is looking for a highly talented Data Analyst to join our team in Cape Town. Join Our Mission at Takealot Fulfilment Solutions | We Are TFS Revolutionising e-commerce logistics in South Africa with cutting-edge technology and operational excellence. We deliver 30+ million orders annually, empowering businesses and driving economic growth. Who We're Looking For: Innovative, ambitious individuals ready to shape the future of e-commerce logistics. At TFS, "Uniquely You" meets "Powerfully Us", where your individuality strengthens our collective mission. Why Join TFS: Purpose-driven impact: Transform lives through logistics innovation Advanced technology: Work with cutting-edge systems in a fast-paced environment Career growth: Thrive in an agile space that champions continuous improvement Inclusive culture: Your unique perspective drives extraordinary results A culture that celebrates individual uniqueness while championing the strength of togetherness. Be part of creating sustainable, scalable solutions that make a difference across South Africa's e-commerce landscape. At TFS, your growth is our growth. You'll be joining a team powered by Takealot Group's core values. This position reports to the Head of TDT Analytics. Your responsibilities can include: Building and optimising models and reports using support tools i.e. Looker, Looker Studio, Dataform, Branch Dashboards, Weekly reports to inform operational decisions and drive improvement. Creating reports with focus areas for business improvement. Building dashboards to be used by the business for exception management. Identifying important variables and focus areas in the business. Analysing data to answer strategic and operational questions posed by the business. Automating data extraction and report update processes. Provide information to various stakeholders. Data Validation and integrity testing. Data Cleansing and data modelling. Provide information to various stakeholders. Collaborate with TDT managers and Franchise Managers to establish project plans while accounting for the trade-offs between operational practicality and overall performance. Provide significant support to TDT according to weekly goals and targeted metrics. Use weekly and monthly targets to manage day-to-day performance and inform operations for best impact. Regularly review and analyse key metrics in operations to identify root causes and formulate solutions to improve performance. Managing customer, branch, driver, and courier feedback into continuous performance improvement processes. Technical Skills and Tools: Have worked with Automation and ETL software. Strong experience in building and optimising SQL scripts. Have a strong understanding of BI fundamentals. Implement version control using GIT. Implement continuous integration and continuous deployment (CI/CD) pipelines. Write technical documentation for APIs and libraries. Implement analytics and tracking features in applications. Design and implement database schemas. Optimize database queries and indexes for performance where needed. Implement error handling and logging mechanisms. Estimate story points and task durations for sprint planning. Demonstrate a willingness to learn and adapt to new technologies. Attributes required: Solutions-oriented, can-do attitude and high energy. Strong analytical and critical thinking, using data to inform decisions. Ability to identify areas of improvement in current processes. Ability to use logic and common sense to arrive at conclusions. Passion for understanding ambiguous, complex problems and driving high quality, innovative, clean solutions. Highly structured thinker with strong attention to detail. Ability to handle multiple competing priorities in a fast-paced environment. Must have exceptional communication skills to help deliver insights to diverse stakeholders. Detail oriented, outcome and process focused. Willingness to learn and personal desire to keep up to date with technology and process. Comfortable with change and excellent team player. Qualifications and experience: Bachelor’s degree or Advanced Diploma in Engineering, Information Systems, BCom Computer Science or similar degree and 3 years experience in a BI, Data, Engineering role within a fast-paced, product-led, and growth-focused organisation, playing a key role in data gathering, data analysis and helping the team make data based decisions. In the event the candidate does not have a Bachelor’s degree or Advanced Diploma in Engineering, Information Systems, BCom Computer Science or similar then a relevant Higher Certificate and 6 years relevant experience in a BI, Data, Engineering role within a fast-paced, product-led, and growth-focused organisation, playing a key role in data gathering, data analysis and helping the team make data based decisions. Strong hands-on experience with SQL, ETL pipelines, Google BigQuery, AWS, Looker Studio, and Python. Automation - Cron Scheduling (Custom or 3rd party software scheduling). High level of proficiency with MS Office packages with proven advanced proficiency in Excel / Google Sheets, Docs & Slides. Experience with large datasets and optimisation on digital platforms. Retail or e-commerce and Supply Chain industry experience is beneficial. Be part of the extraordinary. Be part of TFS. Takealot Fulfilment Solutions (TFS) is an Equal Opportunity Employer. Applicants from previously disadvantaged groups and people with disabilities will be given preference.

Responsibilities

The Data Analyst will build and optimize models and reports to inform operational decisions and drive improvements. They will analyze data to answer strategic questions and collaborate with managers to establish project plans.