SQL DBA and BI Developer Information Technology · Guildford
SQL DBA and BI Developer Information Technology · Guildford

SQL DBA and BI Developer Information Technology · Guildford

Guildford Full-Time 36000 - 60000 £ / year (est.) No home office possible
S

At a Glance

  • Tasks: Manage and optimise SQL databases while delivering high-quality analytics through BI.
  • Company: Join a dynamic tech team in Guildford focused on innovation.
  • Benefits: Enjoy competitive salary, health benefits, and opportunities for remote work.
  • Why this job: Make an impact by turning data into actionable insights with cutting-edge tools.
  • Qualifications: Bachelor’s degree in Computer Science or equivalent experience required.
  • Other info: Great career growth potential in a collaborative environment.

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.

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.

SQL DBA and BI Developer Information Technology · Guildford employer: Surrey Satellite Technology Ltd (SSTL)

Join our dynamic team in Guildford as a SQL DBA and BI Developer, where we prioritise innovation and collaboration. We offer a supportive work culture that fosters professional growth through continuous learning opportunities and mentorship, ensuring you can thrive in your career. With competitive benefits and a commitment to data integrity and security, you'll play a vital role in transforming data into actionable insights while enjoying a fulfilling work-life balance.
S

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 Information Technology · Guildford

Tip Number 1

Network like a pro! Reach out to your connections in the industry, attend meetups, and engage with professionals on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.

Tip Number 2

Show off your skills! Create a portfolio showcasing your SQL DBA projects, BI reports, and any data models you've built. This gives potential employers a tangible look at what you can do and sets you apart from the crowd.

Tip Number 3

Prepare for interviews by brushing up on common SQL and BI questions. Practice explaining your past experiences and how they relate to the role. We recommend doing mock interviews with friends or using online platforms to get comfortable.

Tip Number 4

Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search!

We think you need these skills to ace SQL DBA and BI Developer Information Technology · Guildford

SQL Server Administration
Data Warehouse Design
ETL/ELT Pipelines
SAP Datasphere
DAX Optimization
Power Query Transformations
Data Governance
GDPR Compliance
Performance Tuning
Indexing Strategies
Role-Based Access Control (RBAC)
Technical Documentation
Stakeholder Management
SQL/T-SQL Coding Standards

Some tips for your application 🫡

Tailor Your CV: Make sure your CV is tailored to the SQL DBA and BI Developer role. Highlight your experience with Microsoft SQL Server, Data Warehousing, and any relevant BI tools like SAP Datasphere. We want to see how your skills match what we're looking for!

Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about this role and how your background makes you a perfect fit. Don’t forget to mention specific projects or achievements that relate to database administration and BI.

Showcase Your Technical Skills: In your application, be sure to showcase your technical skills clearly. Mention your experience with ETL/ELT processes, performance tuning, and any certifications you hold. We love seeing candidates who can demonstrate their hands-on experience!

Apply Through Our Website: We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and you’ll be able to keep track of your application status. Plus, we love seeing applications come directly from our site!

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. Sharing concrete examples will demonstrate your hands-on experience and problem-solving abilities.

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. Showing familiarity with DAX measures and Power Query transformations will impress the interviewers.

Communicate Effectively

Strong communication skills are essential for this role, especially when translating business requirements into data models. Practice explaining complex technical concepts in simple terms. Being able to engage with stakeholders and convey your ideas clearly will set you apart from other candidates.

SQL DBA and BI Developer Information Technology · Guildford
Surrey Satellite Technology Ltd (SSTL)
Location: Guildford

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

S
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>