BI & Data Quality Analyst — Azure & SQL

Prestige Cosmetics Group; Cape Town; On-site; ZAR 300 000 - 400 000; Full time

Job summary

A well-known cosmetics company in Cape Town is seeking a detail-oriented Data Analyst to manage data collection, cleansing, and validation in a SQL-based environment. The role involves collaborating with internal teams to ensure high data quality, supporting the migration to Microsoft Azure, and utilizing advanced skills in SQL and analytics tools. Ideal candidates should have a degree in a relevant field and 1–4 years of experience in data handling and analysis.

Qualifications

• 1–4 years’ experience in a data, analytics, or systems support role.
• Strong working knowledge of SQL (queries, joins, validation).
• Experience handling raw, messy, or unstructured data.

Responsibilities

• Collect data from various internal and external sources.
• Cleanse, standardise, and transform raw data into usable formats.
• Validate ingested data for accuracy and completeness.

Skills

Data validation

Analytical thinking

SQL

Data cleansing

Problem-solving

Education

Degree or diploma in Information Systems, Data Analytics, Computer Science, Finance

Tools

SQL

Excel

Microsoft Azure

Power BI

Job description

A well-known cosmetics company in Cape Town is seeking a detail-oriented Data Analyst to manage data collection, cleansing, and validation in a SQL-based environment. The role involves collaborating with internal teams to ensure high data quality, supporting the migration to Microsoft Azure, and utilizing advanced skills in SQL and analytics tools. Ideal candidates should have a degree in a relevant field and 1–4 years of experience in data handling and analysis.