Principal Data Architect

La Fosse
Greater London
2 weeks ago
Create job alert

Principal Data Architect - Remote or Hybrid Working - £160,000 package - FS Sector

We are looking for an experienced Principal Data Architect to lead the design, implementation, and optimisation of cloud-based database solutions. In this senior role, you will drive the strategy, architecture, and operations of database systems, with a particular emphasis on Microsoft SQL Server RDS on AWS. The ideal candidate will have extensive experience working with cloud databases and a strong passion for leveraging technology to support business objectives.

Key Responsibilities:

Design and Architecture:

  • Lead the development of scalable, reliable, and high-performance database solutions, with an initial focus on Microsoft SQL Server RDS in AWS.
  • Design and optimise database models, schemas, and performance strategies to support transactional and analytical workloads.
  • Establish robust backup and recovery processes to maintain data integrity and security in cloud environments.

Implementation and Deployment:

  • Oversee the setup and configuration of AWS RDS, DynamoDB, and other database technologies to ensure optimal performance, availability, and scalability.
  • Implement monitoring, logging, and alerting mechanisms to maintain database health and meet service-level agreements.
  • Lead and execute database migration projects, including moving MS SQL Server instances from EC2 to AWS RDS.

Optimisation and Performance Tuning:

  • Analyse and enhance database performance to ensure efficient resource utilisation and rapid response times.
  • Collaborate with application developers to optimise SQL queries, indexing strategies, and overall database architecture.

Leadership and Collaboration:

  • Provide technical leadership and guidance to database administrators and engineers, promoting best practices across database operations.
  • Work closely with cloud engineers, software developers, and IT teams to integrate database solutions within broader technology ecosystems.
  • Develop and maintain standards for database design, security protocols, and operational procedures.

Security and Compliance:

  • Ensure compliance with industry regulations and security frameworks (e.g., PCI-DSS, GDPR).
  • Implement encryption, access controls, and auditing mechanisms to protect sensitive cloud-stored data.

Required Experience:

  • 5+ years of experience in database design, implementation, and support of Microsoft SQL Server.
  • 2+ years of experience in designing, deploying, and managing RDS for SQL Server in AWS environments.
  • Strong expertise in T-SQL, including debugging and optimising complex stored procedures and functions.
  • Proven experience leading cloud database migration projects, preferably to AWS.
  • In-depth understanding of database architecture and real-world experience with various database technologies.
  • Expertise in Microsoft SQL Server technologies, including high availability (HA), disaster recovery (DR), replication, clustering, and read replicas.
  • Strong proficiency in configuring and managing RDS for SQL Server.
  • Knowledge of AWS database services such as RDS for MS SQL, RDS for Oracle, Aurora, DynamoDB, ElastiCache, S3, OpenSearch, and Athena.
  • Experience in SQL query optimisation, indexing, and performance tuning.
  • Understanding of database security best practices.
  • Familiarity with DevOps methodologies, including CI/CD pipelines and Infrastructure as Code, is a plus.

Seniority level

Director

Employment type

Full-time

Job function

Information Technology

#J-18808-Ljbffr

Related Jobs

View all jobs

Principal Data Architect

Principal Data Architect

Principal Data Architect

Principal Data Architect

Principal Data Architect, Consulting

Principal Data Enterprise Architect

Get the latest insights and jobs direct. Sign up for our newsletter.

By subscribing you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Tips for Staying Inspired: How Data Science Pros Fuel Creativity and Innovation

Data science sits at the dynamic intersection of statistics, computer science, and domain expertise, driving powerful innovations in industries ranging from healthcare to finance, and from retail to robotics. Yet, the daily reality for many data scientists can be a far cry from starry-eyed talk of AI and machine learning transformations. Instead, it often involves endless data wrangling, model tuning, and scrutiny over metrics. Maintaining a sense of creativity in this environment can be an uphill battle. So, how do successful data scientists continue to dream big and innovate, even when dealing with the nitty-gritty of data pipelines, debugging code, or explaining results to stakeholders? Below, we outline ten practical strategies to help data analysts, machine learning engineers, and research scientists stay inspired and push their ideas further. Whether you’re just starting out or looking to reinvigorate a long-standing career, these pointers can help you find fresh sparks of motivation.

Top 10 Data Science Career Myths Debunked: Key Facts for Aspiring Professionals

Data science has become one of the most sought-after fields in the tech world, promising attractive salaries, cutting-edge projects, and the opportunity to shape decision-making in virtually every industry. From e-commerce recommendation engines to AI-powered medical diagnostics, data scientists are the force behind innovations that drive productivity and improve people’s lives. Yet, despite the demand and glamour often associated with this discipline, data science is also shrouded in misconceptions. Some believe you need a PhD in mathematics or statistics; others assume data science is exclusively about machine learning or coding. At DataScience-Jobs.co.uk, we’ve encountered a wide array of myths that can discourage talented individuals or mislead those exploring a data science career. This article aims to bust the top 10 data science career myths—providing clarity on what data scientists actually do and illuminating the true diversity and inclusiveness of this exciting field. Whether you’re a recent graduate, a professional looking to pivot, or simply curious about data science, read on to discover the reality behind the myths.

Global vs. Local: Comparing the UK Data Science Job Market to International Landscapes

How to evaluate salaries, opportunities, and work culture in data science across the UK, the US, Europe, and Asia Data science has proven to be more than a passing trend; it is now a foundational pillar of modern decision-making in virtually every industry—from healthcare and finance to retail and entertainment. As the volume of data grows exponentially, organisations urgently need professionals who can transform raw information into actionable insights. This high demand has sparked a wave of new opportunities for data scientists worldwide. In this article, we’ll compare the UK data science job market to those in the United States, Europe, and Asia. We’ll explore hiring trends, salary benchmarks, and cultural nuances to help you decide whether to focus your career locally or consider opportunities overseas or in fully remote roles. Whether you’re a fresh graduate looking for your first data science position, an experienced data professional pivoting from analytics, or a software engineer eager to break into machine learning, understanding the global data science landscape can be a game-changer. By the end of this overview, you’ll be better equipped to navigate the expanding world of data science—knowing which skills and certifications matter most, how salaries differ between regions, and what to expect from distinct work cultures. Let’s dive in.