BI Developer - SQL Server, SSIS, MS Azure, SSAS, DAX
My client is a large consumer business based near Camden who is leveraging up-to-date Business Intelligence technologies to accurately inform the ongoing success of its brands. This role is a new position to the BI team, helping their Analysts with Data Development solutions.
My client is a large consumer business based near Camden who are leveraging up-to-date Business Intelligence technologies to accurately inform the ongoing success of its brands. They have a team of Analysts, Developer and DBAs who provide BI solutions within a centralised business function.
As a BI Developer you will work with internally sourced and external data sets to design, develop and maintain BI solutions. Your role will include the development of SQL Server databases including designing/modelling, building and maintaining ETL solutions, enhancing Data Warehousing / Data Marts along with developing Tabular Models with DAX, some database monitoring inclusive of performance tuning and optimisation and also supporting the creation of PowerBI dashboards for business users.
As part of a collaborative and high-performing team, you will understand business needs, translate them into technical specifications and work in an Agile, iterative approach to building and supporting effective BI solutions.
Essential skills & experience:
- SQL Server development within a BI environment
- Database design & dimensional modelling
- Some Database Administration knowledge (monitoring, performance tuning, optimisation etc.)
- SSRS or a similar reporting tool
Desirable skills & experience:
- Tabular Models with DAX
- Microsoft Azure / Cloud tools
My client offers a starting salary of up to £55,000 as well as the opportunity to learn areas such as MS Azure, Tabular Models, SSAS and more.