Guided by Senior and Lead Analysts / Developers, this role will be responsible for sourcing and transforming a wide range of data across the business into formats that can be used by end users to develop differentiating business insights.
The person fulfilling this role will not only analyse data models, but also test the outputs, investigate & troubleshoot data issues and devise solutions in line with best practice.
A high competency in problem solving capabilities is thus essential. They should be able to communicate business information to technical teams, as well as be competent in communicating challenges and solutions to the team.
What will make you successful in this role? Data Preparation
Acquire data from various data sources and combine & transform data into interpretable datasets, reports or dashboards
Assess the effectiveness and accuracy of new data sources and data gathering techniques
Extend the company’s data with third party sources of information when required
Process, cleanse and verify the integrity of data used for analysis
Perform data profiling of data contained in source systems
Provide detailed analysis of all data implemented into the database
Provide the data mapping and associated transformation rules for each data item
Ensure that the business requirements and subsequent development activities are supported by accurate information.
Analysis and Visualisation
Interpret data, analyse results using analytical techniques and provide reports and / or dashboards
Identify, analyse, and interpret trends or patterns in complex data sets
Use data to answer key questions about the business.
Own and maintain dashboards, ongoing reporting, and ad hoc requests from the organization.
Support and maintain the project data models at multiple levels of detail and functionality (conceptual, logical, normalised, relational, dimensional, application level, subject-level, integrated, etc.)
Work directly with management and other business users to gather requirements, provide status updates, and build relationships
Present information using data visualisation techniques
Facilitate requirements gathering workshops with the business
Collaborate with internal and external stakeholders to analyse information needs, functional requirements and business processes
Coaching / Mentorship
Provides problem solving assistance to other team members
Qualification and experience
Diploma / Bachelor Degree (Information Systems; Statistics; Data or Computer Science; Engineering) or equivalent (preferred but not essential)
Functional experience in analytics, data visualisation or reporting
1-2 years of experience performing data analysis
Experience with Data Visualisation tools and techniques (e.g. SAP Business Objects and PowerBI) is an advantage
Experience Extracting data or Querying data in database from Data Visualisation software or Structured Query Language (SQL) skills
Adept at queries, report writing and presenting findings for stakeholder use
Experience working with data in various data sources and databases
Ability to translate business requirements into non-technical terms
Demonstrated experience in handling large data sets and relational databases with proven SQL skills
Ability to comply to and manage data assets under strict governance framework
Knowledge of analytics, data mining and data models
Business experience in financial services would be advantageous
Ability to work with data profiling, data quality and reference data toolsets advantageous
Knowledge and Skills Legacy / Procedural and ERP Application Environment designs Reporting and Administration Business Requirements definition System enhancements Programme specifications Personal Attributes Interpersonal savvy - Contributing independently Decision quality - Contributing independently Action orientated - Contributing independently Optimises work processes - Contributing independently