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 a real impact on data management.
- Benefits: Enjoy a hybrid role with a competitive daily rate and the chance to work on exciting 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 strategy 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
Data Architect / Database Analyst employer: Allen Lane
Contact Detail:
Allen Lane Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Architect / Database Analyst
✨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 successfully implemented these technologies will set you apart.
✨Tip Number 2
Familiarise yourself with the latest trends in data architecture and design, particularly in the financial services sector. This will help you demonstrate your understanding of industry best practices during discussions with our team.
✨Tip Number 3
Prepare to showcase your experience with data modelling techniques and T-SQL query optimisation. Having concrete examples ready will help you illustrate your expertise and problem-solving skills effectively.
✨Tip Number 4
Since this role involves collaboration with various stakeholders, practice articulating how you've successfully worked with cross-functional teams in the past. Highlighting your communication skills will be key in demonstrating your fit for the role.
We think you need these skills to ace Data Architect / Database Analyst
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 models, implementing cloud-based solutions, and any specific projects related to financial services.
Craft a Compelling Cover Letter: In your cover letter, explain why you are the perfect fit for this role. Mention your experience with Microsoft cloud-based tools, your understanding of data warehousing concepts, and how you've successfully implemented data strategies in previous roles.
Showcase Relevant Projects: Include specific examples of successful data architecture and design solutions you've implemented. Highlight your experience with Azure SQL Database, Data Lake, and any relevant projects that demonstrate your ability to meet the requirements outlined in the job description.
Proofread Your Application: Before submitting your application, carefully proofread all documents for spelling and grammatical errors. A polished application reflects your attention to detail, which is crucial for a role that involves data management and analysis.
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 and services, 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 provided operational support for DB issues and how you approach problem-solving in a high-pressure environment.
✨Engage with Stakeholders
Since collaboration is key in this role, be ready to talk about your experience working with business and technology stakeholders. Share examples of how you've gathered requirements and delivered data solutions that provide meaningful insights.
