SQL Developer (EDW)

TN United Kingdom; London; On-site; GBP 50,000 - 90,000; Full time

Job summary

Join a dynamic global team as a SQL Developer Technical Lead, where you will play a pivotal role in managing a critical application used for client reporting and trading. This role offers the chance to lead a talented offshore team while developing scalable databases and enhancing data integration processes. As part of a collaborative culture, you'll work closely with colleagues across the globe, adapting to evolving responsibilities and making a significant impact on the organization. If you have a passion for growth and a strong analytical mindset, this opportunity is perfect for you.

Qualifications

• Proficiency in SQL Server development and T-SQL.
• Experience with large, scalable databases and data integration.

Responsibilities

• Oversee a team of offshore developers and QA professionals.
• Develop SQL Server code and create data marts for reporting.

Skills

SQL Server Development

T-SQL

Data Integration (SSIS)

Problem-Solving

Collaboration

Analytical Mindset

Tools

SQL Server

SQL Server Integration Services (SSIS)

Job description

Social network you want to login/join with:

Job Specification: SQL Developer Technical Lead

Company Overview

Alliance Bernstein is a global investment management firm committed to delivering better outcomes for its clients. With a diverse network of perspectives, we design innovative solutions tailored to meet investors’ unique needs. Our collaborative culture empowers everyone to become their best selves and we act responsibly in both our actions and investments.

Role Description

As a SQL Developer within AB’s Operations Technology, you will be instrumental in building out our OLTP application database including backend of the private client business accounting platform. This platform handles large volumes of rapidly processed data and is transitioning from batch processing to real-time operations. This will be a great opportunity to learn accounting principles in depth.

You will have the opportunity to ultimately take over complete ownership of the platform and management of the offshore team. The application includes the private client accounting platform, with some institutional data feeding through and eventually all institutional accounting will be moved into the system. This is a critical application used by the business for start of day trading, performance, client reporting, with many stakeholders across the business.

This is a truly Global department. You will have the opportunity to be sat in the hub of mission control in London, as part of a team which spans across Vietnam, India, Nashville and Mexico. As part of this, you will also have the opportunity to be a leader for the team in Vietnam and play a pivotal role in managing the software development lifecycle and operation of one of AB’s most critical applications.

This is a project and role that will grow and evolve over time. It is therefore crucial that the candidate is adaptive and able to handle the growth in responsibility that will come with this. Of course, the rate in which the role will grow is also down to how much of an impact you are able to make, so you will need to be an ambitious individual with a hunger for growth.

Key Responsibilities

• Oversee a team of 20 offshore developers and QA professionals, supporting the delivery of key projects.
• Develop SQL Server code (T-SQL) and utilize SSIS for data integration.
• Create data marts to support reporting and analytics.
• Provide production support for critical applications.
• Attend senior business stakeholder meetings.
• Analyse database systems and create technical requirements.

Qualifications

• Industry: Financial background is NOT required
• Collaboration: Enthusiastic and excited about opportunities to collaborate closely with colleagues in India and Vietnam in a globally distributed software development team.
• Resilience: Ability to remain calm under pressure.
• Analytical Mindset: Logical and analytical approach to problem-solving.
• Ownership and Collaboration: Take ownership of tasks and collaborate effectively.
• Technical Skills:
  • SQL Server: Proficiency in SQL Server development.
  • Large Application Databases: Knowledge of building large, scalable databases.
  • SQL: Understanding of SQL query optimization and performance enhancements.
  • T-SQL: Strong skills in Transact-SQL.
  • SSIS: Experience with SQL Server Integration Services.
  • Service Broker: Familiarity with Service Broker (good to have).
• Company Background: Experience with mid-sized companies preferred but not essential.