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 contributions to 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: This is a 9-month interim role requiring SC clearance; ideal for those seeking impactful work.
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 (City of London) employer: Placed
Contact Detail:
Placed 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 successfully implemented these technologies will set you apart during discussions.
✨Tip Number 2
Familiarise yourself with the latest trends in data architecture and governance, particularly within the financial services sector. This will not only help you understand the role better but also allow you to engage in meaningful conversations with stakeholders about best practices.
✨Tip Number 3
Prepare to showcase your experience in designing data models and dictionaries. Have examples ready that demonstrate how your previous work has optimised data management and reporting processes, as this is crucial for the role.
✨Tip Number 4
Network with professionals in the field, especially those who have worked in government or financial services. Engaging with them can provide insights into the specific challenges faced in these environments and may even lead to valuable referrals.
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 role.
How to prepare for a job interview at Placed
✨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 and how they can benefit the organisation.
✨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, think of examples where you've worked with business and technology stakeholders. Be ready to discuss how you gathered requirements and delivered effective data solutions that added value.
