About us
We are one of the world's leading software providers for secured, business-to-business lending software, used by 135 banks and financial institutions across the world.
The company HQ is in Wimbledon, South West London, and offers an excellent office environment. The company also has satellite offices in California and Sydney to service clients in those regions, with commercial representatives in the US, Greece and Singapore.
Our flagship product is Lendscape, which supports a range of working capital financial solutions such as factoring, invoice discounting, supply chain finance, and asset-based lending (ABL). We are also developing an Asset Finance system, to be launched in 2021, enabling us to support the full range of secured lending products available to businesses.
We have 165 employees globally, who sell, develop, maintain, and support our technology.
The company culture is friendly and supportive, and as an employer, we offer a wide range of benefits including a complete Wellness Plan (health insurance, EAP, Cash Plan, Gym membership, etc.) to attract and retain talent. We also recognise the importance of providing flexible working arrangement and career-enhancing opportunities. We focus on developing all our employees and building a strong leadership team to allow the business to scale.
We believe in supporting the community in which you work, and to that end, we are proud to participate in a wide range of philanthropic efforts.
Job role: Senior SQL Report Writer
Location: Greater London (Wimbledon) - currently remote
Salary: competitive
Main function
To enhance our data visualisation strategy for the Lendscape product suite.
Required Skills and competencies
• Minimum 5 years of T-SQL based complex report development – using SQL2012; SQL2016, or SQL2019 where possible, on large multi-terabyte systems.
• In-depth understanding of the mechanics of SQL server query engine and how to develop optimised SQL queries.
• Ability to read and interpret SQL execution plans in order to identify query bottlenecks
• Ability to identify and apply appropriate index strategy to help improve SQL performance.
• Understanding DB maintenance requirements.
• Data warehousing & data modelling
• Proven track record of designing & implementing a reporting strategy.
• Excellent communication skills, including an ability to clearly communicate your vision, ideas, insights and feedback to a non-technical audience.
• Financial services experience
Tooling:
• SSMS; SSRS, SSIS
• Graphana. Tableau, PowerBI
• Jaspersoft Studio
• PlanExplorer
• Git
• Jira
Desirable Skills:
• Knowledge of programming languages such as Java would be desirable.
• AWS; Aurora; SQLServer on RDS
• ITILv4
We offer:
- Private Medical Cover
- Cash Benefits Plan
- Travel Insurance
- Life Insurance
- Gym Membership
- Family Friendly Policy
- Remote Working Policy
- Flexi Time Policy
- Volunteering Scheme
- Training
- And many more!
