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
#J-18808-Ljbffr