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
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
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.