SQL Developer
Department:
Ampa Group Services - Chief Information Office - Applications & Development - Applications & Development - 9311 Employment Type:
Permanent - Full Time Location:
Flexible Reporting To:
Marc Mahoney
Description
Are you an experienced SQL Developer looking for a (remote-first) opportunity within a growing professional services firm? Then please read on!
This role is part of the maturing of our IT Organisation, adding specialisation and technical knowledge into the Applications and Development team to help us support our IT project portfolio and current technologies.
What you will be doing:
Design, develop, test, and optimise SQL-based solutions Collaborate with a team of developers, designers, and project managers to identify business requirements and translate them into technical specifications Perform data analysis and ensure data quality by performing data validation and quality checks Use DevOps for workload management and version control Monitor reporting performance and optimise solutions to ensure maximum efficiency and scalability Ensure compliance with data privacy and security standards Provide technical support and troubleshoot reporting-related issues Create visualisations and reports for requested projects Conduct unit testing/test-driven development processes and troubleshooting Evaluate and improve existing SQL-based solutions Stay up to date with the latest trends and technologies in SQL development. Key Tasks Become familiar with the applications, integrated solutions, backlogs and current roadmaps as well as the supported business processes Participate in Agile Ceremonies. Begin to undertake testing tasks, progressing to basic modifications and creations of features and then on to more complex developments. This will be achieved by: Developing and supporting new and existing SQL applications and integrations across the organisation’s application architecture within our Agile Delivery Processes Proposing and implementing solutions to business requirements that align with our product roadmap and architecture Supporting Change and Release Management processes as part of the software development lifecycle Working as part of a team to transform the Application Architecture of the organisation and formalise best practice standards and methodologies.
What you will need:
A minimum of 5 years demonstrable track record of successful delivery of complex technical applications and services.
You will need to have previous experience with the below tech stack: Extensive experience in Microsoft SQL development, including Integration Services (SSIS), Reporting Services (SSRS)/PowerBI, Azure (Data Factory, Data Lake & Analytics) Strong knowledge of T-SQL programming, Power Query and DAX Experience with SQL Server both on-premises and cloud-based Experience with database schema design and implementation Experience with Visual Studio Strong knowledge of ETL (Extract, Transform, Load) processes and tools, such as SSIS Experience in data preparation and data warehousing projects Experience with web services and APIs Experience with DevOps and version control systems Strong analytical and problem-solving skills Knowledge of data modelling and data architecture Excellent analytical and problem-solving skills Ability to work independently and as part of a team Strong communication and collaboration skills.
Experience with the following would be beneficial: DevOps Automated Testing Microsoft Fabric Microsoft .Net
Benefits, Agile Working and Additional information
We embrace agile working and offer a blended approach to where and how we work.
We appreciate that people have different needs and preferences and we’re keen to be flexible, after all, we value what you do, not where you do it.
We have the following hubs across the UK: Birmingham, Bristol, Leicester, Lincoln, London, Milton Keynes, Nottingham, Solihull, Stratford upon Avon, Sheffield and in the South; Crawley, East Grinstead, Lewes, Brighton, Eastbourne, Seaford, Peacehaven, Storrington, Chichester & Southampton as well as our Scotland office located in Edinburgh.
Additional information Want to find more about our
amazing benefits
? Please be aware, for some vacancies, where we receive high numbers of applications we may need to bring the close date forward. Due to the nature of the work undertaken, confirmation of employment will be subject to a variety of checks which will be carried out once an offer of employment is accepted. Details of the checks can be found
here .
Equal opportunities Ampa Group is a committed equal opportunities employer. We seek to attract, develop and retain talented people from a diverse range of backgrounds and cultures. We value and respect individuality and encourage a culture within our business where people can be themselves and be valued for their strengths and experiences. Everyone who either applies to or works for the firm is treated equally, regardless of their gender, age, ethnic origin, nationality, marital status, sexual orientation or religious beliefs.
#J-18808-Ljbffr
Department:
Ampa Group Services - Chief Information Office - Applications & Development - Applications & Development - 9311 Employment Type:
Permanent - Full Time Location:
Flexible Reporting To:
Marc Mahoney
Description
Are you an experienced SQL Developer looking for a (remote-first) opportunity within a growing professional services firm? Then please read on!
This role is part of the maturing of our IT Organisation, adding specialisation and technical knowledge into the Applications and Development team to help us support our IT project portfolio and current technologies.
What you will be doing:
Design, develop, test, and optimise SQL-based solutions Collaborate with a team of developers, designers, and project managers to identify business requirements and translate them into technical specifications Perform data analysis and ensure data quality by performing data validation and quality checks Use DevOps for workload management and version control Monitor reporting performance and optimise solutions to ensure maximum efficiency and scalability Ensure compliance with data privacy and security standards Provide technical support and troubleshoot reporting-related issues Create visualisations and reports for requested projects Conduct unit testing/test-driven development processes and troubleshooting Evaluate and improve existing SQL-based solutions Stay up to date with the latest trends and technologies in SQL development. Key Tasks Become familiar with the applications, integrated solutions, backlogs and current roadmaps as well as the supported business processes Participate in Agile Ceremonies. Begin to undertake testing tasks, progressing to basic modifications and creations of features and then on to more complex developments. This will be achieved by: Developing and supporting new and existing SQL applications and integrations across the organisation’s application architecture within our Agile Delivery Processes Proposing and implementing solutions to business requirements that align with our product roadmap and architecture Supporting Change and Release Management processes as part of the software development lifecycle Working as part of a team to transform the Application Architecture of the organisation and formalise best practice standards and methodologies.
What you will need:
A minimum of 5 years demonstrable track record of successful delivery of complex technical applications and services.
You will need to have previous experience with the below tech stack: Extensive experience in Microsoft SQL development, including Integration Services (SSIS), Reporting Services (SSRS)/PowerBI, Azure (Data Factory, Data Lake & Analytics) Strong knowledge of T-SQL programming, Power Query and DAX Experience with SQL Server both on-premises and cloud-based Experience with database schema design and implementation Experience with Visual Studio Strong knowledge of ETL (Extract, Transform, Load) processes and tools, such as SSIS Experience in data preparation and data warehousing projects Experience with web services and APIs Experience with DevOps and version control systems Strong analytical and problem-solving skills Knowledge of data modelling and data architecture Excellent analytical and problem-solving skills Ability to work independently and as part of a team Strong communication and collaboration skills.
Experience with the following would be beneficial: DevOps Automated Testing Microsoft Fabric Microsoft .Net
Benefits, Agile Working and Additional information
We embrace agile working and offer a blended approach to where and how we work.
We appreciate that people have different needs and preferences and we’re keen to be flexible, after all, we value what you do, not where you do it.
We have the following hubs across the UK: Birmingham, Bristol, Leicester, Lincoln, London, Milton Keynes, Nottingham, Solihull, Stratford upon Avon, Sheffield and in the South; Crawley, East Grinstead, Lewes, Brighton, Eastbourne, Seaford, Peacehaven, Storrington, Chichester & Southampton as well as our Scotland office located in Edinburgh.
Additional information Want to find more about our
amazing benefits
? Please be aware, for some vacancies, where we receive high numbers of applications we may need to bring the close date forward. Due to the nature of the work undertaken, confirmation of employment will be subject to a variety of checks which will be carried out once an offer of employment is accepted. Details of the checks can be found
here .
Equal opportunities Ampa Group is a committed equal opportunities employer. We seek to attract, develop and retain talented people from a diverse range of backgrounds and cultures. We value and respect individuality and encourage a culture within our business where people can be themselves and be valued for their strengths and experiences. Everyone who either applies to or works for the firm is treated equally, regardless of their gender, age, ethnic origin, nationality, marital status, sexual orientation or religious beliefs.
#J-18808-Ljbffr
