BI SQL Developer

Lookers Motor Group Limited; North East; Hybrid; GBP 40,000 - 60,000; Full time

Benefits offered by this job

Competitive salary

Generous annual leave

Enhanced family leave

Dental insurance

Discounted gym memberships

Access to home and technology vouchers

Job summary

A leading automotive retailer in the UK is seeking a BI SQL Developer to enhance financial reporting solutions. The ideal candidate will have strong SQL development skills, experience in ETL processes, and a background in finance or data warehousing. This hybrid role is based in Newcastle, offering both office and remote work options alongside a comprehensive benefits package.

Qualifications

• Proficiency in SQL development (SQL Server / SSMS) and advanced data modelling.
• Strong skills in Excel and data manipulation.
• Experience with SQL Server Reporting Services (SSRS) for developing and deploying reports.

Responsibilities

• Design and optimize high-performance SQL solutions for financial reporting.
• Communicate effectively with stakeholders to ensure requirements are met.
• Identify and resolve issues in complex stored procedures.

Skills

SQL development

ETL processes

Data manipulation

Advanced proficiency in T-SQL

Teamwork

Organization and time management

Education

Bachelor's degree in Computer Science or related field

Tools

SQL Server

Excel

SQL Server Reporting Services (SSRS)

Job description

Overview

BI SQL Developer – Lookers Motor Group Limited

Location: Newcastle (Hybrid – 3 days office / 2 days remote)

Contract Type: Full-time, Permanent

What You’ll Do

As a BI SQL Developer at Lookers, you will join our Finance BI Data Team to play a pivotal role in maintaining and enhancing the accuracy and efficiency of our financial reporting solutions. This position requires expertise in SQL development, ETL processes, and data warehousing to meet the dynamic reporting and analytical needs of our Finance BI Team.

If you thrive in a fast-paced, intellectually stimulating environment and enjoy transforming complex data into actionable insights that drive business decisions, this role offers an exciting opportunity to grow and make a tangible impact.

• Design and optimise high-performance SQL solutions to power financial reporting, transaction analysis and business intelligence.
• Take a leading role in identifying, diagnosing and resolving issues from debugging complex stored procedures to fine-tuning queries with proactive monitoring to keep our financial data accurate.
• Communicate effectively and professionally with end users and stakeholders, including finance teams to ensure their requirements are fully understood and met.
• Follow industry standard testing and change management procedures to safeguard data integrity.
• Share knowledge freely and help foster an environment where everyone can learn and innovate together.

What You’ll Bring

Must-haves:

• Proficiency in SQL development (SQL Server / SSMS), advanced data modelling, and ETL workflows.
• Strong skills in Excel and data manipulation.
• Advanced proficiency in T-SQL, including writing and optimising complex stored procedures, functions, views, CTEs, and triggers.
• Combine strong teamwork skills with the initiative to work independently - balancing collaboration with personal accountability.
• Committed to ongoing skills development, with the flexibility to evolve alongside emerging BI technologies and analytical approaches.
• Effective organisation and time management skills, capable of meeting deadlines while maintaining attention to detail.
• Bachelor's degree in Computer Science, Information Technology or related field.
• Experience with SQL Server Reporting Services (SSRS) for developing and deploying a variety of reports
• Previous experience within the automotive industry.
• Experience with OLAP data cubes and administration.
• Background in finance or related financial domains; understanding financial data and processes
• Experience with any BI reporting tool

About us

We are one of the top three automotive retailers in the UK, proudly representing 32 manufacturer brands, selling a huge range of new and used vehicles from over 150 dealerships across the UK and Ireland.

We believe our people are our greatest asset, and we’re committed to recognising the valuable contribution each person makes. That’s why we continue to invest in a leading rewards and benefits package designed to support your career, wellbeing, and life outside of work.

Core Benefits

• Competitive salaries with structured pay scales and progression as you grow within the business
• Generous annual leave that increases with your length of service
• Enhanced family leave, including 6 months’ full pay for maternity and adoption leave, and 2 weeks’ full pay for paternity leave
• Access to Techscheme for discounted technology purchases with flexible payments
• Eyecare vouchers to help cover vision care needs
• Smart Health – 24/7 access to GP services to support your mental and physical wellbeing
• Dental insurance for everyday dental care and unexpected treatments
• Critical illness cover for peace of mind during life's most challenging moments

Financial Wellbeing

• MyView PayNow – access a portion of your pay as you earn, with features to stream, save, and track your money through a user-friendly app
• Will writing services to help plan for the future
• Flexible life assurance options and partner life assurance for added protection
• Discounted gym memberships to support an active lifestyle
• Travel insurance to help you explore with confidence
• Access to home and technology vouchers
• bYond card and a wide range of exclusive retail and lifestyle discounts

We strongly believe in nurturing and providing our people with specific manufacturer brand and management training to enhance career development opportunities. We have a great bunch of people, and we like to celebrate and encourage success at all levels.

Lookers and Charles Hurst are an equal opportunities employer. We are committed to a working environment that is free from discrimination, is inclusive, and empowers our people to bring their whole self to work and reach their full potential.

If your application is successful, we will conduct relevant employment checks prior to you commencing employment with us. These will include verifying your recent employment, address, credit history and a standard criminal record check. For roles that require you to drive, a driving licence check will also be carried out. Please note, all offers of employment are made subject to a 6 month probation period commencing from your start date.