Data Architect / Database Analyst

JR United Kingdom; City Of London; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A prominent opportunity for an Interim Data Architect / Database Analyst to support a key government client in London. In a hybrid role, you will define and implement the data strategy while also providing DBA support. This position demands substantial experience in data architecture and extensive knowledge of Microsoft tools.

Qualifications

• Minimum of 10 years relevant experience, especially in data architecture.
• Strong recent experience with Microsoft cloud-based data management tools.
• Ability to create and optimize Power BI reports.

Responsibilities

• Lead the design of data strategies and solutions for clients.
• Provide technical support for all SQL Database environments.
• Document future data management requirements and assess data structures.

Skills

Data modeling techniques

Data warehousing concepts

Master Data Management

T-SQL optimization

Power BI

Microsoft cloud-based tools

Tools

Azure SQL Database

Azure Data Factory

Azure Synapse Analytics

Microsoft SQL Server

SQL Server Integration Services (SSIS)

Job description

Social network you want to login/join with:

Data Architect / Database Analyst, london (city of london)

col-narrow-left

Client:

Location:

london (city of london), United Kingdom

Job Category:

Other

-

EU work permit required:

Yes

col-narrow-right

Job Views:

3

Posted:

16.06.2025

Expiry Date:

31.07.2025

col-wide

Job Description:

Role: Interim Data Architect / Database Analyst

Hybrid Role: 3 days on site in London

Daily Rate: £650, INSIDE IR35

Security Clearance: SC Clearance

The interim Data Architect / Database Analyst will serve in a dual role, split 50% / 50%, to support a key government client in London by defining and implementing its data strategy.

Data Architect

You will have a strong background of delivering excellent data architecture and design solutions (including data process redesign), and a thorough understanding of Microsoft cloud-based data management tools.

You will be playing a leading role in designing the data strategy for the organisation

• Documenting business teams' future requirements for data management, analytics, and reporting
• Reviewing the design of the organisation's current Central Data Store and assessing whether it can meet the future reporting requirements
• Assessing the feasibility and desirability of transitioning CDS to a future cloud-based Enterprise Data Warehouse/Data Lake
• Designing a cohesive data model and data dictionary,
• Collaborating with business and technology stakeholders to assess, plan and implement effective data solutions which optimise the use of technology, reduce operational risk and deliver stakeholder value
• Establishing the Data Architect role and implementing the supporting governance and controls required for the organisation to adhere to industry best practice in the management of its data assets

You must be able to present examples of successful data architecture and design solutions that you have implemented in previous assignments, preferably in the financial services sector

Database Analyst

You will ideally have a background in operational database administration and support within financial services.

You will be providing DBA cover for the IT infrastructure team.

• Providing technical support across all SQL Database environments
• Provide operational support for DB issues initiated from incidents or changes
• Work on projects and provide effective support to project teams to ensure the smooth transition of new databases and initiatives into the production environment

Required Experience:

• The successful candidate will have a minimum of 10 years of relevant experience
• You will demonstrate extensive recent practical experience of designing and implementing data architectural models and the design of a data model and data dictionary
• You will demonstrate strong experience in the use of Microsoft cloud-based data management tools and services
• Ability to contribute to internal processes to support the design of Power BI reports/dashboards and the underlying semantic model, working with stakeholders to understand requirements and present data in a way that provides meaningful insights
• Experience in Investment banking operational environments would be desirable

Technical Requirements

• You must have strong expertise in data modeling techniques
• Data warehousing concepts and tools
• knowledge of Master Data Management (MDM
• Ability to design and optimize T-SQL queries for high-performance data retrieval/manipulation
• Understanding of Azure SQL Database and Azure SQL Managed Instance
• Knowledge of Azure Data Factory (ADF) for ETL Processes
• Experience of Azure Data Lake and Azure Synapse Analytics
• Microsoft SQL Server 2018
• Microsoft SQL Server Integration Services (SSIS)
• Microsoft SQL Server Profiler
• SQL Server T-SQL Programming
• Data Modelling, Design and Documentation Tools
• Cloud-based data design/migration technologies