SQL DBA and BI Developer

SQL DBA and BI Developer

Reports To Infrastructure Manager

Overview

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

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.