Summary Of The Position
- To assume responsibility for the provision of high-quality BI reporting solutions & SQL development support to the business as necessary in order to facilitate an improvement in the quality and speed of decision making.
Key Accountabilities
To deliver BAU BI reporting to support the business, ensuring it is accurate and delivered within given deadlinesTo deliver new BI reporting requirements, along with any associated system and process changes as and when required, to a high standard and within given deadlinesTo ensure that the data used for BI reports, taken from the data warehouse and other information sources as appropriate, is accurate, liaising with other business functions when necessaryTo improve data and reporting processes where possible to streamline the tasks and minimise business continuity risksTo provide support, documentation and training to other BI team members as and when required to ensure that overall BI deliverables are metTo undertake ad-hoc analysis to provide support to the business as and when requiredSkills and Experience | Essential
3+ years SQL and BI development experienceSQL Server 2012 / 2008R2 (creating and implementing production databases, job scheduling)TSQL (queries, views, stored procedures, indexing / performance tuning)SSIS (SQL Server Integration Services) - Project & Package deployment modelsProficient with Microsoft ExcelExperience of QlikView or QlikSense would be advantageousExperience of Microsoft BI components in Azure would be advantageousExperience of C# programming would be advantageousAble to operate in a fast paced commercially driven business environment - must be able to prioritise workloads effectivelyStakeholder engagement - experience of managing multiple business areas and stakeholders (to senior management level) with the ability to capture and shape business requirementsExcellent attention to detail, high levels of accuracy, able to think logicallyDisplays high levels of initiative and a passion for BISkills and Experience | Desirable
MS SQL Server, Integration ServicesExperience of QlikView or QlikSense would be advantageousReporting Services & SSAS - The multidimensional model Tabular model experience is a plus.Azure Databases, Azure Data warehouse & Azure Data factory knowledge is a big plusBachelor's degree in a relevant field is requiredSkills Required
Sql Server 2012, Ssis, Sql, Reporting Services, Azure Data Factory, Ssas, Qlikview, Tsql, Microsoft Excel, Qliksense