BI Consultant – MS BI Stack

Business Intelligence Consultant – Microsoft BI Stack; required for a consultancy firm partnering with world leading clients from financial services, banking and beyond. Working with teams of business intelligence experts on varied and challenging projects, the company offers a dynamic and exciting career opportunity. The company prides itself on internal growth and training and is unrivalled by other consultancies. They are seeking to recruit a BI Consultant to join the growing team in London in their Data Analytics practice.

Location – London / SE-based, but client-facing nature of consultancy life demands you be flexible to travel and work away for extended periods.

Essential Skills:

• Significant SQL Server including extensive experience of – all of – SSIS (Integration Services), SSAS (Analysis Services) & SSRS (Reporting Services)
• Secondary skillset in one of the following: SAS, Looker, Informatica, Cognos, Teradata, or QlikView
• Track record of designing and delivering projects centred on Data Management, Data Warehousing, Data Integration, Data Quality, Data Migration, Business Intelligence.

Desirable Skills:

• Python, R, Cloud (Azure / AWS / GCP)

Candidate Specification:

• A good team player and able to work independently.
• Excellent Client Facing skills.
• A self-starter who is proactive in nature.
• Excellent verbal, written communication and presentational skills.
• Abilities to build cross functional and external relationships.
• Effective negotiating and influencing skills..
• Strong Self Developer

Consulting Manager – Data Analytics

Senior Manager: Edinburgh. As we continue to build and strengthen our capability, an exciting opportunity has arisen to join our consultancy team. We are looking for a dynamic individual, with proven consultancy experience and strong technical skills to join our team of Edinburgh-based specialists.

Essential Requirements:

• Experience in multiple areas – Data Management, Data Warehousing, Data Integration, Data Quality, Data Migration, Business Intelligence, Analytics, Project Delivery across advisory and technical delivery projects.
• Prior experience of one or multiple core Data & BI Solution: SAS, SQL, Teradata, PowerBI, QlikView / QlikSense / QlikCore, Microsoft Stack (SSIS, SSAS, SSRS) and others.
• Project Management skills – Experience of delivering projects across the lifecycle from end to end.
• Senior stakeholder management and interpersonal skills with business/technical focused stakeholders.
• Experience of and capability to discuss client needs for both project delivery and proposal work – translating these into solutions and executing the project.
• Demonstrated ability or experience of building and maintaining client relationships.
• Experience of internal people development.
• Experience of leading people and teams on projects.
• Demonstrated experience of building internal capability and leading propositions and taking new ideas to market.
• Evidence of support, helping and leading sales.
• Flexibility to travel to and work on client sites within the UK and occasionally Europe.
• Minimum 8 years’ experience in consulting.

Key skills:

• A high level of drive with the ability to work to tight deadlines.
• Experience of providing insightful solutions throughout the business.
• The ability to participate effectively in meetings with senior stakeholders.
• A team player who supports, encourages and shares knowledge with others.
• A self-starter with the ability to work under pressure and with limited supervision.
• A track record of accurate output and responsibility for elements of project delivery.
• The ability to work as part of an integrated team or on an individual basis.
• Awareness of industry standards, regulations and developments.

Data Architect, Edinburgh

Data Architect: Our Client are a market-leading Data Management, Data Engineering, Data Visualisation, Analytics and BI consultancy within the UK. They work with clients across all industries, from large Financial Services organisations to small to medium enterprises all of whom require their specialist support.

 

As they continue to build and strengthen their capability, this exciting opportunity has arisen to join them and to broaden and strengthen their consulting base. They are looking for dynamic individuals, with proven experience and strong technical skills to join the team operating out of the Edinburgh HQ

 

As a Data Architect they would expect you to have both knowledge and experience of delivering data driven, organisational transformation, utilising both on premise and cloud data architectures and the various principles and methodologies that support this activity.

 

Essential Requirements:

 

  • Ability to lead the design and build of data architecture either on premise, in the cloud or a hybrid architecture
  • Detailed knowledge of data storage methods and techniques (Data warehousing, Data Lakes, Enterprise Data Hubs, Data Virtualisation) and the practical application of those to meet Business requirements
  • Strong knowledge of data modelling techniques such as Kimball methodologies, data marts, data cubes, star schemas and implementing conceptual, logical and physical data models
  • Strong knowledge of data modelling tools and strong SQL experience and knowledge
  • Experience in application / system architecture, building/ running distributed/ scalable solutions on multiple Cloud Platforms (AWS, Azure, Google etc.). Knowledge of the Cloud Stack (IaaS/ PaaS/SaaS).
  • Evidence of delivering end to end data architecture design and implementation across a range of clients and projects

 

Key Skills:

 

  • Experience of providing insightful solutions to both clients and within the internal business
  • Strong stakeholder management and influencing skills
  • Project Management skills – experience of delivering projects across the lifecycle from end to end.
  • Experience of leading people and teams on projects
  • A self-starter with the ability to work under pressure and with limited supervision
  • Demonstrated experience of building internal capability and leading propositions and taking new ideas to market.
  • An understanding of the consulting sales process and how to support these activities, sales proposals, presentation of recommendations, delivery roadmaps etc

 

In additional to the above the role will require he flexibility to travel frequently to client sites within the UK and occasionally Europe.

Senior Data Engineer – Scotland

Senior Data Engineering Consultant: Our Client is looking for an experienced Data Engineering Consultant to join their existing DE practice (target start date – September). Based out of their HQ in Edinburgh, you will work with their – typically – banking / insurance clients across the region.

As a Senior Data Engineering Consultant, you will have expertise in technical delivery, technologies and concepts in areas such as Data Storage, Data Ingestion, Data Integration, Data Warehousing, Data Preparation and Cloud Infrastructure.

Key Requirements:

c5+ years of experience in a data engineer role developing expert SQL skills PLUS a range of the following complementary skills:

Experience working with the Hadoop ecosystem (Spark, Hive/Impala, Databricks)
Programming background in Java, Scala, R or Python
Experience of cloud platforms such as Azure, AWS or GCP
Experience working with an ETL tool e.g. Azure Data Factory, SSIS & Talend
Understanding of data modelling techniques e.g. Kimball
Experience working with data streams e.g. Kafka
Experience working with large, structured and unstructured datasets
Experience with database technologies (relational, NoSQL, graph)
Expertise with version control e.g. git

Other:

Flexibility to travel to and work on client sites within the UK.
Excellent track record in executive stakeholder management and developing valuable relationships.

Who they are: Our Client is a Data Management and Analytics consultancy, working with leading BI software vendors to enable clients to unlock value and insight from their data. They have c100 consultants working across Retail / Investment Banking, Life & Pensions, and Insurance sectors around the UK. People are at the heart of everything they do and they invest heavily in the training and development of their staff.

Data Engineer

Data Engineering Consultant: Our Client is looking for an experienced Data Engineering Consultant to join their existing DE practice (target start date – September). Based out of their HQ in Edinburgh, you will work with their – typically – banking / insurance clients across the region.

As a Data Engineering Consultant, you will have expertise in technical delivery, technologies and concepts in areas such as Data Storage, Data Ingestion, Data Integration, Data Warehousing, Data Preparation and Cloud Infrastructure.

Key Requirements:

c3+ years of experience in a data engineer role developing expert SQL skills PLUS a range of the following complementary skills:

Experience working with the Hadoop ecosystem (Spark, Hive/Impala, Databricks)
Programming background in Java, Scala, R or Python
Experience of cloud platforms such as Azure, AWS or GCP
Experience working with an ETL tool e.g. Azure Data Factory, SSIS & Talend
Understanding of data modelling techniques e.g. Kimball
Experience working with data streams e.g. Kafka
Experience working with large, structured and unstructured datasets
Experience with database technologies (relational, NoSQL, graph)
Expertise with version control e.g. git

Other:

Flexibility to travel to and work on client sites within the UK.
Excellent track record in executive stakeholder management and developing valuable relationships.

Who they are: Our Client is a Data Management and Analytics consultancy, working with leading BI software vendors to enable clients to unlock value and insight from their data. They have c100 consultants working across Retail / Investment Banking, Life & Pensions, and Insurance sectors around the UK. People are at the heart of everything they do and they invest heavily in the training and development of their staff.

Senior / SAS Consultant

Technical Consultant / SAS Consultant required for a global consultancy firm and certified SAS Institute partner. You will be working with teams of SAS experts on varied and challenging projects within a client portfolio of Financial Services heavyweights ranging from Tier-1 Investment & Retail Banks to emerging challenger banks and established insurance providers.

As a talented, experienced Consultant with 3+years’ experience in developing SAS solutions, your task will be to deliver SAS solutions using a variety of SAS EG (Enterprise Guide), Base SAS, SAS Macros and other SAS products (e.g. SAS DI Studio (Data Integration Studio), SAS Viya, SAS DQ (Data Quality) as per requirements of the client, the project manager or the technical lead. You will have a good proficiency of SAS and polished stakeholder management skills. You will also be responsible for sharing your knowledge with colleagues, and developing junior staff, working with you on site. The client-facing nature of consultancy demands you be willing to travel for work purposes and be happy to stay away from home for extended periods

Essential Skills:

• Highly proficient in Base SAS, SAS Macros PROC SQL and SAS Enterprise Guide
• Any experience with SAS DI / SAS DQ / SAS Viya / DataFlux highly beneficial
• Experienced in general SQL use
• Understands data integration and management principles
• Ability to assimilate business requirements
• Able to translate simple Business requirements into technical design
• Able to manage your own time, delivering as per project / technical lead requirements.
• Provide guidance / coach graduate consultants.
• Plan the design of a project / suite of programs.
• Develop reporting / analytics skills: use what have been learnt doing BAU roles to develop own programs and processes
• Good documentation skills
• Good understanding of version control methodologies
• Understanding of the development life cycle
• Understanding of business process improvements
• Ability to represent processes as process flow or swim lane diagrams
• Unit Testing

Accreditations:

• Base SAS Certification
• Other SAS certifications would be an advantage
• University Degree

Head Office

Newsletter

Enter your email address here always to be updated. We promise not to spam!