SQL DBA and Data Warehouse Administrator Information Technology · Guildford

Surrey Satellite Technology Ltd (SSTL)
Guildford
1 day ago
Create job alert
SQL DBA and Data Warehouse Administrator

Reports To: Infrastructure Manager


About the Role

We’re looking for a hands‑on SQL DBA with strong Data Warehouse experience who can manage, optimize, and secure our data platforms while delivering high‑quality analytics through Power BI and creating/maintaining reports leveraging SAP Datasphere. This role spans operational database administration, data model governance, ETL/ELT pipelines, and BI/reporting enablement—working closely with business stakeholders, SAP teams, and BI developers to turn data into actionable insights.


Key Responsibilities
Database Administration & Data Warehouse

  • Administer, monitor, and optimize Microsoft SQL Server instances, including backups, log shipping/AGs, patching, and security hardening.
  • Own Data Warehouse operations, including star/snowflake schema design, indexing strategies, partitioning, and performance tuning for large datasets.
  • Implement and maintain ETL/ELT pipelines, including scheduling, error handling, and data quality checks.
  • Manage database capacity planning, storage optimization, and version control for DB objects.
  • Ensure data integrity, governance, lineage, and compliance with GDPR and ISO27001.

Power BI & Analytics Enablement

  • Develop and maintain Power BI datasets, semantic models (Tabular), and reports/dashboards following best practices.
  • Optimize DAX measures and Power Query transformations for performance and usability.
  • Manage Power BI workspace governance, data gateways, refresh schedules, and report lifecycle in coordination with IT and business teams.

SAP Datasphere Reporting

  • Design, build, and maintain reports and data models integrated with SAP Datasphere.
  • Collaborate with SAP teams to define data contracts, ensure model alignment, and troubleshoot data access and performance issues.
  • Standardize semantic definitions and KPIs across SAP and non‑SAP sources to deliver consistent analytics.

Security, Compliance & Reliability

  • Implement role-based access control (RBAC), encryption at rest/in transit, auditing, and policy-based management.
  • Maintain DR/BCP documentation and runbook procedures; perform regular restore tests and failover drills.
  • Monitor system health using native tools and enterprise monitoring.

Collaboration & Stakeholder Engagement

  • Translate business requirements into high‑quality data models and BI solutions.
  • Create and maintain technical documentation and data dictionaries.
  • Provide L2/L3 support for BI/data platform incidents and mentor junior analysts/engineers.

PERSON SPECIFICATION
Qualifications

  • Bachelor’s degree in Computer Science, Information Systems, or equivalent experience.
  • Relevant certifications are a plus: Microsoft Certified: Azure Database Administrator Associate, Power BI Data Analyst Associate, SAP Datasphere certifications.

Experience

  • Proven experience in SQL DBA or Data Warehouse Engineer in enterprise environments.
  • Strong expertise in Microsoft SQL Server administration (performance tuning, indexing, query optimization, backups/restore, HA/DR).
  • Proven experience with Data Warehouse design.
  • Hands‑on with Power BI.
  • Experience building reports/models against SAP Datasphere, including connectivity, permissions, and performance considerations.
  • ETL/ELT tools: SSIS and/or Azure Data Factory (or equivalent).
  • Strong SQL/T‑SQL coding standards, stored procedures, functions, and query plan analysis.
  • Understanding of data governance, privacy (GDPR), security controls, and audit requirements.
  • Excellent communication skills and stakeholder management.


#J-18808-Ljbffr

Related Jobs

View all jobs

SQL DBA & Data Warehouse Administrator

SQL DBA and Data Warehouse Administrator

SQL DBA & Data Warehouse Architect

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

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.