SQL DBA & Data Warehouse Administrator

4Square Recruitment Ltd
Guildford
1 day ago
Create job alert
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

Related Jobs

View all jobs

SQL DBA & Data Warehouse Lead | Power BI & SAP Datasphere

SQL DBA & Data Warehouse Architect

SQL DBA and Data Warehouse Administrator

SQL DBA and Data Warehouse Administrator Information Technology · Guildford

Senior SQL DBA & Data Warehouse Engineer (Power BI)

Senior Data Engineer, SQL, RDBMS, AWS, Python, Mainly Remote

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.

Maths for Data Science Jobs: The Only Topics You Actually Need (& How to Learn Them)

If you are applying for data science jobs in the UK, the maths can feel like a moving target. Job descriptions say “strong statistical knowledge” or “solid ML fundamentals” but they rarely tell you which topics you will actually use day to day. Here’s the truth: most UK data science roles do not require advanced pure maths. What they do require is confidence with a tight set of practical topics that come up repeatedly in modelling, experimentation, forecasting, evaluation, stakeholder comms & decision-making. This guide focuses on the only maths most data scientists keep using: Statistics for decision making (confidence intervals, hypothesis tests, power, uncertainty) Probability for real-world data (base rates, noise, sampling, Bayesian intuition) Linear algebra essentials (vectors, matrices, projections, PCA intuition) Calculus & gradients (enough to understand optimisation & backprop) Optimisation & model evaluation (loss functions, cross-validation, metrics, thresholds) You’ll also get a 6-week plan, portfolio projects & a resources section you can follow without getting pulled into unnecessary theory.

Neurodiversity in Data Science Careers: Turning Different Thinking into a Superpower

Data science is all about turning messy, real-world information into decisions, products & insights. It sits at the crossroads of maths, coding, business & communication – which means it needs people who see patterns, ask unusual questions & challenge assumptions. That makes data science a natural fit for many neurodivergent people, including those with ADHD, autism & dyslexia. If you’re neurodivergent & thinking about a data science career, you might have heard comments like “you’re too distracted for complex analysis”, “too literal for stakeholder work” or “too disorganised for large projects”. In reality, the same traits that can make traditional environments difficult often line up beautifully with data science work. This guide is written for data science job seekers in the UK. We’ll explore: What neurodiversity means in a data science context How ADHD, autism & dyslexia strengths map to common data science roles Practical workplace adjustments you can request under UK law How to talk about your neurodivergence in applications & interviews By the end, you’ll have a clearer sense of where you might thrive in data science – & how to turn “different thinking” into a real career advantage.

Data Science Recruitment Trends 2025 (UK): What Job Seekers Need To Know About Today’s Hiring Process

Summary: UK data science hiring has shifted from title‑led CV screens to capability‑driven assessments that emphasise rigorous problem framing, high‑quality analytics & modelling, experiment/causality, production awareness (MLOps), governance/ethics, and measurable product or commercial impact. This guide explains what’s changed, what to expect in interviews & how to prepare—especially for product/data scientists, applied ML scientists, decision scientists, econometricians, growth/marketing analysts, and ML‑adjacent data scientists supporting LLM/AI products. Who this is for: Product/decision/data scientists, applied ML scientists, econometrics & causal inference specialists, experimentation leads, analytics engineers crossing into DS, ML generalists with strong statistics, and data scientists collaborating with platform/MLOps teams in the UK.