At a Glance
- Tasks: Manage and optimise SQL databases while delivering insights through Power BI and SAP Datasphere.
- Company: Join a forward-thinking tech company focused on data-driven solutions.
- Benefits: Enjoy competitive pay, flexible work options, and opportunities for professional growth.
- Why this job: Be at the forefront of data analytics and make a real impact in a dynamic environment.
- Qualifications: Bachelor's degree in Computer Science or equivalent experience; SQL DBA skills required.
- Other info: Collaborative culture with excellent career advancement opportunities.
The predicted salary is between 36000 - 60000 £ per year.
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 Power 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.
- Power BI & Analytics Enablement
- Develop and maintain Power BI datasets, semantic models (Tabular), and reports/dashboards following best practices.
- Optimize DAX measures and Power Query transformations for performance and usability.
- Manage Power 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 requirements)
- Qualifications
- Bachelor’s degree in Computer Science, Information Systems, or equivalent experience.
- Relevant certifications are a plus: Microsoft Certified: Azure Database Administrator Associate, Power 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 Power 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 PowerBI Developer in Guildford employer: Surrey Satellite Technology Ltd.
Contact Detail:
Surrey Satellite Technology Ltd. Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land SQL DBA and PowerBI Developer in Guildford
✨Tip Number 1
Network like a pro! Get out there and connect with people in the industry. Attend meetups, webinars, or even local tech events. You never know who might have the inside scoop on job openings or can refer you directly to hiring managers.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL DBA and Power BI projects. Whether it's a GitHub repo or a personal website, having tangible examples of your work can really set you apart from the competition.
✨Tip Number 3
Don’t just apply blindly! Tailor your approach for each application. Research the company, understand their data needs, and mention how your experience aligns with their goals. This shows you're genuinely interested and not just sending out mass applications.
✨Tip Number 4
Apply through our website! We’ve got a streamlined process that makes it easy for you to showcase your skills. Plus, it gives us a chance to see your application in the best light. Don’t miss out on the opportunity!
We think you need these skills to ace SQL DBA and PowerBI Developer in Guildford
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the SQL DBA and Power BI Developer role. Highlight your experience with Microsoft SQL Server, Data Warehousing, and Power BI. We want to see how your skills match what we're looking for!
Showcase Your Projects: Include specific projects where you've managed databases or developed Power BI reports. We love seeing real examples of your work, so don’t hold back on the details that show off your expertise!
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. We appreciate a personal touch that connects your experience to our needs.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy to do!
How to prepare for a job interview at Surrey Satellite Technology Ltd.
✨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 indexing strategies will help you impress the interviewers.
✨Show Off Your Power BI Skills
Since this role involves a lot of Power BI work, be ready to showcase your knowledge. Bring examples of dashboards or reports you've created, and be prepared to explain your approach to optimising DAX measures and Power Query transformations. This will demonstrate your hands-on experience and problem-solving abilities.
✨Understand Data Warehouse Concepts
Familiarise yourself with data warehouse design principles, especially star and snowflake schemas. Be ready to discuss how you've managed ETL/ELT pipelines and ensured data quality in previous roles. This shows that you can handle the operational aspects of the job effectively.
✨Communicate Clearly with Stakeholders
This role requires collaboration with various teams, so practice articulating technical concepts in a way that non-technical stakeholders can understand. Prepare to share examples of how you've translated business requirements into actionable data models and BI solutions in the past.