BI Developer - SQL, SSRS, SSAS, SSIS

We are looking for an experienced BI Developer with strong experience in microsoft stack technologies: SQL, SSRS, SSAS, SSIS and Power BI. This is a great opportunity to work on a greenfield project for a company that is going through a tech transformation.

What the role will be doing:

• Creating and maintaining the Data Platform analytics technical components. This includes relational data modelling, star schemas, reporting views and ETL batch feeds
• Producing and automating delivery of key metrics and KPIs to the business. In some cases, this will focus on making data available and others will be developing full reports for end users
• Managing the Data Platform roadmap ensuring technical future proofing, capacity and optimisation of the platform
• Working with the Service Management team to resolve any production issues that require specialist support during normal business hours
• Managing stakeholder demand and backlog of reporting requirements and needs
• Maintaining relationships with key vendors to plan and adapt the Data Platform roadmap and best leverage the capabilities that we have
• Monitoring usage of the Data Platform and working with users to deprecate reports and data sets that are not needed and creating a continuous improvement model for the data
• Actively working with users to understand data issues, tracing back data lineage and helping the business put appropriate data cleansing and quality processes in place
• Managing secure access to data sets for the business

What experience is needed:

• Proven Business intelligence and data experience gained in previous roles
• Extensive experience developing using SQL, relational databases and data warehousing technologies. Primary skill required SQL, SSRS, SSAS, SSIS, Power BI, Power Query and DAX
• Strong coding skills and ability to write and de-bug ad hoc queries using various tools. Python and understanding of Machine Learning is a nice to have
• Working knowledge of REST APIs
• Desirable to have working knowledge of SalesForce data structures

For finer details on the role please contact Amanda Cager - amanda.cager@projectpeople.com - 07796 302988.

Project People is acting as an Employment Agency in relation to this vacancy.