Back to jobs
Job Description
What you’ll do
Design, develop, optimise, and maintain complex SQL queries, stored procedures, and database functions.Ensure data integrity, performance optimisation, and reliability of SQL-based data platforms.Collaborate with data analysts, business analysts, and stakeholders to understand data and reporting needs.Gather and document detailed business requirements and translate them into technical specifications.Design database schemas, tables, views, indexes, and supporting database objects.Build scalable data models and database architectures aligned with business objectives.Develop and maintain ETL pipelines using GCP BigQuery to ingest, process, and store large datasets.Optimise BigQuery solutions for performance and cost efficiency.Develop and execute unit tests, and support integration and system testing activities.Identify, troubleshoot, and resolve defects and performance issues.Prepare database deployment scripts and coordinate releases with DevOps and IT teams.Monitor production systems and provide ongoing maintenance and operational support.Implement database security, backup, and recovery procedures.Design and develop dashboards and analytical stories using SAP Analytics Cloud (SAC).Ensure accuracy, consistency, and reliability of analytics reports and visualisations.Maintain clear, up-to-date documentation for database designs, ETL processes, and analytics solutions.