ADVANCED EXCEL EXPERT & DATA ANALYST WANTED!

Introduction

Boksburg | Full-Time Position

Do spreadsheets excite you? Can you turn raw data into accurate reports, meaningful graphs and easy-to-understand dashboards? Do you know Microsoft Excel like the back of your hand?

If formulas, figures, systems and statistics are your strengths, INTRO REAL ESTATE wants to hear from you!

ABOUT INTRO REAL ESTATE

Established in 1982, INTRO REAL ESTATE is an award-winning residential property agency with more than 40 years of experience. We are proud to be a trusted market leader serving Benoni, Boksburg, Kempton Park and Edenvale.

Our success is driven by a passionate, professional and high-performing team—and we are looking for an exceptional Sales Data Analyst and Administrator to join us.

THIS IS MORE THAN A DATA-CAPTURING POSITION

You will play an important role in keeping our sales information accurate, current and meaningful. You will work with multiple spreadsheets, databases, reports, applications and team members to convert daily activity into reliable statistics that assist management with tracking performance and making informed business decisions.

If you enjoy working with numbers, identifying discrepancies, improving spreadsheets and creating order from large volumes of information, you could be exactly who we are looking for.

Duties & Responsibilities

KEY RESPONSIBILITIES

• Capture, update, verify and analyse daily, weekly and monthly sales statistics.

• Maintain advanced Excel spreadsheets, formulas, graphs, reports and performance dashboards.

• Compile statistics relating to agent performance.

• Calculate and monitor averages, percentages, trends and performance ratios.

• Reconcile information across different spreadsheets, databases, reports and applications.

• Identify missing, duplicated or inconsistent data and ensure that errors are corrected promptly.

• Extract, import and organise data from property systems and databases.

• Prepare accurate month-end reports, graphs and supporting documentation.

• Maintain structured digital records and complete regular backups.

• Liaise patiently and professionally with management, consultants and administrative staff.

• Manage multiple recurring deadlines without compromising accuracy.

ADVANCED EXCEL EXPERTISE IS NON-NEGOTIABLE

Applicants must be genuinely confident working with

• Advanced formulas and nested formulas

• IF, IFS, SUMIF/SUMIFS and COUNTIF/COUNTIFS

• XLOOKUP, VLOOKUP and INDEX/MATCH

• PivotTables and PivotCharts

• Graphs, dashboards and statistical reports

• Sorting, filtering and managing large datasets

• Conditional formatting and data validation

• Percentages, averages, ratios and trend analysis

• Linking and reconciling information across multiple worksheets

• Importing, cleaning and checking data

• Troubleshooting and correcting spreadsheet errors

Experience with Power Query, macros, automation, database applications, reporting tools or integrations between different applications will be a strong advantage.

Please do not apply if your Excel experience is limited to basic data entry, formatting or simple calculations.

Shortlisted applicants will be required to complete a practical Excel competency assessment.

Desired Experience & Qualification

WHAT WE ARE LOOKING FOR

You are

• Highly analytical and naturally comfortable with figures and statistics

• Exceptionally accurate, fast and detail-orientated

• Tech-savvy and confident learning new applications and systems

• Organised and able to manage several projects and deadlines simultaneously

• A proactive problem-solver who uses initiative

• Reliable, conscientious and accountable

• Cool, calm and collected under pressure

• Patient when assisting and following up with multiple team members

• A clear and professional communicator

• A committed team player with a positive attitude

• Passionate about improving processes and producing excellent work

• Professionally presented

MINIMUM REQUIREMENTS

• Proven advanced Microsoft Excel skills—non-negotiable

• Strong Microsoft Word and general computer skills

• Previous experience in data analysis, statistical reporting, data capturing, sales administration or a similar office-based role

• Strong administrative and organisational abilities

• Experience working with databases and extracting relevant information

• Excellent written and spoken English

• Accurate typing and data-capturing skills

• Professional telephone manner and client-relations experience

• Valid driver’s licence and own reliable vehicle—non-negotiable

• Willingness to work one Saturday half-day per month

Interested?

WHY JOIN INTRO REAL ESTATE?

This is an opportunity to become part of an established, respected and forward-thinking real estate company where your expertise will be valued and your work will make a measurable difference.

You will join an energetic, professional team that values accuracy, accountability, continuous development, technology and service excellence.

READY TO PUT YOUR EXCEL EXPERTISE TO WORK?

Send your CV, together with a brief description of the most advanced Excel spreadsheets, formulas, dashboards or reporting tools you have created.

Only applicants who meet the advanced Excel requirement will be considered.

INTRO REAL ESTATE, it’s the right choice.