As an Data Analyst, you will play a crucial role in supporting our tendering process by accurately updating and maintaining cost data, analyzing pricing information, and generating reports.
1. Update and maintain tender costings in Excel spreadsheets on a daily basis, ensuring accuracy, consistency, and adherence to established formulas and calculations.
2. Utilize advanced Excel functions, including nested formulas, conditional formatting, pivot tables, and macros, to enhance data analysis and reporting capabilities.
3. Collaborate with cross-functional teams to gather and verify pricing information, ensuring its integration into tender costings accurately.
4. Conduct comprehensive data analysis to identify trends, anomalies, and opportunities for cost optimization, providing valuable insights to decision-makers.
5. Develop and maintain standardized templates and tools for tender costings, ensuring efficiency, accuracy, and consistency across multiple projects.
6. Generate clear and concise reports, summaries, and visualizations based on analyzed data, aiding in the decision-making process for tender submissions.
7. Regularly update and manage databases and repositories containing tender-related information, ensuring data integrity and accessibility.
8. Stay up-to-date with the latest Excel features, techniques, and best practices, sharing knowledge with colleagues to promote continuous improvement in data management and analysis.
9. Ability to work independently with minimal supervision and manage multiple tasks simultaneously in a fast-paced environment.
10. Knowledge of other data analysis and visualization tools (e.g., Power BI, Tableau) is a plus.
If you have advanced Excel skills and a passion for working with complex data in a fast-paced environment, this Excel Specialist/Analyst role offers an excellent opportunity to contribute to our tendering process and make a significant impact on our organization. Join our team and become an integral part of our success!
Job Type: Full-time
Ability to commute/relocate:
- Epping, Western Cape: Reliably commute or planning to relocate before starting work (Required)
Education:
Work Location: In person
Candidates must be currently located in Cape Town
Work Location: In person
