SQL Server Developer (SSAS cubes & data-intensive applications)

This job has now expired please search on the home page to find live IT Jobs.

SQL Server Developer (SSAS cubes & data-intensive applications) London or Leeds based role (please only apply if able to work in this location at least 2 day per week). Salary & Benefits: £77k - 85k annual base salary - London £67k - 75k annual base salary - Leeds On the top of the annual guaranteed salary, we also offer annual personal bonus, up to 15% employer pension contribution, private medical insurance, 30 days holiday plus bank holidays.We also provide our colleagues with number of free health and well-being offerings including life events & stages, disability support and generous parental / adoption leave policies. Who is Lloyds Banking Group?At Lloyds Banking Group we're committed to transforming and redefining The UK's largest Digital Bank for our 18 million digital customers we have across our brands including Lloyds Bank, Halifax and Bank of Scotland.

LBG is on a mission to build the bank of the future, and we need your help to do it! Continuing our extensive transformation programme, we're redefining what a bank is from the inside out. Our technology, our culture, and our mind-set is changing to craft a true engineering-led organisation.Commercial Banking division has a rich heritage of supporting businesses and the economic prosperity of the nation, primarily focused on UK businesses and those with strong links to the UK. Our team The Treasury Lab team are part of Group Transformation. We work together to solve complex problems for Treasury through building, implementing, and supporting strategic technology solutions. We're looking for a SQL Server Developer to work on Treasury Lab (Finance Platform) data-intensive applications.

Here's where you'll make a difference… Prototyping and development of ETL routines and data storage solutions with a strong focus on performance, reliability, and maintainability Promote passion for technology and writing clean, maintainable, and performant code Writing unit test scripts, code reviews and technical documentation Participating in the agile software development process to produce rapid delivery of features requested by customers Applying industry best practices, fostering knowledge sharing to provide solutions for complex business problems where no precedent may exist, and ensuring implementation of solutions where appropriate Understand trade-offs of taking one approach over another and be able to articulate in a clear and concise manner the why's and how's of that approach Discussing ideas openly and listening to different perspectives Focussing on delivering business value through sound engineering methods and principles What we need from you… Essential skills & experience:Knowledge of Data Warehousing methodologies and concepts Comprehensive experience of MS SQL Server, in particular developing and supporting SSAS cubes Ability to implement SSIS packages (especially data flows) for the transformation of data using principles of ETL Demonstrable experience in implementing T-SQL code Experience of developing reports in SSRS would be a distinct advantage Experience of working within agile project management framework Experience of using a source control management tool Desirable skills Experience of any of the following would be beneficial, but not essential: Power BI BIML experience Git repository C# Query Optimisation So why should you apply?You'll become part of a team that has an inclusive, values-led culture. This means we embrace that not everyone is the same or likes to work in the same way. We're focused on delivering for both our customers and our colleagues; you'll receive support to learn, grow and develop, benefitting from a huge range of opportunities opened up by being part of our Group. Offering hybrid working patterns we believe that a healthy work/ life balance is as important as the work we deliver, just let us know what might work for you. We are passionate about diversity and equal opportunity with industry recognition across gender, ethnicity, disability, LGBTQ+ and families. We're committed to employing a diverse and inclusive workforce, reflective of the customers and communities we serve, where all our colleagues can be themselves and succeed on merit.And we're proud to have received these industry recognitions: Stonewall Top Private Sector Employer, Top10 Employer for Working Families, The Times Top 50 Employer for Women and both Gold Standard and Best Workplace Adjustments Process from the Business Disability Forum. Are you interested in joining us? Apply today, we'd love to hear from you. Together we'll make it possible...