Senior SQL Developer

The Role

Objective of the Role :

The purpose of the role is to design, develop, and optimise robust data solutions that enable exceptional customer experiences and operational efficiency. The Senior SQL Developer will work collaboratively across business and technology teams to implement high-quality ETL processes, data warehouse solutions, reporting platforms, and analytics tools. The role requires strong technical expertise in SQL, SSIS, data warehousing, and BI visualisation tools, with a focus on delivering scalable, secure, and maintainable solutions in line with best practices and organisational standards.

Key Responsibilities :

• Collaborate with business stakeholders, product owners, operations, and IT teams to analyse requirements and design optimal data solutions.
• Translate business needs into technical specifications, including data models, ETL logic, and reporting structures.
• Develop, optimise, and maintain complex SQL code, stored procedures, and functions.
• Design and implement ETL solutions using SSIS or equivalent tools, ensuring accuracy, performance, and maintainability.
• Build and maintain enterprise data warehouse solutions, including dimensional modelling and performance optimisation.
• Develop and maintain interactive dashboards and reports using Power BI, SSRS, and other BI tools.
• Implement version control and collaborative development practices using Git (branching strategies, pull requests, code reviews).
• Integrate data from multiple sources, ensuring data quality, integrity, and security.
• Work with internal APIs to retrieve, transform, and load data into SQL Server environments, and integrate API-driven processes into SSIS packages where required.
• Monitor and troubleshoot production data processes, providing timely resolution of issues.
• Contribute to architectural design decisions and participate in peer code reviews.
• Implement best practices for database performance tuning, security, and optimisation.
• Support Agile delivery processes, participating in sprint planning, daily stand‑ups, and retrospectives.
• Document technical solutions, processes, and data flows for operational continuity and knowledge sharing.

Skills and Experience

Minimum Qualifications Required :

#J-18808-Ljbffr