SQL Data AnalystSQL Data Analyst Support the Insights and Special Projects Manager in delivering on key projects and providing analytical support.
Provide relevant MIS to the Customer Business team and ensure the division has sufficient prospect data to support Customer strategy.
Manage data uploads for Lock-in, Core and Customer SalesPrepare price increase file and facilitate implementationPrepare insights for Lock-
in, Core and Customer Sale needsProject manage any data / reporting automation for the customer businessMake changes to data strategy on the Data Management Console (DMC)Create campaigns for Customer Business in the diallerManage dialler flushes when necessaryMinimum Requirements : Relevant tertiary qualification.
Advanced Excel2 - 3 years business experience including, project management, insights and / or analytics.Managing operational tasksDesigning and building business level management information reporting.
Minimum 2 years' experience is recommended developing for SQL Server Versions 2008 / 2008 R2 / 2012 / 2014SQL 2016 experience a plus.
Essential Skills : T-SQL skills must include : Multiple table Joins query writingWindow Panes / Paging resultsBulk Importing / Exporting of data to and from external data sourcesCreating and updating Stored Procedures and functionsKnowledge and use of Ranking functionsKnowledge and use of Common Table Expressions (CTEs)SQL Server Knowledge should include a strong understanding of : Relational Database Management Systems (RDBMS)Set-
based T-SQL codingDatabase design principles and patterns. e.g NormalizationWorking with Distributed databases and transactionsExecution plansPerformance impact of code.
Clustered and Non-clustered indexing, and how to best make use of them.Basic understanding of Set theory and Relational theory would be a plusBasic understanding of AGILE development would be a plusUnderstanding and experience with SSIS, SSR