Job Description
Purpose Of The Role:
- Develop an expert understanding of the way BI has been set-up and implemented and become an expert in all existing data sources, how data is utilised for reporting and analysis
- Support data architecture in the transitional and target designs for the overarching BI design. Working with the data development team to agree on design principles and patterns for industry best practice BI implementation
- Assist users across the organisation, analysts, and other developers to find resolutions to data issues and troubleshoot issues with the BI environment where required – provide support for the delivery and adoption of a BI strategy
- Collaborate with business and IT stakeholders to formulate and assess ideas for enhancements to BI and input into prioritisation, impact analysis, estimates and scheduling
- Perform analysis of business requirements to generate functional requirements for enhancements – providing consultancy where needed to help refine requirements and find the best solution and to devise performance and test criteria
- Develop and deliver BI enhancements or new features in line with project or program requirements, as well as supporting/delivering BAU change
- Develop standards, processes, quality and performance criteria for BI Development to ensure consistency across reports
- Work with the architecture team and other members of the applications team to create and maintain a strategic roadmap for BI– including the evaluation of new opportunities to enhance BI and ongoing review of continual changes to the Microsoft BI suite
- MS SQL Server (minimum SQL Server 2012 Enterprise and 3 years development experience)
- T-SQL
- SSIS
- SSAS
- Power BI (desktop and service)
- Dimensional Modelling
GSA Techsource Ltd operates as an Employment Agency when recruiting for permanent vacancies, and an Employment Business when recruiting for contract vacancies. All contract rates quoted are to Ltd companies.