SQL DBA & Data Warehouse Administrator

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

Collaboration & Support

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

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

Skills

• ETL
• SQL
• Microsoft SQL Server
• DBA
• Data Warehouse
• ELT
• Power BI