BI SQL Developer

BI SQL Developer

North East Full-Time 36000 - 60000 £ / year (est.) No home office possible
Lookers Motor Group Limited

At a Glance

  • Tasks: Join our Finance BI Data Team to enhance financial reporting solutions using SQL and data analysis.
  • Company: Lookers is a leading UK automotive retailer, representing 32 brands across 150 dealerships.
  • Benefits: Enjoy competitive salaries, generous leave, health support, and exclusive discounts.
  • Other info: Hybrid work model with opportunities for career development and training.
  • Why this job: Transform complex data into insights while growing in a supportive, innovative environment.
  • Qualifications: Proficiency in SQL, data modelling, and a degree in IT or related field required.

The predicted salary is between 36000 - 60000 £ per year.

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.

#J-18808-Ljbffr

BI SQL Developer employer: Lookers Motor Group Limited

Lookers Motor Group Limited is an exceptional employer, offering a dynamic and supportive work environment in Newcastle, where you can thrive as a BI SQL Developer. With a strong commitment to employee growth, competitive salaries, and a comprehensive benefits package, including enhanced family leave and access to health services, Lookers fosters a culture of collaboration and innovation, ensuring that every team member feels valued and empowered to make a meaningful impact.
Lookers Motor Group Limited

Contact Detail:

Lookers Motor Group Limited Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land BI SQL Developer

✨Tip Number 1

Familiarise yourself with Lookers Motor Group's business model and the automotive industry. Understanding their operations and financial reporting needs will help you tailor your discussions during interviews, showcasing how your skills can directly benefit their team.

✨Tip Number 2

Brush up on your SQL Server Reporting Services (SSRS) skills. Since this role involves developing and deploying reports, being able to demonstrate your proficiency in SSRS during the interview can set you apart from other candidates.

✨Tip Number 3

Prepare to discuss specific examples of how you've optimised SQL queries or resolved complex data issues in previous roles. This will not only highlight your technical expertise but also your problem-solving abilities, which are crucial for this position.

✨Tip Number 4

Network with current or former employees of Lookers Motor Group on platforms like LinkedIn. Engaging with them can provide valuable insights into the company culture and expectations, which you can leverage during your application process.

We think you need these skills to ace BI SQL Developer

Proficiency in SQL development (SQL Server / SSMS)
Advanced data modelling
ETL workflows
Strong skills in Excel and data manipulation
Advanced proficiency in T-SQL
Writing and optimising complex stored procedures, functions, views, CTEs, and triggers
Teamwork skills
Initiative to work independently
Effective organisation and time management skills
Attention to detail
Experience with SQL Server Reporting Services (SSRS)
Understanding of OLAP data cubes and administration
Background in finance or related financial domains
Experience with BI reporting tools

Some tips for your application 🫡

Tailor Your CV: Make sure your CV highlights your SQL development skills, experience with ETL processes, and any relevant work in finance or the automotive industry. Use specific examples to demonstrate your expertise in T-SQL and data manipulation.

Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the BI SQL Developer role at Lookers. Mention how your skills align with their needs, particularly in designing high-performance SQL solutions and your ability to communicate effectively with stakeholders.

Showcase Relevant Projects: If you have worked on projects involving SQL Server Reporting Services (SSRS) or OLAP data cubes, be sure to include these in your application. Highlight your contributions and the impact of your work on financial reporting or business intelligence.

Proofread Your Application: Before submitting your application, carefully proofread all documents for spelling and grammatical errors. A polished application reflects your attention to detail, which is crucial for a role that involves maintaining data accuracy.

How to prepare for a job interview at Lookers Motor Group Limited

✨Showcase Your SQL Skills

Be prepared to discuss your experience with SQL development in detail. Highlight specific projects where you designed and optimised SQL solutions, and be ready to explain your approach to writing complex stored procedures and functions.

✨Demonstrate Problem-Solving Abilities

Expect questions that assess your ability to diagnose and resolve issues. Share examples of how you've debugged complex queries or improved data accuracy in previous roles, showcasing your analytical thinking.

✨Communicate Effectively

Since the role involves liaising with finance teams and stakeholders, practice articulating technical concepts in a way that's easy for non-technical audiences to understand. This will demonstrate your ability to bridge the gap between technical and business needs.

✨Emphasise Continuous Learning

Discuss your commitment to ongoing skills development and staying updated with emerging BI technologies. Mention any relevant courses or certifications you've pursued, as this shows your initiative and adaptability in a fast-paced environment.

BI SQL Developer
Lookers Motor Group Limited
Location: North East

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

>