UK - London - Aiviq - SQL Developer
Who should apply?
We’re looking for innovative, open-minded SQL developers s to join our growing team as we continue to scale our products – helping to drive sales strategy, analyse fund purchasing patterns, digitally service investors and meet financial reporting requirements.
Why should you join?
At Aiviq, we create clarity for the world’s investment managers. Our cloud-based data and analytics platform already turns disparate client investment information into enterprise-wide datasets for hundreds of industry use cases across our Investment Manager clients, and we’re not done yet.
What you’ll be doing
All developers sit within Engineering team focussing on building and maintaining industry-leading, data-centric products
- 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
What you’ll need
- 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)
What we look for
- A love of “doing things right”
- Tenacity to find solutions, willingness to take on hard legacy code and make it great, attention to detail and drive for quality.
- Collegiate & collaborative with a “can-do” attitude to be part of a team and do what needs to be done to drive the product and team forwards.
- A good problem solver who can extract the real requirements or root causes of issues.
- Enjoy sharing your expertise to help up-skill the team around you
- Asset & Wealth Management industry business applications and data
About Aiviq
Aiviq is growing UK-based FinTech, specialising in developing SaaS products for the world’s investment Managers. We are backed by Alpha Financial Markets Consulting Plc, a global Asset & Wealth Management Consultancy.
Apply for this job
*
indicates a required field