Data Developer (SQL/VBA)

Data Developer (SQL/VBA)

London Full-Time 36000 - 60000 Β£ / year (est.) No home office possible
F

At a Glance

  • Tasks: Join our team to design and develop VBA solutions for Microsoft Office applications.
  • Company: Work with a dynamic client in London, embracing innovation and technology.
  • Benefits: Enjoy hybrid work options and a collaborative environment.
  • Why this job: Make an impact by automating tasks and enhancing efficiency with your coding skills.
  • Qualifications: 5+ years of VBA experience, strong Excel/Access skills, and SQL knowledge preferred.
  • Other info: Start ASAP and be part of a forward-thinking team.

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

We are seeking a skilled and detail-oriented VBA Developer to join our client’s team. In this role, you will be responsible for designing, developing, testing, and maintaining VBA (Visual Basic for Applications) solutions, primarily within the Microsoft Office suite (Excel, Access, Outlook, etc.).

  • 5+ years of experience as a VBA developer.
  • Strong proficiency in VBA development, especially in Excel and/or Access.
  • Solid understanding of data manipulation, formulas, and spreadsheet architecture.
  • Experience working with relational databases (SQL knowledge preferred).
  • Experience with other scripting languages (Python, PowerShell) or Office automation tools (Power Query, Power Automate).
  • Design and develop custom VBA macros to automate tasks and reports.
  • Maintain and enhance existing VBA applications and scripts.
  • Debug and resolve issues in VBA code.
  • Integrate Excel/Access applications with databases (SQL Server, Access, etc.).
  • Document code and create user manuals or support guides as needed.

Data Developer (SQL/VBA) employer: Focus on SAP

Join a dynamic and innovative team in London as a VBA Developer, where your expertise will be valued and nurtured. Our hybrid work culture promotes flexibility and collaboration, ensuring you can thrive both in the office and remotely. With a strong focus on employee growth, we offer continuous learning opportunities and a supportive environment that encourages creativity and problem-solving.
F

Contact Detail:

Focus on SAP Recruiting Team

StudySmarter Expert Advice 🀫

We think this is how you could land Data Developer (SQL/VBA)

✨Tip Number 1

Network with professionals in the data development field, especially those who work with VBA and SQL. Attend local meetups or online webinars to connect with potential colleagues and learn about industry trends.

✨Tip Number 2

Showcase your VBA projects on platforms like GitHub or personal websites. This not only demonstrates your skills but also gives you a talking point during interviews, making you stand out from other candidates.

✨Tip Number 3

Familiarise yourself with the specific tools and technologies mentioned in the job description, such as Power Query and Power Automate. Being able to discuss these tools confidently can impress interviewers and show your commitment to the role.

✨Tip Number 4

Prepare for technical interviews by practising common VBA coding challenges and SQL queries. This will help you feel more confident and ready to demonstrate your problem-solving skills during the interview process.

We think you need these skills to ace Data Developer (SQL/VBA)

VBA Development
Microsoft Excel
Microsoft Access
SQL Knowledge
Data Manipulation
Spreadsheet Architecture
Debugging Skills
Automation Tools (Power Query, Power Automate)
Documentation Skills
Problem-Solving Skills
Attention to Detail
Relational Database Management
Scripting Languages (Python, PowerShell)
User Manual Creation
Task Automation

Some tips for your application 🫑

Tailor Your CV: Make sure your CV highlights your experience with VBA development, especially in Excel and Access. Include specific projects or tasks where you designed and developed VBA solutions, as well as any relevant SQL knowledge.

Craft a Strong Cover Letter: In your cover letter, emphasise your 5+ years of experience as a VBA developer. Mention your proficiency in data manipulation and how you've successfully automated tasks using VBA. Be sure to express your enthusiasm for the role and the company.

Showcase Relevant Skills: When filling out your application, make sure to highlight your skills in other scripting languages like Python or PowerShell, as well as any experience with Office automation tools such as Power Query or Power Automate. This will set you apart from other candidates.

Proofread Your Application: Before submitting, carefully proofread your application for any spelling or grammatical errors. A polished application reflects your attention to detail, which is crucial for a role that involves coding and documentation.

How to prepare for a job interview at Focus on SAP

✨Showcase Your VBA Skills

Be prepared to discuss your experience with VBA development in detail. Bring examples of projects you've worked on, especially those involving Excel and Access, and be ready to explain the challenges you faced and how you overcame them.

✨Demonstrate Data Manipulation Knowledge

Since the role requires a solid understanding of data manipulation, brush up on your knowledge of formulas and spreadsheet architecture. Be ready to answer questions about how you would approach specific data-related tasks or problems.

✨Familiarise Yourself with SQL

Even if the focus is on VBA, having a good grasp of SQL will set you apart. Prepare to discuss how you've integrated Excel or Access applications with databases and any relevant SQL queries you've written.

✨Prepare for Problem-Solving Scenarios

Expect to face technical questions or scenarios where you'll need to debug VBA code or suggest improvements. Practise explaining your thought process clearly, as this will demonstrate your analytical skills and problem-solving abilities.

Data Developer (SQL/VBA)
Focus on SAP
F
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>