Senior Data Analyst

JOB INDEX - 5 months ago - Job Mail

5 months ago

Senior Data Analyst

An established company in East London seeks a Senior Data Analyst, to join their team. 

Minimum Requirements:

- Completed relevant qualification: National Diploma / BTech / Degree in IT / Information Systems

- MS SQL Server, MS Visual Studio, SSIS, SSAS, SSRS certification advantageous

- 3+ Years' Experience in MS SQL Server and MS Visual Studio SSIS, SSAS, SSRS

- Good communication and interpersonal skills

Key Performance Areas: 

- Understand the divisions reporting and operational requirements including business data flow and data structures.

- Develop an understanding of the divisions business concepts and be able to translate additional requirements/insights with SQL queries to produce appropriate data.

- Work collaboratively with business and IT to analyse requirements, develop, and support BI and Reporting projects.

- Demonstrate Data Development skills for Data manipulations through SQL optimised querying upon request.

- Develop and implement ETL routines according to the Data Warehouse design and architecture for the business.

- Planning, tracking and reporting time to be spend on software development of projects, tasks and adhoc requests.

- Writing of documentation required for deploying SSIS packages and SQL scripts.
This includes but not limited to TFS Management and updating Warehouse data dictionaries

- Develop technical competence in SSIS – to be able to extract, transform and load information for both new and existing packages used in the divisions operations.

- Technical competence in SSAS – to be able to create and update the divisions Cube reports necessary for the divisions operations.

- Apply all IT requirements in terms of database policies, deployment requirements and development of life cycle polices.

- Own and manage Assurance client reporting, including building foundational data structures to assist with the sharing of data across reports.

- Manage, update and maintain integrity of the business' customer leads population.
This also includes but not limited to extraction, manipulation and enrichment of customer data and presentation in a manner that is useable to the call centres and other distribution channels.

- Prepare periodic operational reports and provide technical assistance and training to report users.

- To perform any other function over and above the ones listed as requested by management from time to time.

Manage multiple projects at once.