Senior BI Developer

Contact Point Resourcing ,
Farnham, Surrey
Job Type: Full-time
Salary: £45,000 per annum

Overview

Senior BI Developer - £45k - £50k - Farnham, Surrey Our client, a Financial Technology company in Farnham are currently recruiting for a Senior BI Developer. This is a really exciting time to join this expanding company who are currently developing new services and projects to offer to their customers. This is a new position within the company and they are looking for an outstanding candidate to join the team. As Senior BI Developer, the role will provide technical analysis, development, testing and warranty support to a wide range of business initiatives, including our own development projects using the very latest technologies and agile development practices. Using expertise in data management, the individual will be required to drive the efficient delivery of business intelligence solutions, initially automation of manual data feeds (circa. 30), as well as building solutions to underpin and accelerate data science and knowledge discovery. The role will provide leadership in transitioning from local reporting mechanisms to using advanced business intelligence tools. The Senior BI Developer will also work alongside stakeholders to build a new Data Warehouse, integrating new products and services, including areas such as AI, and will be expected to keep abreast of new technologies and methodologies to develop innovative solutions to complex issue and drive forward the digital vision. Responsibilities Development and Maintenance of ETL solutions with SQL, SSIS. Producing high quality data warehouse solutions using appropriate technologies Building and maintaining complex Stored procs, Functions, Views and Triggers. Be part of the design, development and maintenance of self-service tools, primarily SSAS cubes. Design, build, and maintain reporting solutions(dashboards, mobile apps) using SQL, data visualisation (Power BI & SSRS) and other business intelligence tools Delivery of operational reporting projects(incl. management reporting) end-to-end in line with business needs Developing an understanding of complex database structures and system architecture Collaborating with stakeholders, business analysts, subject matter experts, and other team members to determine data requirements Documenting technical specifications for Technical approval Manage deployment of changes from development to QA through to release Monitor and resolve performance and stability issues Participate in problem solving and troubleshooting for assigned reports, applications, or projects To manage own time efficiently to ensure that deadlines on multiple tasks/initiatives are met To provide concise, accurate reporting of work progress to BI Manager Provide support to, and deputise for, the BI Manager when required Stay current with changes in the Business Intelligence landscape, in particular ML, and present back to BI Manager Documentation of Database, codes, stored procedures. Use of Dataedo beneficial. Assist in the definition and implementation of database and development standards and knowledge management Ad-hoc project work Establishing dashboards, mobile apps, and accounts: SSRS and Power BI Design and maintenance of intricate data models: Cubes and DAX/MDX queries Data analysis, understanding and application of analytical models Full involvement in BI projects Procedures of Microsoft BI products Background / Experience Required for the Senior BI Developer role: Essential: Minimum 4 years ETL & Data Warehouse development (SSIS, T-SQL,SSAS (multidimensional or tabular)) Minimum 4 years of a Business Analytics Tool - PowerBI / MSSQLSSRS 2-4 years .Net (C# or VB) Machine Learning, Data Science and Big Data Integration experience Experience working in an Agile development environment Experience working with Azure Excellent problem solver with great communication skills Able to build strong and productive relationships quickly Benefits package: Basic salary £45,000 - £50,000 Holiday is 22 days rising to 25 days (1 day every year of service). Pension Annual salary reviews Healthcare plan/ Perkbox Cycle to work/ annual eye tests/ flu jabs etc Great working environment Full training Opportunity for career progression Office is close to Farnham train station / public transport routes.