BI SQL Developer

BI SQL Developer – Lookers Motor Group Limited

Location:

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

Contract Type:
Full-time, Permanent

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.

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

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.

• 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

• MyView Pay Now – access a portion of your pay as you earn, with…