Junior Data Analyst
Gauteng, Johannesburg, South Africa
SMD Technologies
Job Title: Junior Data Analyst
Purpose of the Role:
We are seeking a detail-oriented and disciplined Junior Data Analyst to support key operational functions within the business. This individual will be responsible for managing and validating data processes related to forecasting, pricing, and order management. The ideal candidate must be confident in identifying discrepancies, enforcing process accuracy, and collaborating with various departments to ensure data integrity.
Key Responsibilities:
Forecast & Order Management
· Execute and validate forecast changes in line with business logic.
· Load and maintain bulk forecasts and bulk orders.
· Manage forecast movements and rollover processes.
· Add new products to forecasts (with guidance from Key Account Managers.).
Pricing & Product Administration
· Perform permanent and temporary price changes.
· Create and update pricelists, including assigning/removing promotions.
· Manage zero-price product identification and resolution.
· Add or remove products from pricelists.
Data Access & Configuration
· Manage user access to forecast groups and pricelists.
· Link accounts and users in the system.
· Check product existence and manage bundle code components.
· Assign users and handle account linking.
System & Sales Data Maintenance
· Import and delete sales data.
· Track and update container information.
· Handle EDI order issues (fixing and pulling EDI data via SQL).
· Manage sales order pushing and confirmations.
· Support accurate data in the Retailers Map, Quotes/SOS, and Sell-Through reports.
Operational Support
· Read and interpret Power BI reports (report building not required).
· Perform basic SQL queries to investigate data issues.
· Support day-to-day business processes by creating packing lists and adjusting delivery/shipping information as needed.
Required Skills and Competencies:
· Strong attention to detail and accuracy.
· Ability to enforce rules and processes when needed.
· Basic SQL knowledge (ability to query and extract data).
· Competence in reading Power BI reports.
· Strong Excel skills and comfort working with large datasets.
· Effective communicator who works well under pressure.
· Process-driven, with strong organisational abilities.
Qualifications and Experience:
· Diploma or Bachelor's degree in Data Analytics, Information Systems, Business, or a related field (advantageous).
· 1–2 years of experience in a data support or analyst role (preferably in a supply chain, sales, or retail environment).
· Prior exposure to EDI systems, order processing, or forecast management systems is advantageous
Purpose of the Role:
We are seeking a detail-oriented and disciplined Junior Data Analyst to support key operational functions within the business. This individual will be responsible for managing and validating data processes related to forecasting, pricing, and order management. The ideal candidate must be confident in identifying discrepancies, enforcing process accuracy, and collaborating with various departments to ensure data integrity.
Key Responsibilities:
Forecast & Order Management
· Execute and validate forecast changes in line with business logic.
· Load and maintain bulk forecasts and bulk orders.
· Manage forecast movements and rollover processes.
· Add new products to forecasts (with guidance from Key Account Managers.).
Pricing & Product Administration
· Perform permanent and temporary price changes.
· Create and update pricelists, including assigning/removing promotions.
· Manage zero-price product identification and resolution.
· Add or remove products from pricelists.
Data Access & Configuration
· Manage user access to forecast groups and pricelists.
· Link accounts and users in the system.
· Check product existence and manage bundle code components.
· Assign users and handle account linking.
System & Sales Data Maintenance
· Import and delete sales data.
· Track and update container information.
· Handle EDI order issues (fixing and pulling EDI data via SQL).
· Manage sales order pushing and confirmations.
· Support accurate data in the Retailers Map, Quotes/SOS, and Sell-Through reports.
Operational Support
· Read and interpret Power BI reports (report building not required).
· Perform basic SQL queries to investigate data issues.
· Support day-to-day business processes by creating packing lists and adjusting delivery/shipping information as needed.
Required Skills and Competencies:
· Strong attention to detail and accuracy.
· Ability to enforce rules and processes when needed.
· Basic SQL knowledge (ability to query and extract data).
· Competence in reading Power BI reports.
· Strong Excel skills and comfort working with large datasets.
· Effective communicator who works well under pressure.
· Process-driven, with strong organisational abilities.
Qualifications and Experience:
· Diploma or Bachelor's degree in Data Analytics, Information Systems, Business, or a related field (advantageous).
· 1–2 years of experience in a data support or analyst role (preferably in a supply chain, sales, or retail environment).
· Prior exposure to EDI systems, order processing, or forecast management systems is advantageous
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Job stats:
0
0
0
Category:
Analyst Jobs
Tags: Data Analytics Excel Power BI SQL
Region:
Africa
Country:
South Africa
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.
Power BI Developer jobsBusiness Intelligence Developer jobsPrincipal Data Engineer jobsBI Developer jobsStaff Data Scientist jobsStaff Machine Learning Engineer jobsPrincipal Software Engineer jobsJunior Data Analyst jobsData Science Intern jobsDevOps Engineer jobsData Manager jobsData Science Manager jobsSoftware Engineer II jobsAccount Executive jobsStaff Software Engineer jobsData Analyst Intern jobsLead Data Analyst jobsBusiness Data Analyst jobsAI/ML Engineer jobsSr. Data Scientist jobsData Specialist jobsData Governance Analyst jobsSenior Backend Engineer jobsData Engineer III jobsBusiness Intelligence Analyst jobs
Consulting jobsMLOps jobsAirflow jobsOpen Source jobsEconomics jobsLinux jobsKPIs jobsKafka jobsTerraform jobsGitHub jobsJavaScript jobsPostgreSQL jobsRDBMS jobsData Warehousing jobsNoSQL jobsClassification jobsBanking jobsStreaming jobsScikit-learn jobsPrompt engineering jobsRAG jobsComputer Vision jobsPhysics jobsGoogle Cloud jobsPandas jobs
Hadoop jobsOracle jobsScala jobsdbt jobsBigQuery jobsLooker jobsReact jobsGPT jobsData warehouse jobsR&D jobsLangChain jobsScrum jobsPySpark jobsDistributed Systems jobsMicroservices jobsCX jobsELT jobsIndustrial jobsSAS jobsOpenAI jobsJira jobsRedshift jobsModel training jobsTypeScript jobsJenkins jobs