We use cookies to make your experience of using our website better. To comply with the e-Privacy Directive we need to ask your consent to set these cookies.

BI Architect / Solutions Architect - Global Retail Company

col-narrow-left 

Job ID:

43851

Location:

London 

Salary:

£105,000.00 per year
col-narrow-right 

Job Views:

18

Posted:

01/07/2018
col-wide 

Job Description:

BI Architect / Solutions Architect - Global Retail Company

Global Retail Company are recruiting for a BI Architect join their hugely successful and rapidly expanding London based Architecture team. This is a company with a presence in over 200 countries and have enjoyed exponential growth over the past 10 years. They are a Microsoft Gold partner and industry leading in terms of embracing new and emerging technologies.

Responsibilities

  • Owning the technical design of solutions for the BI team, working with the appropriate stakeholders including business and architecture
  • Working with the BI Business Analysts and Data Architect to understand the requirements needed of the data stored in the DWH and how to best make it available
  • Working with the BI and DB Engineering Team Leads to set and maintain standards and development practices ensuring the team delivers to required quality and adheres to best practice
  • Providing guidance to the BI Engineers to ensure their code meets both quality and performance requirements
  • Making sure that data is available to allow BI projects to align with the business strategy
  • Working with IT Architects, technical specialists, third party software vendors and consultants to ensure that the company becomes an innovative developer and adopter of Data Warehousing & BI solutions
  • Working with the Product & Project Managers, to deliver projects to scope, schedule and budget and to deliver commitments to the business
  • Working as part of a Technical Design Authority to ensure consistent high quality designs across the business.
  • Working as an ambassador for the technical capability of the company both internally and externally
  • Being a keen advocate of quality and continual improvement
  • Taking part in team and department level meetings and functions

Required Skills

  • Excellent communication skills and a diplomatic nature
  • Commitment to provide a high level of customer service to internal users
  • Ability to work upon parallel projects to a high standard
  • Good analytical and problem solving skills
  • Knowledge of Data Warehousing, ODS, Data-Marts, CRM and OLAP concepts and designs
  • Proven experience in the successful delivery and ongoing maintenance of complex, high volume, high performing and high quality software systems
  • Working knowledge of big data implementation and associated issues
  • Experience of implementing/supporting cloud-based solutions

In-depth knowledge in most of the following technologies:

  • T-SQL, and the effective use of constraints and Indexes
  • SQL Server 2012, 2014, or 2016 Enterprise Edition, including SSAS
  • Database & Table Partitioning and Data Compression
  • Data Warehousing techniques, methodologies, and data modeling tools
  • SQL Server Security
  • Azure technologies in particular SQL DB and SQL Data Warehouse

Nice to haves:

  • Broader base of knowledge on (some of) the following technologies:
  • Expert SSIS Developer; Lookups, Loops, Cache, Events, and Parameterization
  • Ideally previous experience within the retail industry, eCommerce
  • SQL Server Transactional Replication
  • Microservices architectures and event capture and processing
  • Experience of solutions using any of Hadoop, HDInsight, Spark, Databricks, U-SQL
  • C# / .Net
  • SSRS
  • ORM & the exchange between an object-oriented language and a relational database
  • Experience of working in virtualized environments
  • Source Control, particularly TFS/VSTS
  • Automated deployments, particularly Team City/Octopus, and automated testing
  • Experience of optimizing SSAS for large data volumes and incremental, trickle-in updates
  • Expertise with Microstrategy or PowerBI, or another major end-user reporting platform

BI Architect / Solutions Architect - Global Retail Company

Company Info
Henderson Scott

Company Profile



Company Info


Henderson Scott

Phone:
Web Site:

BI Architect / Solutions Architect - Global Retail Company

col-narrow-left 

Job ID:

43851

Location:

London 

Salary:

£105,000.00 per year
col-narrow-right 

Job Views:

18

Posted:

01/07/2018
col-wide 

Job Description:

BI Architect / Solutions Architect - Global Retail Company

Global Retail Company are recruiting for a BI Architect join their hugely successful and rapidly expanding London based Architecture team. This is a company with a presence in over 200 countries and have enjoyed exponential growth over the past 10 years. They are a Microsoft Gold partner and industry leading in terms of embracing new and emerging technologies.

Responsibilities

  • Owning the technical design of solutions for the BI team, working with the appropriate stakeholders including business and architecture
  • Working with the BI Business Analysts and Data Architect to understand the requirements needed of the data stored in the DWH and how to best make it available
  • Working with the BI and DB Engineering Team Leads to set and maintain standards and development practices ensuring the team delivers to required quality and adheres to best practice
  • Providing guidance to the BI Engineers to ensure their code meets both quality and performance requirements
  • Making sure that data is available to allow BI projects to align with the business strategy
  • Working with IT Architects, technical specialists, third party software vendors and consultants to ensure that the company becomes an innovative developer and adopter of Data Warehousing & BI solutions
  • Working with the Product & Project Managers, to deliver projects to scope, schedule and budget and to deliver commitments to the business
  • Working as part of a Technical Design Authority to ensure consistent high quality designs across the business.
  • Working as an ambassador for the technical capability of the company both internally and externally
  • Being a keen advocate of quality and continual improvement
  • Taking part in team and department level meetings and functions

Required Skills

  • Excellent communication skills and a diplomatic nature
  • Commitment to provide a high level of customer service to internal users
  • Ability to work upon parallel projects to a high standard
  • Good analytical and problem solving skills
  • Knowledge of Data Warehousing, ODS, Data-Marts, CRM and OLAP concepts and designs
  • Proven experience in the successful delivery and ongoing maintenance of complex, high volume, high performing and high quality software systems
  • Working knowledge of big data implementation and associated issues
  • Experience of implementing/supporting cloud-based solutions

In-depth knowledge in most of the following technologies:

  • T-SQL, and the effective use of constraints and Indexes
  • SQL Server 2012, 2014, or 2016 Enterprise Edition, including SSAS
  • Database & Table Partitioning and Data Compression
  • Data Warehousing techniques, methodologies, and data modeling tools
  • SQL Server Security
  • Azure technologies in particular SQL DB and SQL Data Warehouse

Nice to haves:

  • Broader base of knowledge on (some of) the following technologies:
  • Expert SSIS Developer; Lookups, Loops, Cache, Events, and Parameterization
  • Ideally previous experience within the retail industry, eCommerce
  • SQL Server Transactional Replication
  • Microservices architectures and event capture and processing
  • Experience of solutions using any of Hadoop, HDInsight, Spark, Databricks, U-SQL
  • C# / .Net
  • SSRS
  • ORM & the exchange between an object-oriented language and a relational database
  • Experience of working in virtualized environments
  • Source Control, particularly TFS/VSTS
  • Automated deployments, particularly Team City/Octopus, and automated testing
  • Experience of optimizing SSAS for large data volumes and incremental, trickle-in updates
  • Expertise with Microstrategy or PowerBI, or another major end-user reporting platform

BI Architect / Solutions Architect - Global Retail Company