SQL Developer at Agile Solutions GB

This position will be subject to additional screening requirements. This position is to work with one of our clients that require you to have security clearance or able to obtain this with no prior convictions and permanent and unrestricted right to live and work in the UK.

About Agile Solutions

Agile Solutions GB Ltd is focused on deriving true value from its customers data. We help them to manage, monetise, leverage and make better use of it. We provide advice, support and delivery services across various industry sectors covering a multitude of areas, ranging from Data Strategy, Governance and Security to Data Platform Modernisation, Cloud and Customer Intelligence. We do everything with a view to creating tangible business benefits for our customers. To achieve them, our Agile Information Management framework allows us to measure how we are performing and ensures we deliver the value that our customers deserve.

Summary

As an SQL Developer at Agile Solutions, you will be responsible for designing, developing, and maintaining our database systems to ensure optimal performance and reliability. You will work closely with various teams to support data integration, data warehousing, and analytical needs. Your expertise will contribute to the overall success of our data-driven initiatives. 

Responsibilities

• Design, develop, and maintain SQL queries, stored procedures, and functions to support application development and reporting requirements.
• Develop and optimise complex SQL queries to ensure efficient data retrieval and processing.
• Design and implement data warehousing solutions, including ETL processes, to support business intelligence and reporting needs.
• Develop and maintain data models, including dimensional models, to support analytical reporting and data visualisation.
• Ensure data quality and integrity by implementing robust data validation and cleansing procedures.
• Collaborate with business analysts, data analysts, and other stakeholders to understand data requirements and deliver solutions that meet business needs.
• Participate in database performance tuning and optimisation efforts to ensure high performance and scalability.
• Provide support for database-related issues, including troubleshooting, debugging, and resolving data discrepancies.
• Create and maintain documentation for database designs, processes, and procedures.

Essential Skills

• Proficiency in SQL development, including writing complex queries, stored procedures, and functions.
• Experience with data warehousing concepts and implementation.
• Strong understanding of dimensional modelling and its application in data warehousing.

Desired Skills

• Experience with Data Vault methodology.
• Knowledge of SQL Server Integration Services (SSIS) for ETL processes.

DE&I

At Agile Solutions, we are dedicated to fostering a diverse, equitable, and inclusive workplace. We believe that diversity drives innovation and fosters creativity. We actively promote diversity and inclusion through our hiring practices, employee development initiatives, and company culture. We are committed to providing equal opportunities for all employees, regardless of race, ethnicity, gender, sexual orientation, age, ability, or background.

Join us in creating a workplace where everyone feels valued, respected, and empowered to succeed.