Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead data strategy design and implement solutions for a key government client.
- Company: Join a dynamic team supporting vital government projects in London.
- Benefits: Enjoy a hybrid work model with competitive daily rates and professional growth opportunities.
- Why this job: Make a real impact on data management while working with cutting-edge technology.
- Qualifications: 10+ years of experience in data architecture and strong Microsoft cloud tool expertise required.
- Other info: SC Clearance is necessary; this role offers a unique chance to shape data governance.
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.
Technical RequirementsYou must have strong expertise in data modeling techniques, data warehousing concepts and tools, knowledge of Master Data Management (MDM), and the 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
Network with professionals in the data architecture and database analysis fields. Attend industry meetups or webinars to connect with others who may have insights into the role or even know about opportunities at StudySmarter.
✨Tip Number 2
Familiarise yourself with the latest Microsoft cloud-based data management tools, especially Azure SQL Database and Azure Data Factory. Being well-versed in these technologies will not only boost your confidence but also demonstrate your commitment to staying current in the field.
✨Tip Number 3
Prepare to discuss specific examples of your past work in data architecture and design solutions. Highlighting your experience in financial services can set you apart, so think of relevant projects that showcase your skills and successes.
✨Tip Number 4
Research the key government client you'll be supporting. Understanding their data strategy and challenges can help you tailor your approach during interviews, showing that you're proactive and genuinely interested in contributing to their goals.
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 expertise with Microsoft cloud-based data management tools and any specific projects you've worked on that align with the job description.
Craft a Compelling Cover Letter: In your cover letter, emphasise your dual experience as both a Data Architect and Database Analyst. Provide specific examples of successful data architecture solutions you've implemented, particularly in financial services, to demonstrate your fit for the role.
Highlight Technical Skills: Clearly list your technical skills related to the job requirements, such as data modelling techniques, Azure SQL Database, and T-SQL programming. Use bullet points for clarity and ensure you mention any relevant certifications or training.
Showcase Problem-Solving Abilities: Include examples in your application that showcase your problem-solving abilities, especially in operational database administration. Describe how you've addressed DB issues or contributed to project teams to ensure smooth transitions into production environments.
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 Collaboration Skills
Since the role involves working closely with business and technology stakeholders, prepare to discuss how you've successfully collaborated in the past. Share examples of how you assessed and implemented effective data solutions that added value.
✨Prepare for Technical Questions
Expect technical questions related to data modelling techniques, T-SQL query optimisation, and data warehousing concepts. Brush up on these topics and be ready to demonstrate your knowledge and problem-solving skills during the interview.
