Are you passionate about transforming data into actionable insights and want to develop your analytical skills in a supportive, fast-paced environment? We’re looking for a technically minded individual to grow with us in a dynamic role that bridges data analysis, system integration, and operational excellence.
Position: Data Analyst
Team Size: 7-10
Location: Kleinbron Estate, Brackenfell North, Cape Town, 7560
What You’ll Do:
- Data Management & Analysis: Maintain data accuracy, perform comprehensive data integrity checks, and transform raw data into meaningful insights
- Advanced Excel Operations: Leverage intermediate to advanced Excel functions including XLOOKUP, complex IF statements, Pivot Tables, and data manipulation techniques
- Data Integration: Use Power Query to extract, transform, and load data from various sources into consolidated datasets
- System Support: Execute routine system tasks, troubleshoot technical issues, and maintain operational workflows across various platforms
- Database Operations: Query and manage data using SQL databases, ensuring data consistency and accessibility
- Documentation & Communication: Create clear documentation using Markdown and communicate findings effectively with cross-functional teams
- Continuous Learning: Adapt to new tools, platforms, and data systems while contributing to data-driven projects with precision and focus
Essential Requirements:
Core Excel Proficiency
- Advanced knowledge of Excel functions: XLOOKUP, VLOOKUP, complex IF statements, SUMIFS, COUNTIFS
- Expertise with Pivot Tables, Power Pivot, and data modelling
- Experience with data validation, conditional formatting, and advanced charting
Data Processing & Transformation
- Power Query experience for data extraction, transformation, and automation
- Understanding of data cleaning, normalization, and preparation workflows
Technical Foundation
- Documentation Skills: Ability to create and maintain technical documentation using Markdown
Systems Understanding
- Basic comprehension of business systems architecture (CRM platforms, ticketing systems, ERP solutions)
- Understanding of data flow between different operational systems
- Experience with system integration concepts and workflow automation
Core Competencies
- Strong analytical thinking and structured problem-solving approach
- Exceptional attention to detail and commitment to data accuracy
- Self-motivated with ability to manage multiple responsibilities independently
- Excellent communication skills for technical and non-technical stakeholders
Highly Valued Bonus Skills:
Technical Foundation
- Database IDE Proficiency: Experience with database management tools (DBeaver, TablePlus, MySQL Workbench, pgAdmin, or similar)
- Code Editor Navigation: Proficiency with VSCode or similar code editors for script management and development
Business Intelligence
- Power BI experience for dashboard creation and data visualization
- Understanding of DAX functions and data modelling principles
Database Management
- MySQL and/or PostgreSQL proficiency for complex data operations
- Experience with database design, optimization, and administration
Programming & Automation
- Python skills for data analysis, automation, and scripting (pandas, NumPy, etc.)
- Experience with API integrations and data pipeline development
Advanced Analytics
- Statistical analysis and data mining techniques
- Experience with version control systems (Git)
- Knowledge of cloud platforms and data warehousing concepts
Why Join Us?
- Hands-on Experience: Work with real-world data challenges in a growing, technology-focused environment
- Mentorship & Growth: Learn from experienced professionals with clear pathways for career advancement
- Technical Development: Access to cutting-edge tools and technologies with opportunities to expand your skill set
- Competitive Package: Salary commensurate with experience plus growth-based advancement opportunities
- Collaborative Culture: Join a supportive team that values innovation, learning, and technical excellence
Ready to Transform Data into Insights?
If you’re excited about working with data, love solving technical challenges, and want to grow your career in a dynamic environment, we want to hear from you!
We welcome applications from candidates with equivalent skills and experience, even if you haven’t worked with the exact tools mentioned. What matters most is your ability to learn, adapt, and apply similar technologies effectively.
Desired Skills:
- Data manipulation
- Data Cleansing
- Data extraction
- Business Intelligence Tools
- Microsoft Power BI
- Data analysis
- Visual analytics
- Data Quality
- System Support
- documentation skills
- Analytical Thinking
- Detailed
- Excel Proficiency
- Data Modeling
- System Understanding
- Data Transformation
- Power Query
- Data Mining Techniques
- DBeaver
- TablePlus
- MySQL Workbench
- pgAdmin
- Data Normalization
- Excel functions
Desired Work Experience:
- 1 to 2 years
Desired Qualification Level:
- Grade 12 / Matric
About The Employer:
FIND THE GAP
Find the Gap was established in the early 2000’s and has developed a product information management platform. The PIM Platform known as FTG One consists of multiple modules namely marketing, sales, order and data distribution which are widely used within the building sectors.
FTG ONE
FTG One serves as a comprehensive Product Information Management Platform that fulfills multiple functions. It operates as a complete repository for product data, offering extensive capabilities for managing specifications and placing orders. Additionally, the platform serves as a central hub for distributing product data to external systems and platforms.
SERVICES & EXPERTISE
Ftg One, supported by our teams’ labour and expertise, has been designed to allow for product data to be properly managed and distributed to multiple channels with ultimate efficiency.