Job Purpose
This role will serve as a SQL development & reporting specialist, responsible for designing and maintaining systems. This role requires one to work closely with the clients to investigate and report on the data. In addition this role will require a ctive participation in the design, development and maintenance of the existing systems. This role requires the capacity to develop a clear understanding of the business needs and translate them into relevant data queries to inform direction and strategy.
Key Responsibilities
• SQL development, design and maintenance.
• AD hoc data extracts and reporting.
• Responsible for consulting with clients on business needs, to understand the business questions that users are trying to get answered.
• Profiles source system data, identifies data anomalies and proposes data cleansing rules.
• Interface with company and client to ensure successful delivery of client reporting.
• Committed to the achievement and maintenance of quality, sets high standards for self and others.
• Provides a prompt, efficient and personalized service to clients, goes out of his/her way to ensure that customer needs are met.
• Resolution of delegated client queries. Where necessary escalates issues appropriately to management and pro ject teams.
• Ensuring client understanding and acceptance of recommended/implemented solution (with advice/assistance from supervisor).
• Collaborating with end users to identify needs and opportunities for improved data management and delivery.
Proactively identifies opportunities for Information usage
• Demonstrates detailed knowledge and expertise in relation to the job, readily absorbs new technical information and keeps up to date in specialist areas
• Full understanding and sound knowledge of the T - SQL language.
• To ensure that the technical requirements are in line with standards.
• Well versed in Microsoft Excel and using Pivot tables to populate data and able to do VLookups
• Stays abreast with industry trends
• Plans, organises and prioritises work in order to achieve one’s objectives
• Create action plans when required, for problem resolution and solution amendment gaining acceptance from relevant parties and commitment to execute.
• Management of own time and tasks to ensure completion of work projects on time.
• Monitoring of own work/tasks completion time. Demonstrates a high level of integrity and maturity to work on multiple projects and deliver consistently on time.
• Project management of small projects, under supervision. Active participation in large projects.
• Breaks problem in to its parts, makes use of logic and draws sound inferences from information
available.
Willing to make firm and speedy decisions and commit to definite courses of action, on the basis of
limited information if necessary.
• Produces writ ten communications which are clear, fluent, concise and readily understood by intended recipients.
• Communicates in a manner which is clear, fluent, and to the point, and which holds the audience’s attention, both in groups and one - on - one situations. Takes a proactive approach to cross - functional communication
Skills/Qualification/Experience
• Proficient with SQL – at least 4 - 5 year experience
• Experience in managing large volumes of data from different sources
• Experienced use of MS Excel
• Data analysis experience advantageous
• .Net experience advantageous