About the position
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.
- Minimum 5–7 years of experience in database development, with extensive use of T-SQL (SQL Server).
- Proven experience in ETL design and development using SSIS (or similar tools).
- Hands-on experience with data warehouse design, dimensional modelling, and large-scale database solutions.
- Experience in BI development using Power BI, SSRS, and other reporting tools.
- Solid understanding of source control systems (Git) and CI/CD practices for data solutions.
- Strong problem-solving skills, with a track record of troubleshooting and optimising SQL queries and ETL processes.
- Experience in consuming and integrating APIs (REST/SOAP) into SQL and SSIS processes considered highly advantageous.
- Exposure to cloud-based data solutions (Azure Synapse, Azure Data Factory, or similar) beneficial.
- Knowledge or hands-on experience with Snowflake or IBM Cloud Pak for Data considered a strong advantage.
- Experience working in Agile/Scrum environments.
- Financial services or investment platform experience advantageous.
Minimum Qualifications Required:
- Bachelor’s degree in Information Technology, Computer Science, Information Systems, or a related field.
- A relevant diploma in IT, Data Analytics, or a related field will also be considered if accompanied with hands-on experience in SQL development, ETL processes, and data warehousing.
- Microsoft certifications in SQL Server, Data Engineering, or Power BI (preferred but not mandatory).
- Azure Data Engineer Associate or similar cloud data certification advantageous.
Desired Skills:
- Systems Analysis
- Complex Problem Solving
- Programming/configuration
- Critical Thinking
- Time Management
