Senior SQL Developer

SUMMARY:
Objective of the Role:

• The purpose of the role is to design, develop, and optimize 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 visualization tools, with a focus on delivering scalable, secure, and maintainable solutions in line with best practices and organizational standards

POSITION INFO:
Key Responsibilities:

• Collaborate with business stakeholders, product owners, operations, and IT teams to analyze requirements and design optimal data solutions
• Translate business needs into technical specifications, including data models, ETL logic, and reporting structures
• Develop, optimize, 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 optimization
• 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 optimization
• 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’ 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 optimizing SQL queries and ETL processes
• Experience in consuming and integrating APIs (REST/SOAP) into SQL and SSIS processes is considered highly advantageous
• Exposure to cloud-based data solutions (Azure Synapse, Azure Data Factory, or similar) is beneficial
• Knowledge or hands-on experience with Snowflake or IBM Cloud Pak for Data is considered a strong advantage
• Experience working in Agile/Scrum environments
• Financial services or investment platform experience is advantageous

• 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 by 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 is advantageous