Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Develop and deliver data pipelines, support ETLs, and create reports using SQL Server technologies.
- Company: Join Free-Work UK, a dynamic bank in Central London, focused on innovation and technology.
- Benefits: Enjoy competitive pay, opportunities for growth, and a collaborative work environment.
- Why this job: Be part of a tech-driven team that values creativity and problem-solving in a supportive culture.
- Qualifications: Degree level qualified with proficiency in MS SQL stack; C# or JavaScript knowledge is a plus.
- Other info: Office-based role for 3 days a week; salary ranges from £60K to £75K.
The predicted salary is between 51000 - 65000 £ per year.
Our Client is a bank based in Central London looking to recruit a Database Engineer with at least 5 to 7 years of solid expertise in SQL Server, SSIS, and SSRS.
Responsibilities:
- Development and delivery of pipelines to automate and streamline processes required by different departments.
- Support existing SSIS ETLs, proactively fine-tune and enhance existing codes to increase robustness and error monitoring.
- Support the internal IT department with changes and upgrades to software platforms.
- Convert legacy Hyperion reports to SSRS.
- Analyse issues pertaining to problems or errors raised by in-house systems.
- Understand business requirements to develop and deliver appropriate solutions based on system definition documents.
- Build data pipelines within the SQL environment in SSIS packages.
- Build tabular models (SSAS) for different business units.
- Build reports based on business requirements using SQL SSRS.
- Integrate with all the Bank's sub-systems using data abstraction and connectivity layers.
- Ensure that the environment is running optimally with high standard housekeeping procedures.
- Integrate the SharePoint environment and Forms with the Equation system to introduce automation of processes.
- Provide second and third level support for in-house programmes during the end of day cycle.
- Maintain knowledge of all applicable regulatory requirements including the Bank's Risk and Compliance policies.
- Complete all annual mandatory regulatory refresher training as per the Bank's training plans and deadlines.
Qualifications/Experience:
- Degree level qualified or equivalent.
- MS SQL stack (SSIS, SSAS, SSRS) to a high level of proficiency - Essential.
- C# Programming / JavaScript programming - Desirable.
Knowledge and Skills:
- Software analysis and design good practice.
- Dimensional modelling, Entity Relationship modelling, Normalised modelling.
- Data warehouse design concepts (Inmon, Kimball).
The position is based in Central London, and you will be required to be in the office for 3 days a week. The salary for this position is in the range £60K - £75K.
SQL Server Developer with SSIS and SSRS employer: Free-Work UK
Contact Detail:
Free-Work UK Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land SQL Server Developer with SSIS and SSRS
✨Tip Number 1
Familiarise yourself with the specific technologies mentioned in the job description, such as SQL Server, SSIS, and SSRS. Being able to discuss your hands-on experience with these tools during interviews will demonstrate your suitability for the role.
✨Tip Number 2
Network with professionals in the banking and IT sectors, especially those who work with SQL databases. Attend relevant meetups or online forums to gain insights and potentially get referrals that could boost your chances of landing the job.
✨Tip Number 3
Prepare to discuss real-world scenarios where you've successfully implemented data pipelines or resolved issues in SQL environments. Having concrete examples ready will help you stand out during the interview process.
✨Tip Number 4
Stay updated on the latest trends and best practices in database management and ETL processes. Showing that you're proactive about your professional development can impress potential employers and set you apart from other candidates.
We think you need these skills to ace SQL Server Developer with SSIS and SSRS
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with SQL Server, SSIS, and SSRS. Include specific projects or achievements that demonstrate your expertise in these areas.
Craft a Strong Cover Letter: Write a cover letter that addresses the key responsibilities mentioned in the job description. Explain how your skills and experiences align with the needs of the role, particularly in developing data pipelines and supporting ETL processes.
Showcase Relevant Skills: Emphasise your proficiency in advanced 4GL programming languages and any experience with C# or JavaScript. Mention your understanding of data warehouse design concepts and modelling techniques.
Highlight Problem-Solving Abilities: Provide examples of how you've successfully analysed and resolved issues in previous roles. This is crucial for demonstrating your capability to take ownership of problems and deliver timely solutions.
How to prepare for a job interview at Free-Work UK
✨Brush Up on SQL Server Skills
Make sure to review your SQL Server knowledge, especially SSIS and SSRS. Be prepared to discuss your experience with data pipelines, ETL processes, and report generation, as these are crucial for the role.
✨Showcase Problem-Solving Abilities
Prepare examples of how you've tackled issues in previous roles, particularly during end-of-day cycles or when integrating systems. Highlight your ability to analyse problems and deliver timely solutions.
✨Understand Business Requirements
Familiarise yourself with how to translate business needs into technical solutions. Be ready to discuss how you’ve previously gathered requirements and developed appropriate database solutions.
✨Demonstrate Knowledge of Compliance
Since the role involves risk and regulatory duties, be prepared to talk about your understanding of compliance policies and how you've adhered to them in past positions. This shows your commitment to maintaining high standards.
