At a Glance
- Tasks: Manage and optimise SQL databases while delivering high-quality analytics through BI.
- Company: Join a forward-thinking tech company focused on data-driven solutions.
- Benefits: Enjoy competitive salary, health benefits, and opportunities for professional growth.
- Other info: Collaborate with diverse teams and enhance your skills in a supportive culture.
- Why this job: Make an impact by turning data into actionable insights in a dynamic environment.
- Qualifications: Bachelor’s degree in Computer Science or equivalent experience required.
The predicted salary is between 36000 - 60000 € per year.
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.
Reports To: Infrastructure Manager
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.
Qualifications
PERSON SPECIFICATION (essential requirements)
- 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.
Department: Information Technology
Role: SQL DBA and Data Warehouse Administrator
Location: Guildford
Employment type: Full‑time
Job Reference: 2109
SQL DBA and BI Developer in Guildford employer: Surrey Satellite Technology Ltd (SSTL)
Join a dynamic team in Guildford where innovation meets collaboration! As an SQL DBA and BI Developer, you'll thrive in a supportive work culture that prioritises employee growth and development, offering opportunities to enhance your skills in data management and analytics. With a focus on meaningful projects and a commitment to excellence, we provide a rewarding environment that empowers you to turn data into actionable insights while enjoying a comprehensive benefits package.
Contact Detail:
Surrey Satellite Technology Ltd (SSTL) Recruiting Team
StudySmarter Expert Advice🤫
We think this is how you could land SQL DBA and BI Developer in Guildford
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and join online forums. The more people you know, the better your chances of hearing about job openings before they even hit the market.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL DBA and BI projects. Include reports, dashboards, and any data models you've built. This will give potential employers a taste of what you can do and set you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common SQL and BI questions. Practice explaining your past projects and how you tackled challenges. Remember, confidence is key, so be ready to showcase your expertise!
✨Tip Number 4
Don't forget to apply through our website! We love seeing candidates who are genuinely interested in joining our team. Plus, it makes it easier for us to keep track of your application and get back to you quickly.
We think you need these skills to ace SQL DBA and BI Developer in Guildford
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your SQL DBA and Data Warehouse experience. Use keywords from the job description to show we’re on the same page about what you bring to the table.
Showcase Your Projects:Include specific examples of your work with Microsoft SQL Server, ETL/ELT pipelines, and BI reporting. We want to see how you've turned data into actionable insights in past roles.
Be Clear and Concise:When writing your cover letter, keep it straightforward. Explain why you’re a great fit for the role and how your skills align with our needs at StudySmarter without rambling on.
Apply Through Our Website:Don’t forget to submit your application through our website! It’s the best way for us to receive your details and get the ball rolling on your application.
How to prepare for a job interview at Surrey Satellite Technology Ltd (SSTL)
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss your experience with Microsoft SQL Server, including performance tuning and query optimisation. Practising common SQL queries and understanding how to troubleshoot issues will give you a solid edge.
✨Showcase Your Data Warehouse Expertise
Be ready to talk about your experience with Data Warehouse design and operations. Highlight specific projects where you've implemented star/snowflake schemas or optimised ETL/ELT pipelines. Use examples that demonstrate your ability to manage large datasets and ensure data integrity.
✨Familiarise Yourself with BI Tools
Since this role involves BI reporting, make sure you know your way around tools like SAP Datasphere and Power BI. Prepare to discuss how you've developed and maintained BI datasets and reports in the past, and be ready to share any challenges you faced and how you overcame them.
✨Engage with Stakeholders
This position requires collaboration with various teams, so be prepared to discuss how you've translated business requirements into technical solutions. Think of examples where you've effectively communicated with stakeholders and provided support for BI/data platform incidents.
