Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join us as a Data Architect/Database Analyst, shaping data strategies for a key government client.
- Company: Work with a leading organisation in London, making impactful decisions in data management.
- Benefits: Enjoy a hybrid role with competitive daily rates and the chance to work on innovative projects.
- Why this job: Be part of a dynamic team, enhancing your skills while contributing to meaningful data solutions.
- Qualifications: Bring 10+ years of experience in data architecture and strong knowledge of Microsoft cloud tools.
- Other info: Security clearance required; this is a unique opportunity to influence data governance in the public sector.
The predicted salary is between 46800 - 78000 £ per year.
Role: Interim Data Architect / Database Analyst
Contract Length: 9 Months
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 ArchitectYou 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 AnalystYou 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
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
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
- Azure Active Directory (AAD)
- Microsoft SQL Server 2018
- Microsoft SQL Server Integration Services (SSIS)
- Microsoft SQL Server Profiler
- SQL Server T-SQL Programming
- SQL Server Schema Modelling
- Data Modelling, Design and Documentation Tools
- Cloud-based data design/migration technologies
Contact Detail:
Allen Lane Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Architect / Database Analyst (City of London)
✨Tip Number 1
Make sure to brush up on your knowledge of Microsoft cloud-based data management tools, especially Azure SQL Database and Azure Data Factory. Being able to discuss specific projects where you've used these tools will show your expertise and make you stand out.
✨Tip Number 2
Familiarise yourself with the latest trends in data architecture and design, particularly in the financial services sector. This will help you engage in meaningful conversations during interviews and demonstrate your commitment to staying current in the field.
✨Tip Number 3
Network with professionals in the data architecture space, especially those who have experience in government or financial services. Attend relevant meetups or webinars to build connections that could lead to referrals or insider information about the role.
✨Tip Number 4
Prepare to discuss your previous successes in designing data models and implementing data strategies. Having concrete examples ready will not only showcase your skills but also illustrate how you can add value to our team at StudySmarter.
We think you need these skills to ace Data Architect / Database Analyst (City of London)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your relevant experience in data architecture and database analysis. Focus on your achievements in designing data strategies and using Microsoft cloud-based tools, as these are crucial for the role.
Craft a Compelling Cover Letter: Write a cover letter that specifically addresses the requirements of the job. Mention your experience with data modelling techniques and any successful projects you've led, particularly in financial services.
Showcase Relevant Projects: In your application, include specific examples of data architecture solutions you have implemented. Detail your role in these projects and the impact they had on the organisation's data management and reporting capabilities.
Highlight Technical Skills: Clearly list your technical skills related to the job description, such as expertise in Azure SQL Database, T-SQL programming, and data warehousing concepts. This will help demonstrate your fit for the position.
How to prepare for a job interview at Allen Lane
✨Showcase Your Experience
Be prepared to discuss specific examples of data architecture and design solutions you've implemented in previous roles. Highlight your experience in the financial services sector, as this will resonate well with the interviewers.
✨Understand the Tools
Familiarise yourself with Microsoft cloud-based data management tools, especially Azure SQL Database and Azure Data Factory. Be ready to explain how you've used these tools in past projects to optimise data processes.
✨Demonstrate Problem-Solving Skills
Expect questions that assess your ability to troubleshoot database issues. Prepare to discuss how you've handled operational support for databases and any challenges you've faced in transitioning new databases into production.
✨Engage with Stakeholders
Since collaboration is key in this role, be ready to talk about how you've worked with business and technology stakeholders. Share examples of how you gathered requirements and delivered data solutions that added value to the organisation.
