We have an exciting opportunity to work with a leading Insurance firm who are located in modern CBD offices. They offer a fully Agile work environment with an up-beat and friendly work environment as well as the chance to join a high performing team. They are looking for a Junior Data Analyst to work in SQL and perform data mining and analytics as well as reporting.
Perform data mining & analytics
Gather, organise and synthesize large amounts of information from various sources (e.g. Policy Administration System (PAS); eNsure, Salesforce, SAP)
Identify data requirements and document processes
Ensure data integrity and develop procedures for increasing data quality
Identify errors, inconsistencies and anomalies in the data, debugging issues, correcting errors and escalating issues and proposed solutions to manager when needed.
Maintain an in-depth understanding of the data and the systems.
Identify and define data and system issues, seek root causes & develop and implement practical and timely solutions.
Develop appropriate business test cases, validate results to ensure minimal risk and zero-defect solutions are developed to meet the needs of the business.
Work with the business (Sales, Claims, Contact Centre) to identify reporting needs
Produce dashboards, reports to support portfolio monitoring, business insights, strategies and goals.
Condense information and transform technical data into easily understandable outputs. Collaborate with appropriate team members to analyze and validate outputs.
Automate and produce timely reporting for regular key performance metric and overall portfolio monitoring to support key decision making across all business areas.
Work closely with management to product the most suitable aids.
Develop ad-hoc raw data reports as needed ensuring appropriately tested and fit-for-purpose.
Entry level technical and analytical experience, ideally in product / BI analytics
Foundation level SQL coding (post system data manipulation)
Insurance experience is preferred (Claims, Loss Ratio etc.)
Exposure to enterprise class systems, e.g. SAP, Salesforce and understand the application of systems, software, hardware and data management
Competency in Excel and other relevant programs - VLookups, Pivot Tables, Ifs.
Please send your resume by clicking on the apply button. Your application will be assessed within 3 working days. Please note only shortlisted candidates will be contacted.