Cape Town - A proactive & meticulous BI Support Analyst with strong SQL and data analysis skills is sought by a renowned investment firm.
Joining its Retail IT Business Intelligence Domain, your role will entail updating and maintaining the SQL repository, Defect Management, working with the team to ensure extracts are automated while identifying improvements.
Any Retail Investment Management experience will prove highly beneficial. Please note this is an Employment Equity position.
DUTIES : Collaboration First line support for the team with regards to queries from the business (internal and external queries).
Field day-to-day questions from business and IT teams related to the applications managed by the team. Write SQL to facilitate data extract requests received from stakeholders.
Strong communication skills are required including the ability to collaborate well across teams and within a team environment.
Provide continuous and timeous feedback to users on the progress of queries and incident requests. Analyse incident requests and share findings with the team in an effort to reduce queries over time.
Monthly extracts Generate monthly extracts timeously. Update the SQL for the monthly extracts as required. Maintain the SQL repository and ensure that the process is documented in Collab.
Work with the team to ensure that the extracts are automated. Defect Management If a query is a production defect, assist with the analysis, documentation and prioritisation of the defect.
Ensure Business Continuity Monitor the data warehouse for integration failures. Work with business and Retail IT stakeholders to ensure that integration failures are resolved.
Analyse failures and assist with the prioritisation of the resolution. Continuous Improvement Proactively identify improvements that can be made in the support space and work with the Product Owner to raise concerns and suggestions.
Training Manage and maintain the team Collab pages as relates to Support. Time Management Keep track of deadlines and self-manage to align with deadlines.
REQUIREMENTS : Data analysis and SQL skills and experience. Competency in Microsoft applications including Word, Excel, and Outlook.
Experience working in Retail Investment Management is advantageous. ATTRIBUTES : Fundamental analytical and conceptual thinking skills.
Excellent documentation and communication skills. Excellent planning, organisational, and time management skills. Detailed oriented and self-motivated.