SQL DBA and BI Developer

Surrey Satellite Technology Ltd (SSTL); Guildford; On-site; GBP 50,000 - 70,000; Full time

Job summary

A leading technology company in Guildford is seeking a SQL DBA and BI Developer to manage and optimize their data platforms. The ideal candidate will have extensive experience in SQL Server administration, data warehouse design, and BI reporting. Responsibilities include the management of database operations, design of BI datasets, and collaboration with stakeholders to transform data into actionable insights. This is a full-time position requiring strong communication and technical skills in SQL and BI tools.

Qualifications

• Proven experience as SQL DBA or Data Warehouse Engineer.
• Strong expertise in SQL Server administration including performance tuning and backups.
• Hands-on experience with Business Intelligence (BI) tools.

Responsibilities

• Administer, monitor, and optimize SQL Server instances.
• Implement and maintain ETL/ELT pipelines.
• Design and maintain reports integrated with SAP Datasphere.

Skills

SQL Server administration

Data Warehouse design

ETL/ELT processes

DAX optimization

Power Query transformations

Data governance

Stakeholder management

Education

Bachelor’s degree in Computer Science or Information Systems

Tools

Microsoft SQL Server

SSIS

Azure Data Factory

SAP Datasphere

Job description

SQL DBA and BI Developer

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 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.

BI & Analytics Enablement

• Develop and maintain BI datasets, semantic models (Tabular), and reports/dashboards following best practices.

• Optimize DAX measures and Power Query transformations for performance and usability.

• Manage 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 (Essential)

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or equivalent experience.

• Relevant certifications are a plus: Microsoft Certified: Azure Database Administrator Associate, 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 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.

Details

• Department: Information Technology

• Role: SQL DBA and Data Warehouse Administrator

• Locations: Guildford

• Employment type: Full-time

• Job Reference: 2109