Feb 15, 2017
The Company The Technology division of Exsurgo is currently recruiting a BI Developer for our multi-channel Fashion Retail client, who are based in Central London. The BI Developer will be responsible for supporting the design, implementation, and maintenance of a new data warehouse and SSAS cube, providing ongoing proactive maintenance and support of the solution and the production of new business reports. The Role - Supporting a custom WSSI (Weekly Sales & Stock Intake) Interface with data ed across systems. - Liaising with business units and business analysts to understand reporting requirements and provide guidance on the best use of BI technology. - Building and developing reports to support business needs. - Working with third party databases such as Google Analytics, emailing service provider (ESP) databases and Salesforce. - Query tuning. - Research, development, and implementation of innovative reporting solutions. - Pro-actively monitoring the reporting environment and presenting new ideas to improve the solution. - Consulting on DB/BI problems, and providing suitable solutions. - Working with the DBA who maintains, administers and supports the SQL Servers Experience - Experience with Microsoft SQL Server 2008/2012/2014. - Experience with the full stack (SSIS/SSRS/SSAS) - Experience of normalised (OLTP) and denormalised (OLAP) data sources - Experience in conceiving, designing, building and maintaining data warehouse/BI Solutions using the Microsoft platform. - Fluent in T-SQL and knowledge of MDX. - SSRS - Report design, dashboards, deployment, data-driven subscriptions, caching, security management - SSIS - Package creation, data quality, error handling - Experience with a BI presentation later tool for data visualisation. E.g Tableau, TargIT, Qlikview. - Knowledge of Microsoft Dynamics NAV ERP or mid-market ERP solutions based on SQL - Dimensional modeling experience (Kimball) Successful candidates will be contacted about this role and similar roles. Connect with us. Follow us on or LinkedIn to hear about our other roles and more!
exsurgo London, UK Contractor