Senior Power Bi Developer

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.