BI Developer
Role details
Job location
Tech stack
Requirements
This position is to develop the firm's business intelligence (BI) solutions, including extract, transform and load (ETL), data warehousing and analytics. The candidate will have the skills needed to develop solutions using the Microsoft BI technologies and will have a proven experience in applying best practices for delivering business critical BI and reporting services., What technical skills are required for someone to be successful and enjoy the role?
-
Deep knowledge of Microsoft BI technologies including:
-
MDX
-
SSAS
-
SSIS
-
TSQL
-
SSRS
-
Experience of:
-
SQL Server 2016 / 2019
-
Developing and maintaining enterprise grade BI solutions
-
BI systems analysis
Will have been part of a team which was responsible for the successful delivery of at least one major BI solution
- Proven ability to deliver projects on time, with strong organisational, time and task management skills
- A natural enthusiasm for technology and the ability to excite and engage colleagues about BI
- Good knowledge of the principles and best practice in BI development
Desirable
Experience of:
- BI application architecture
- The data vault (DV2.0) data architecture paradigm
- Business intelligence mark-up language (BIML)
- BIML Flex
- Visual Studio Team Services
- Using Visual Studio database projects to manage source control of data assets
- Working as part of an agile development team (SCRUM)
- Power BI
- Master data management/ Master Data Services
- Continuous integration
- Knowledge of design patterns
- Exposure to Microsoft Azure
Who would be a good fit for this role?
As part of the IT team, you would be expected to have the following skills and experience:
- Actively collaborates with others, working towards a shared goal
- Sound analytical mind with the capability to articulate sometimes complex technical concepts
- Ability to effectively prioritise and execute tasks in a high-pressure environment
- A commitment to quality and attention to detail
- Ability to manage their own time to ensure delivery of projects within defined timescales
- A flexible approach, able to cope with several projects at any one time
- A finisher, focused on service delivery
- Commitment to learning new technologies
- Willing to ask questions and share knowledge
- Willing to assist colleagues and take a proactive approach to solving problems
- A natural enthusiasm for technology