BI Solutions Architect

BI Solutions Architect This is an exciting opportunity to join an international ‘blue chip’ company involved in a major IT transformation and business change programme. The role of the BI Team Lead is to take responsibility for improving the BI capability of the company. Currently there is a legacy landscape of five data warehouse platforms aligning with individual brands and the company is in the process of adding a CRM Customer warehouse to its portfolio of systems. These systems are aging, lack automation and utilise duplicate technologies and tooling so require refactoring, consolidation and rationalisation. Job Purpose: The company’s business Intelligence systems require ground up re-engineering, consolidation and migration from an on premise to a cloud hosted model as well as the replacement of current technologies with target open source solutions. There is a focus on improved analytics and reporting and this requires building internal expertise in order to deliver a new platform for BI Services which will support the company’s strategic objectives. An experienced BI architect is therefore sought with experience of open source, cloud technologies and big data analytics. Candidates should also have exposure to CRM and Customer analytics and have worked with leading marketing platforms such as Adobe or Apteco. Key skills – Advanced SQL, SQLServer, Oracle, MySQL. Database architecture, warehouse and data mart schema design, Extract Transform and Load design, NOSQL data storage using tools such as Hadoop and associated analytical tools such as Hive, Impala, good exposure to leading reporting technologies, relational, OLAP and Dashboard technologies such as Qlikview, Tableau, Power BI. Understanding of marketing and CRM technologies such as Adobe, Force com, Apteco. As the company is a multibrand business the role will require significant stakeholder management skills as the MI team manages competing demand from a number of individual brands as well as supporting project demand relating to data extraction and provision. Knowledge / Background / Experience: An experienced technical leader with a track record of delivering effective analytical and data warehousing platforms. The candidate should be able to demonstrate the following commercial and business leadership: • Management of complex demand profile with multiple stakeholders across a distributed, global, multi-brand organisation • Experience of working in a fast paced organisation which is results driven where strategic intent and direction needs to be balanced with early delivery • Experience of working with a team of solution architects taking responsibility for data processing, data management, master data and reference data architecture and analytical solution design The candidate is expected to have the following technical knowledge and experience: • Enterprise Warehouse design and implementation • Data modelling and warehouse design for relational and NoSQL reporting platforms • Data warehousing architecture and design across all aspects of an Enterprise data management platform: o Extract Transform and Load process design and delivery using a broad range of solutions (Ab-Initio, Informatica, Talend, SSIS, DataStage) o Reporting tool configuration and setup ( Business Objects, Cognos, MicroStrategy) o Experience of supporting and delivering services using database marketing technologies ( Faststats, Exact Target, Adobe ) o Good knowledge and exposure to NoSQL technologies and open source data analytics tools ( Hadoop, Mongo, BigTable, Pentaho, Talend) o Experience of working with statistical analysis technologies and / or data mining technologies ( SAS, SPSS etc) o Detailed knowledge of SQL • Experience of designing solutions for integrating unstructured data such as clickstream and analytics data from solutions such as Qubit and Google Analytics and integrating this with more structured transactional data • Database architecture and configuration (SQLServer / Oracle) and experience of delivering an Enterprise warehouse design end to end using relational and non-relational models • Experience of designing solutions for open source analytical architecture ( NoSQL, Cloud, Complex Event Processing) • Designing and implementing data warehousing and analytical solutions using cloud based delivery platforms, such as AWS or Openstack, including scripting and automation of the development and release process • Data warehouse migration and consolidation design • Reference Data architecture, data quality management and data governance processes • Agile project delivery

85000.00