Junior Data Analyst (Sandton) at Broll

POSITION PURPOSE

Principle role is co-ordination of workflow, report generation and technical support across technology platforms for the Occupier Services (OS) team. This will include the administration of regular and ad hoc reports from multiple systems across various clients. On-going analytical review of the processes to identify gaps, data standard compliance and data inconsistencies. The role will involve understanding and providing technical support to users and clients across the different technology platforms utilised within the OS environment.

ESSENTIAL FUNCTIONS AND BASIC DUTIES

Monthly / Ad Hoc Reporting

•  Produce monthly/ ad hoc reports as required on time
•  Reports to be accurate and in appropriate format as specified from time to time.
•  Track reporting to ensure all workflow processes are completed on time
•  Distribute reports to the specified audience and be the principle contact point for any queries on workflow processes
•  Report formats are adhered to as per the relevant company branding requirements

Assumes responsibility for assisting in the maintenance/development of the reports program.

•  Provides feedback to relevant Heads of the Divisions for improvement of processes.
•  Reviews reports with stakeholders on a regular basis to ensure relevance.
•  Assistance with the development and maintenance of the Power BI reporting programme.
•  Assistance with the development/maintenance of data automation as it relates to ETL processes.

Audit and analytical review of data

•  Monthly checking of core data set for completeness and correctness
•  Reporting to relevant OS team of any identified issues that requires correction and tracking of required corrections.

Assumes responsibility for technical support across technology platforms.

•  Provide after hour support for data related emergencies and weekend maintenance
•  Document best practices and procedures
•  Develop expertise to train staff on new technologies.
•  Assist with troubleshooting of technical issues

Assumes other related duties as required or assigned.

•  Following Company Policies and procedures, as well as those related to the clients
•  Ensures that work area is clean, secure, and well maintained.
•  Completes special projects as assigned.
•  Attends meetings as required.

EDUCATION/CERTIFICATION:

• A quantitative Degree in Informatics/ IT/ Statistics/ Maths/ Finance/ Accounting/Property management/Real Estat (Other disciplines can be considered based on experience)

TECHINICAL ABILITIES

•  Basic T-SQL (Required)
•  POWER BI (Required)
•  Excel (Advanced Level)
•  Industry Knowledge –Corporate Real Estate/ Property Management (Beneficial)
•  Accounting Experience (Beneficial)
•  Strong knowledge of Microsoft programs and their usage.
•  A strong understanding of ETL processes within the data space.
•  Minimum 2 years of experience

SOFT SKILLS

•  Well organised and detail oriented
•  Very good time management skills
•  Works well under high-pressure environment
•  Effective communication with users and clients
•  Work overtime when required
•  Ability to adapt to change
•  Team Player
•  Positive, self-motivated individual who can complete tasks independently
•  Effective documentation skills
•  Committed to continuous learning and sharing knowledge with others.
•  Able to complete complex administrative tasks with minimal supervision.
•  Strong written and verbal communication skills
•  Trustworthy and reliable.
•  Friendly and professional communicator.
•  Ability to manage multiple priorities and meet or beat deadlines.
•  Ability to anticipate the needs of others, coupled with a strong desire to serve