Details:
- Salary: £45,000 - 55,000 - Annum
- Job Type: Permanent
- Job Status: Full-Time
- Salary Per: Annum
- Location: Coventry
- Date: 1 day ago
Description:
Pertemps, the UK’s largest independent recruitment agency is looking to recruit an experienced BI Lead Developer to join their Business Intelligence Team. The successful candidate will have at least 5 years’ experience working with SQL Server and its associated tools. They will be confident in using a variety of techniques to extract data from multiple data sources. The BI team has recently developed an Azure SQL Data Warehouse so experience of ADF and the management of ETL and data pipelines would be highly advantageous.
PLEASE NOTE THIS IS AN OFFICED BASED POSITION 5 DAYS A WEEK IN THE OFFICE IN THE WEST MIDLANDS
The main purpose of the job is:
Reporting to Head of Data, the BI Lead Developer is responsible for the development of reporting solutions. In this role the individual will have responsibility for the technical design of reporting solutions, being able to identify and develop the correct approaches in order to meet customer requirements.
The key accountabilities of the job are:
Managing the reporting lifecycle, including
Analysing, specifying & customer requirements for the BI Team
Building, testing & deploying solutions to customers
Maintaining software and managing improvements
Supporting customers in requesting and using information, including
Understanding customer requirements for information & analysis
Disseminating information about existing reporting & analysis
Developing new reporting & analysis solutions
Liaise with key stakeholders within the Business to understand and define the business requirements, taking advantage of technical advances whilst minimizing business risk to arrive at optimum solutions for the business
To be aware of Service Level Agreements, business requirements and act accordingly
Critical technical skills
Power BI
Microsoft SQL Server including
T-SQL
Data Warehouse Design
Understanding of current IT environment and architecture options, benefits and methodologies.
Desired technical skills
Azure Data Factory
Experience of managing ETL/data pipelines, Azure Data Factory and Azure SQL Data Warehouse
Business Objects
SSIS
SSRS
Data Warehouse Design
The critical activities of the job are:
Participate in business analysis activities to gather required reporting
Translate business requirements into specifications that will be used to implement the required reports and dashboards, created from potentially multiple data sources
Identifying the central and underlying issues in situations and problems
Applying logic and system to analysing information and developing solutions
Using initiative and proactivity to deal with situations, acting in a resourceful and self-directed way to identify and resolve difficulties
Being able to manage conflicting priorities and revise plans due to unexpected changes in workload
Provide support as required to ensure the availability and performance of developed reports for both external and internal users
Provide technical assistance and cross training to other team members.
Design and implement technology best practices, guidelines and repeatable processes
Must be able to perform duties with moderate to low supervision
Taking responsibility for making things happen, in order to deliver reporting solutions in a timely fashion
Confident and committed approach, demonstrating clear belief in own skills and capabilities when supporting customer requests and dealing with their problems
Effective scheduling so that deadlines and priorities are met
Documenting programs and amendments as appropriate
Establishing and maintaining an effective network of contacts to draw on as sources of information
Manage the uploading of company news, documentation and policies to the company intranet.
The jobholder will ideally express:
A strong personal commitment to the team, sharing information and pooling ideas, collaborating with others to solve problems
Initiative, taking personal responsibility for making things happen, introducing new ideas, making opportunities to push forward
Self-confidence, approaching new developments and enhancements with a positive ‘can do’ attitude, believing in own skills and capabilities and judgment
A clear commitment to exceeding customer requirements and delivering a high quality service. Maintaining regular contact with customers until their problems are resolved
Ability to plan and organise time effectively, scheduling work to fit in with deadlines and balancing work priorities to meet them
Logic and systematic thinking, analysing situations to identify causes and develop appropriate plans
A flexible thinking style, applying concepts and principles to draw logical conclusions and recognising connections or patterns and inconsistencies or discrepancies in data
A clear understanding of the business and how it operates, so that actions will be entirely appropriate and focused
Ability to identify and achieve objectives seeing them through to completion
Innate interest in data and related technologies, visualisation, big data, AI, ML, keeping abreast of related current trends and thinking