Data Architect: The purpose of the Data Architect is to develop the architectural blueprint required to manage multiple systems, and couple datasets, including the creation and implementation of data models, policies and standards. You will ensure systems can be integrated, unified and data can be aggregated coherently. The output will provide our colleagues a holistic view of our activities and ensure we have complete knowledge of our stakeholders from across all business areas.

Skills, personal attributes and experience:

• Extensive experience of designing data architecture
• Extensive experience of designing conceptual, logical and physical data models
• Working experience of working with data modelling software
• Working experience of data warehouse design
• Experience of working with technical colleagues to define requirements
• Experience of designing data standards and definitions
• Experience of ETL design
• Experience of implementing or developing Master Data Management
• Experience using SQL, SSIS, SSRS, SSAS
• Experience using Excel to an advanced level
• Working knowledge of BI/MI reporting needs
• Ability to understand business objectives and translate them to data solutions
• Ability to communicate effectively verbally, face to face and in writing
• Ability to work to deadlines and under pressure
• Strong team working and interpersonal skills

Education and qualifications:

• Numerate and literate at degree level (preferably in an analytical subject or equivalent)
• Applied knowledge of data architectural principles
• Working knowledge of Data Protection regulations
• Working knowledge of the voluntary sector (desirable), or a demonstrable passion for, and affinity with, charitable causes.

Senior Data Engineer (9 month fixed term contract) – Nationwide charity: as the technical Data / BI SME on a business-critical data strategy (embracing SQL BI, Cloud tech, Big Data, Data Science), you will be working closely with key stakeholders driving forwards adoption of better data integration and modelling through effective data warehousing to support analytics across the organisation.

You will engage a team of developers to deliver an organisation-wide ETL, data import, and master data management approach. This will be done while fostering an entrepreneurial and creative work ethic, and willingness to learn and adapt to emerging or different technologies. This role will support the delivery of appropriate analytics tools for insight leads in teams across the organisation to be able to build reports and dashboards.

Expected technical experience:

• Leading fast-paced deployment of data solutions in a range of settings
• Expert SQL Data Warehouse Developer with experience delivering enterprise data models, data warehousing and operational data stores, and developing data interfaces for reporting tools such as Power BI.
• Designing extract, transform and load (ETL) processes in a range of technologies e.g. Microsoft Azure Data Factory. Deploying data transformations, including data standardisation.
• Exploring other Microsoft products (Synapse, Data Lake, Power BI, Data Catalog, Knowledge Transfer and other Azure tools)
• Experience of object orientated programming, to enable bulk data manipulation and import procedures (e.g. using Python, R etc).
• Application of Machine Learning in a data integration, cleansing and / or analysis context

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

Senior Manager: London. 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 London-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: 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 their regional HQ in London.

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.