Senior Data Analyst

£44,000 | London | Permanent

IQ Talent Solutions

Posted 21 days ago

IQ Talent Solutions

Annuity Operations Management Support:

Annuity Operations is responsible for provision and maintenance of Annuity & Service data and metrics within my clients business including but not limited to Service Contract Profitability, Service Delivery & Efficiency, and Product Technical Performance. This includes management of a divisional MS SQL Server and the development of BI using MS PowerBI, MS SSRS, and other applications.

The Senior Data Analyst will:

* Support Department Manager with ongoing development of Annuity & Service Reporting Initiatives and deliverables
* Administrate & Develop existing departmental MS SQL Server Instance including ETL processes

(SSIS/Powershell), Data transformation & Security (SSMS), and connection via other tools (e.g. MS Office, Power BI , others)

* Continuously review processes and policies to improve the reporting framework and maintain availability of consistent & accurate information supporting Annuity & Service within EMEA
* Maintain a practical level of documentation (SQL comments, schema diagrams, etc in addition to written documentation)
* Collect and analyze all relevant data in order to provide adequate management
* Information on all Annuity & Service activities.
* Contribute to the further development of management information systems and de-duplication of existing processes
* Lead additional project initiatives as needed at direction of Department Manager

Participate, support and actively work on the processes of the department

* Contribute to Annuity team improvement programmes and Operating Company support
* Support customer reporting (external) team activities
* Identify potential efficiencies within the department and promote improvements
* Contribute to any additional activities when required

Essential Criteria:

* Passionate about business intelligence, data integration, data modeling, data manipulation and data management
* Experienced in handling large datasets with efficiency and accuracy
* Experience supporting junior analysts to define data modeling needs
* Relevant experience of performance measurement, management reporting and delivery.
* Excellent MS SQL Server (SSIS,SSMS,SSRS)

, + Office 365 capability

* Excellent T-SQL (query, views, stored procedures) writing ability and structure

(comments, self-testing, maintenance of best-practice)

* Process driven individual; Strong ability to manage interdependent processes
* Detail driven with a passion for data quality and the application of data quality tools
* Creative and Solution-oriented attitude
* Impeccable communication skills; Can detail complex topics to a mixed audience
* Excellent organizational skills and self-management
* Enthusiastic and committed team member
* Proactive and constructive approach to data governance

Desirable Criteria:

* Recognised SQL Server Management Studio Certification
* Passionate about Data Science and/or Data Engineering
* Experience using MS Power BI or equivalent current leading BI tools
* MS Powershell proficient
* Knowledge of MS Active Directory / LAN / WAN infrastructure
* Knowledge of IT Security requirements (ISO 27001/9001 etc.)
* Exposure to International business processes
* Experience in developing Service Delivery or Financial Business Intelligence
* London, UK working location 3+ days per week

InterQuest Group is acting as an employment agency for this vacancy. InterQuest Group is an equal opportunities employer and we welcome applications from all suitably qualified persons regardless of age, disability, gender, religion/belief, race, marriage, civil partnership, pregnancy, maternity, sex or sexual orientation. Please make us aware if you require any reasonable adjustments throughout the recruitment process.