Fresh Jobs at The Prestige Cosmetics Group

Role Summary

• We are seeking a detail-oriented Data Operations Analyst to own the collection, processing, cleansing, mapping, and validation of data ingested into our SQL-based data environment. This role is critical in ensuring data accuracy, consistency, and reliability across business reporting and analytics platforms as we transition our data infrastructure to Microsoft Azure.
• The successful candidate will work closely with internal stakeholders, data sources, and technical teams to ensure high-quality data flows from source systems into our core databases.

Key Responsibilities

Data Collection & Ingestion

• Collect data from multiple internal and external sources (files, APIs, manual submissions, system exports)
• Prepare and ingest data into SQL databases using defined processes
• Support ongoing migration of data workflows to Azure-based services

Data Processing & Transformation

• Cleanse, standardise, and transform raw data into structured, usable formats
• Map incoming data to existing database schemas and business definitions
• Apply business rules and transformation logic consistently

Data Quality & Validation

• Validate ingested data for accuracy, completeness, consistency, and timeliness
• Identify, investigate, and resolve data quality issues at source
• Implement and maintain validation checks and reconciliation processes
• Flag anomalies, trends, or risks in incoming datasets

Database & Data Management

• Work directly with SQL databases to query, validate, and maintain data
• Assist with schema updates, documentation, and data dictionary maintenance
• Ensure data integrity across historical and incremental loads

Documentation & Process Improvement

• Document data sources, mappings, transformation rules, and validation logic
• Continuously improve data ingestion and quality processes
• Support automation initiatives to reduce manual data handling

Stakeholder Support

• Work closely with analysts, reporting teams, and business users to resolve data queries
• Provide trusted datasets for dashboards, reports, and decision-making

Data Quality Mindset

• High attention to detail and accuracy
• Strong understanding of data validation and quality control techniques
• Ability to trace issues back to source systems

Leadership and Culture

• Manage own personal development through your PDP (Personal Development Plan). Request training and feedback on performance at least once a month and strive to improve based on these interventions.
• Adhere to and live the company's values.
• Be an active participant and ambassador in all culture initiatives and activities.
• Take responsibility for all issues facing the department, work as a team and mentor/coach new team members as required.
• Communicate with your line manager regularly and make recommendations on improving efficiencies and effectiveness in the department.
• Contribute positively to create a harmonious working environment for all team members.
• Build meaningful connections with all stakeholders.

Soft Skills & Attributes

• Methodical, organised, and process-driven
• Strong problem-solving and analytical thinking
• Able to work independently while collaborating with technical and non-technical teams
• Comfortable working with large volumes of data and tight deadlines
• Clear communicator who can explain data issues in business terms

Required Skills & Experience

• Degree or diploma in Information Systems, Data Analytics, Computer Science, Finance, or related field
• 1–4 years’ experience in a data, analytics, or systems support role (adjust for seniority)
• Strong working knowledge of SQL (queries, joins, validation, reconciliation)
• Experience handling raw, messy, or unstructured data
• Solid understanding of data cleansing, transformation, and mapping concepts
• Familiarity with ETL / ELT processes and data pipelines
• Experience with Excel (advanced formulas, Power Query preferred)

Advantageous

• Exposure to Microsoft Azure (Azure SQL, Data Factory, Blob Storage, Synapse)
• Experience with Power BI or other reporting tools
• Basic Python or scripting experience for data automation
• Understanding of data governance, lineage, and documentation best practices

Deadline: 11th March,2026

go to method of application »

• The Prestige Cosmetics Group is one of the subsidiaries of CAVI Brands and is one of the leading distributors of luxury fine fragrance, cosmetics, and specialised skincare in Southern Africa. Some of the luxurious brands include Chanel, Burberry, Dolce & Gabana, Bulgari, La Prairie, Sensai to name a few.  The Prestige Cosmetics Group epitomizes luxury, dynamism, sophistication and excellence. The Prestige Cosmetics Group is offering an exciting opportunity within our Distribution Centre for a driven and ambitious individual to join the Cape Town team as Picker.

Main job functions (but not limited)

• Take orders/pick slips from outbound supervisor regarding needed items.
• Locate items in the DC using RF scanner
• Pull & pick items from the shelves/bins and ensure that they are not damaged.
• Scan items with RF scanner to validate if correct.
• Scan items with RF scanner to validate authenticity.
• Place items into a box/es and move to despatch
• Ensure the accuracy of each order & item
• Ensure a clean working area at all time.
• Reporting non-compliant items to line manager, i.e. damaged, etc.
• Reporting items with/without security barcodes to line manager
• Management of scanner
• Inter department communication

Adhoc functions

• Assisting in other departments based on operational needs.
• Housekeeping in and around the DC.
• Cycle counting and correcting stock levels.
• Factory shop replenishment.
• Returns replenishment.
• Destruction stock pulling.
• Receiving checking and scanning

Minimum Requirements

• Must be able to work shifts
• General Warehousing experience (Minimum 1yr)
• Attention to detail
• Self-motivated individual
• Minimum matric
• Willing to learn
• Copes well within a pressurized environment.
• Must be able to read and write
• Basic computer skills
• WMS knowledge – Datascope advantageous
• Syspro knowledge advantageous
• Team Player
• Must be able to work independently.

Deadline:16th March,2026

go to method of application »

Purpose of the Role

• Drive sales and provide a desirable client experience in order to ensure that standards are maintained as well as to build and maintain brand image.

KEY RESPONSIBILITIES

ACHIEVE COUNTER SALES TARGETS

• Achieve monthly and annual set budgets
• Track counter and individual targets
• Sell and drive sales in order to achieve targets
• Assist in setting up and driving sales at Counter events
• Provide feedback on sales/counter related issues or concerns

BRAND MANAGEMENT

• Increase brand awareness and image through ensuring adherence to grooming and uniform guidelines
• Monitor competitor activity
• Know your in-store ranking
• Ensure that stock is merchandised according to merchandising guidelines
• Know your stock versus tester ratio and report out of stocks RDM daily to drive sales and maintain an exceptional client experience
• Ensure that counter hygiene standards are maintained according to brand standards at all times

CLIENT EXPERIENCE

• Uphold and reinforce the Client experience standards
• Build relationships and loyalty with clients
• Drive increased customer data base (attraction of NEW customers)

ADMINISTRATION

• Complete daily tracking sheets and submit weekly to RDM
• Complete all progress reports required and submit timeously
• Complete and update client cards for all new and existing clients and file accordingly

TEAM WORK

• Work in collaboration with other colleagues to drive and execute overall budgets as well as supporting events
• Support and assist new team members with onboarding and orientation
• Build relationships with respective retailer to achieve key outputs

COMPETENCIES

• Deciding and Initiating Action
• Working with People
• Relating & Networking
• Adhering to Principles and Values
• Persuading and Influencing
• Planning and Organising
• Delivering Results & Meeting Customer Expectations
• Coping with pressure and setbacks

REQUIREMENTS/QUALIFICATIONS

• Matric certificate
• Previous retail and skincare experience