SQL DBA & Data Warehouse Administrator

4Square Recruitment Ltd
Guildford
2 months ago
Applications closed

Related Jobs

View all jobs

Data Warehouse Developer

Data Engineer

Senior Data Engineer - (Python & SQL)

Data Engineer Python SQL AWS

Senior Data Engineer - (Python & SQL)

Data Warehouse Developer

4Square Recruitment Ltd provided pay range

This range is provided by 4Square Recruitment Ltd. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.


Base pay range

Direct message the job poster from 4Square Recruitment Ltd


We are seeking a hands‑on SQL DBA with strong Data Warehouse expertise to own, optimise, and secure our data platforms. You will play a key role in enabling high‑quality analytics across the business, delivering insights through Power BI and developing and maintaining reports using SAP Datasphere.


This role combines operational database administration with data warehouse design, ETL/ELT delivery, and BI enablement. You will work closely with business stakeholders, SAP teams, and BI developers to ensure data is reliable, well‑governed, and easy to consume.


Key Responsibilities

Database Administration & Data Warehouse



  • Administer, monitor, and optimise Microsoft SQL Server environments, including backups, patching, log shipping/Availability Groups, and security hardening.
  • Own day‑to‑day Data Warehouse operations, including schema design (star/snowflake), indexing, partitioning, and performance tuning for large datasets.
  • Design, implement, and maintain ETL/ELT pipelines, with appropriate scheduling, error handling, and data quality controls.
  • Manage capacity planning, storage optimisation, and version control for database objects.
  • Ensure data integrity, lineage, and governance in line with GDPR and ISO27001 requirements.

Power BI & Analytics Enablement



  • Develop and maintain Power BI datasets, semantic (Tabular) models, reports, and dashboards in line with best practices.
  • Optimise DAX measures and Power Query transformations for performance and usability.
  • Manage Power BI workspaces, data gateways, refresh schedules, and report lifecycle in collaboration with IT and business teams.

SAP Datasphere Reporting



  • Design, build, and maintain reports and data models integrated with SAP Datasphere.
  • Work with SAP teams to define data contracts, align models, and resolve data access or performance issues.
  • Standardise KPIs and semantic definitions across SAP and non‑SAP sources to deliver consistent, trusted analytics.

Security, Compliance & Reliability



  • Implement RBAC, encryption at rest and in transit, auditing, and policy‑based management.
  • Maintain DR/BCP documentation and runbooks; perform regular restore testing and failover exercises.
  • Monitor platform health using native and enterprise monitoring tools.
  • Translate business requirements into robust data models and BI solutions.
  • Produce and maintain technical documentation and data dictionaries.
  • Provide L2/L3 support for data platform and BI incidents and support the development of junior team members.

Person Specification
Qualifications

  • Bachelor’s degree in Computer Science, Information Systems, or equivalent practical experience.
  • Relevant certifications are desirable (e.g. Microsoft Azure Database Administrator Associate, Power BI Data Analyst Associate, SAP Datasphere).

Experience & Skills

  • Proven experience as a SQL DBA or Data Warehouse Engineer in an enterprise environment.
  • Strong expertise in Microsoft SQL Server administration, including performance tuning, indexing, query optimisation, and HA/DR.
  • Solid experience designing and maintaining Data Warehouse architectures.
  • Hands‑on experience with Power BI (datasets, models, and reporting).
  • Experience building reports and data models using SAP Datasphere, including connectivity, security, and performance considerations.
  • Experience with ETL/ELT tools such as SSIS and/or Azure Data Factory (or equivalent).
  • Strong SQL/T‑SQL skills, including stored procedures, functions, and execution plan analysis.
  • Good understanding of data governance, security controls, GDPR, and audit requirements.
  • Excellent communication skills with the ability to work effectively with technical and non‑technical stakeholders.

Seniority level

Not Applicable


Employment type

Full‑time


Job function

Information Technology


Industries

Technology, Information and Media and IT Services and IT Consulting


#J-18808-Ljbffr

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

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

Industry Insights

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

Careers

How Many Data Science Tools Do You Need to Know to Get a Data Science Job?

If you’re trying to break into data science — or progress your career — it can feel like you are drowning in names: Python, R, TensorFlow, PyTorch, SQL, Spark, AWS, Scikit-learn, Jupyter, Tableau, Power BI…the list just keeps going. With every job advert listing a different combination of tools, many applicants fall into a trap: they try to learn everything. The result? Long tool lists that sound impressive — but little depth to back them up. Here’s the straight-talk version most hiring managers won’t explicitly tell you: 👉 You don’t need to know every data science tool to get hired. 👉 You need to know the right ones — deeply — and know how to use them to solve real problems. Tools matter, but only in service of outcomes. So how many data science tools do you actually need to know to get a job? For most job seekers, the answer is not “27” — it’s more like 8–12, thoughtfully chosen and well understood. This guide explains what employers really value, which tools are core, which are role-specific, and how to focus your toolbox so your CV and interviews shine.

Jobs

What Hiring Managers Look for First in Data Science Job Applications (UK Guide)

If you’re applying for data science roles in the UK, it’s crucial to understand what hiring managers focus on before they dive into your full CV. In competitive markets, recruiters and hiring managers often make their first decisions in the first 10–20 seconds of scanning an application — and in data science, there are specific signals they look for first. Data science isn’t just about coding or statistics — it’s about producing insights, shipping models, collaborating with teams, and solving real business problems. This guide helps you understand exactly what hiring managers look for first in data science applications — and how to structure your CV, portfolio and cover letter so you leap to the top of the shortlist.

Education

The Skills Gap in Data Science Jobs: What Universities Aren’t Teaching

Data science has become one of the most visible and sought-after careers in the UK technology market. From financial services and retail to healthcare, media, government and sport, organisations increasingly rely on data scientists to extract insight, guide decisions and build predictive models. Universities have responded quickly. Degrees in data science, analytics and artificial intelligence have expanded rapidly, and many computer science courses now include data-focused pathways. And yet, despite the volume of graduates entering the market, employers across the UK consistently report the same problem: Many data science candidates are not job-ready. Vacancies remain open. Hiring processes drag on. Candidates with impressive academic backgrounds fail interviews or struggle once hired. The issue is not intelligence or effort. It is a persistent skills gap between university education and real-world data science roles. This article explores that gap in depth: what universities teach well, what they often miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data science.

🍪 We use cookies to enhance your browsing experience on our website. By continuing to use this site, you consent to the use of cookies as described in our Cookie Policy. You can review our Cookie Policy for more information.