UK - London - Aiviq - SQL Developer

2 days ago

Apply Now

Receive Emails with Similar Jobs

Aiviq

WebsiteLinkedInAll Job Openings

Creating clarity for the world's investment managers. Build a single view of client AUM & Flow with Aiviq.

Asset Management • Client Data & Analytics • Cloud Architecture • Master Data Management • Assets, Flows & Revenue

11 - 50

Description

• Be the resident SQL Development Expert within the Engineering team • Play a key role in data modelling decisions ensuring scalable, maintainable products with little or no technical debt • Develop and maintain performant views and stored procedures that accurately encapsulate the required business logic for our products • Build out scripts for use within Customer Services team tooling to quickly identify data quality issues and surface meaningful data • Assist the Engineering team to find elegant, readable and maintainable solutions to gnarly data problems

Requirements

• Expert level SQL development skills for creating and maintaining SQL database models and all T-SQL artefacts using all the industry best-practices • Strong experience using Azure SQL databases • Strong data analysis skills to facilitate complex problem solving • Strong query optimization skills • Strong understanding of data warehousing concepts and implementation experience • Good experience with Version Control and Release Management tools such as Git, Azure DevOps, Jenkins etc • Good familiarity with MS Azure suite of products, especially Azure Data Factory and related tooling • Familiarity with temporal functionality within SQL Server • Familiarity with SQL Server Integration Services – building and deploying packages • Familiarity with ColumnStore and In-Memory architecture in SQL server would be beneficial • Familiarity with collaboration suites i.e. Atlassian product (Jira, Confluence)