This job is with Avaloq, an inclusive employer and a member of myGwork the largest global platform for the LGBTQ+ business community. Please do not contact the recruiter directly.
Company Description
Founded and headquartered in Switzerland, Avaloq is continuously expanding its global footprint with around 2,500 colleagues in 12 countries, and more than 160 clients in 35 countries. We are an industry-leading provider of wealth management technology and services for financial institutions around the world, including private banks and wealth managers, investment managers, as well as retail and neo banks. Our research led approach and continual innovation is powered by the passion and creativity of our colleagues.
We are always looking for talented people to join us on our mission to orchestrate the financial ecosystem and democratize access to wealth management. Avaloq offers the opportunity to work closely with some of the world's leading financial institutions as we jointly develop and shape careers. Championing a collaborative, supportive and flexible work environment empowers our colleagues to reach their full potential.
Job Description
As a
SQL Server Back-End Developer, you will play a pivotal role in shaping and extending our data infrastructure to meet evolving business needs. You will be responsible for maintaining and enhancing our existing MS SQL Server-based data warehouse by developing and integrating new features, while ensuring thorough documentation and scalable design.
In this role, you will lead the development and management of
ETL (Extract, Transform, Load) processes using
SSIS (SQL Server Integration Services), facilitating seamless integration between various enterprise platforms such as SAP, JIRA, and other key systems. A key aspect of your role will involve supporting and driving our migration to the cloud, with a particular focus on Microsoft Fabrics. This is an excellent opportunity to be at the forefront of cutting-edge technologies and cloud solutions.
Your key tasks
- Extend and optimize data models to support new business functionalities and processes, ensuring robust, scalable, and high-performance database solutions.
- Develop and maintain ETL processes using SSIS to integrate data from multiple sources including SAP, JIRA, and other business platforms.
- Design and implement database components using T-SQL, ensuring efficient query execution and database performance tuning.
- Monitor and support the daily operations of our Datawarehouse, resolving issues and providingtechnical support as necessary.
- Manage and maintain source code in BitBucket repositories, ensuring version control best practices and collaboration.
- Contribute to the cloud migration strategy, particularly around Microsoft Fabrics, leveraging your expertise in SQL Server and cloud technologies to ensure a smooth transition.
Qualifications
- 5+ years of experience in SQL Server development and SSIS/ETL processes in a complex, enterprise environment.
- Expertise in T-SQL for developing complex queries, stored procedures, and optimizing database performance.
- Strong proficiency in C# for building custom SSIS Script Tasks and integrating data solutions through REST APIs.
- Excellent problem-solving skills and the ability to perform root cause analysis to resolve technical issues effectively and permanently.
- Proven ability to conduct thorough root cause analysis for troubleshooting data issues and optimizing database performance.
- Good Data Analysis and Data Modelling skills
- Excellent communication skills for documenting solutions and collaborating with cross-functional teams.
It would be a real bonus if you have
- Experience in Web Development or ASP.NET core web forms is a plus
- Familiarity with cloud migration, preferably with knowledge of Microsoft Fabrics or similar technologies.
Additional Information
We realize that managing work life balance is a challenge we all face in our daily lives and in order to support with this we are pleased to offer hybrid and flexible working for most of our Avaloqers to maintain work life balance and still continue our fantastic Avaloq culture in our global offices.
In Avaloq we are proud to embrace diversity and understand the success of our business is built on the power of different opinions, we are whole heartedly committed to fostering an equal opportunity environment and inclusive culture where you can be your true authentic self.
We hire, compensate and promote regardless of origin, age, gender identity, sexual orientation or any other fantastic traits that make us all unique, we have done our best to write this advert in an inclusive and neutral way.
Please be aware that we will not accept speculative CV submissions for any of our roles from recruitment agencies, and any unsolicited candidate submissions will be exempt from any payment expectations.
