At a Glance
- Tasks: Assist in data management and automation using SharePoint, VBA, and PowerShell.
- Company: Join Martin-Baker Aircraft Co Ltd, a leader in aviation technology.
- Benefits: Enjoy competitive salary, healthcare, 25 days leave, and a pension scheme.
- Why this job: Make a real impact by improving business processes and training users.
- Qualifications: Strong Excel skills and experience with automation tools like VBA or PowerShell.
- Other info: Hybrid working after six months and excellent career development opportunities.
The predicted salary is between 30000 - 42000 £ per year.
Overview
A vacancy has arisen for an Assistant Applications and Automation Specialist to join the Information Management team, based at our Denham campus. We offer hybrid working after six months of employment (mandatory onsite for three days per week).
What you’ll be doing
Reporting to the Company Data Coordinator, the role is varied within an evolving department that supports Martin-Baker in all aspects of data management, applications and automation. We proudly use SharePoint as an information management system across the organisation, you’ll be involved with SharePoint IT administration tasks and a wide variety of automation tools using VBA, Power Automate and PowerShell.
- Assist with developing and maintaining automation, troubleshoot user issues (e.g. MFA), train users in M365 apps, MS Forms, Planner and Adobe, run XLOOKUPs and VLOOKUPs in Excel for comparisons, promote best practices, and use Purview software to monitor compliance.
- Assist with managing SharePoint users, uploading data into SharePoint sites and setting SharePoint document metadata. Provide advice and training to users, enabling correct use of the SharePoint system, undertaking admin tasks such as site creation, site design (web parts), bulk adding of users, retrieval (search), bulk metadata changes and versioning. Provide support with M365 apps (Power Automate, Power BI, MS Teams, MS Forms), running XLOOKUPs and VLOOKUPs in Excel for list comparisons, and using Adobe. Migrate data from Network Drives to SharePoint, support with running compliance checks to ensure system integrity and that information is processed to required compliance standards.
- Proactively participate in business improvement initiatives for cross-functional information management systems, processes and procedures.
What we’re looking for
- Strong abilities and enthusiasm with using Microsoft Excel, comfortable running XLOOKUPs or VLOOKUPs, and manipulating data in Excel.
- Experience using automation tools such as VBA, PowerShell or Power Automate. Keen to learn new skills, enthusiastic, pragmatic and professional.
- General knowledge of M365 and Adobe applications/products.
- Proven attention to detail and driven to achieve results – enjoys setting own standards and checking work.
- Experience using business applications such as SharePoint / EDMS / other relevant tools.
- Desirable – Knowledge of variables, branching (If/Else statements), loops and related programming elements.
- Desirable – User training experience.
What we offer
- Highly competitive 9% non-contributory pension scheme (18+)
- 4x salary Life Assurance
- Lunchtime finish on a Friday
- Personalised training and development plan
- 25-days annual leave plus bank holidays
- Opportunity to purchase additional annual leave
- Occupational Health team
- Cycle to work scheme
We believe in equal opportunity, committed to creating an inclusive environment where everyone is respected. We want you to be able to do your best work.
Martin-Baker is a signatory to the Armed Forces Covenant, showing our support and commitment to our Armed Forces and their families, proudly supporting those who serve.
This role is subject to pre-employment screening in line with the UK Government’s Baseline Personnel Security Standard (BPSS). For more information and guidance please visit https://martin-baker.com/security-vetting
Job details
- Seniority level: Associate
- Employment type: Full-time
- Job function: Analyst
- Industries: Defense and Space Manufacturing
#J-18808-Ljbffr
Assistant Applications and Automation Specialist employer: Martin-Baker Aircraft Co Ltd
Contact Detail:
Martin-Baker Aircraft Co Ltd Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Assistant Applications and Automation Specialist
✨Tip Number 1
Get to know the company! Research Martin-Baker and their projects, especially around data management and automation. This will help you tailor your conversations and show that you're genuinely interested in what they do.
✨Tip Number 2
Practice your tech skills! Brush up on your Excel functions like XLookups and VLookups, and get familiar with SharePoint and automation tools like Power Automate. Being confident in these areas will make you stand out during interviews.
✨Tip Number 3
Network like a pro! Connect with current employees on LinkedIn or attend industry events. This can give you insider info about the company culture and possibly even a referral, which can be a game-changer.
✨Tip Number 4
Apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re serious about joining the team at Martin-Baker.
We think you need these skills to ace Assistant Applications and Automation Specialist
Some tips for your application 🫡
Tailor Your CV: Make sure your CV reflects the skills and experiences that match the Assistant Applications and Automation Specialist role. Highlight your experience with SharePoint, Excel, and any automation tools like VBA or PowerShell. We want to see how you can bring value to our team!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're excited about this role and how your background makes you a great fit. Don’t forget to mention your enthusiasm for learning new skills and your attention to detail – we love that!
Showcase Your Communication Skills: Since this role involves a lot of interaction with colleagues, make sure to demonstrate your strong communication skills in your application. Whether it's through examples in your CV or your cover letter, let us know how you've effectively communicated in past roles.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way to ensure your application gets to us quickly and efficiently. Plus, you’ll find all the details you need about the role and our company culture there!
How to prepare for a job interview at Martin-Baker Aircraft Co Ltd
✨Know Your Tools
Familiarise yourself with the key tools mentioned in the job description, like SharePoint, VBA, Power Automate, and PowerShell. Be ready to discuss your experience with these tools and how you've used them in past roles or projects.
✨Excel Mastery
Since strong Excel skills are crucial for this role, practice running XLookups and VLookups. Prepare to demonstrate your ability to manipulate data effectively, as you might be asked to solve a problem on the spot during the interview.
✨Show Enthusiasm for Learning
The company values a keen attitude towards learning new skills. Be prepared to share examples of how you've proactively learned new technologies or processes in the past, and express your eagerness to grow within the role.
✨Communication is Key
With a focus on stakeholder management and user training, highlight your communication skills. Think of specific instances where you've successfully trained others or collaborated across teams, and be ready to discuss how you can promote best practices in the workplace.