J21392

Excel VBA Developer – Design Office Data Management

JOB TYPE

JOB AREA

RATE

LOCATION

IR35 STATUS

DURATION

RECRUITER

RECRUITER EMAIL

RECRUITER TEL NO.

Permanent

I.T. Services

Dependent on Experience

Shalford, Surrey

Lucy Wheeler

01268 582900

Position Title: Excel VBA Developer – Design Office Data Management

Duration: Permanent

Location: Surrey

• Our Client currently have an exciting opportunity for an Excel VBA Developer – Design Office Data Management to join our Design, Development and Engineering Centre based in Shalford, Surrey.

Principle Accountabilities:
• The key accountability of the Engineering Database Management (EDM) function is to control and maintain the Data produced from the Engineering Design team (held as an extracted
• BoM structure) for tracking and reporting product cost and weight.
• This role supports the EDM team and wider business through the creation and maintenance of business tools and reporting. These tools are predominantly built through Excel Visual
• Basic, but knowledge of other analytic tool concepts (Power BI, Tableau) would be an advantage.

Responsibilities:
• Identify opportunities, understand end-user needs, and develop new tools/functions, using applications like MS Excel, Access, SQL, Power BI
• Respond to requests from the business for production of reports or provide the ability for stakeholders to generate reports of their own
• Provide training to current team to ensure efficient use and handover of tools/functions
• Support the development of a PLM and ERP systems
• To monitor system efficiency and propose changes to improve working functionality
• To ensure compliance with the Health, Safety and Environmental Policy requirements within your areas of responsibilities
• Support the implementation of nominated PLM and ERP Software
• Carry out any other duties that may reasonably be requested of you

Experience and Qualifications:
• It is advantageous to have a working understanding of Engineering BoM structures
• Experience of Data Analysis and manipulation
• Experience of developing and improving processes through automation
• Must be an advanced user on Excel and confident with VBA macros - be able to both write their own code, and work/troubleshoot existing
• Must have strong database design & build skills, confident using multiple data sources and links
• Knowledge of other programming languages, such as Python, an advantage
• Experience of Microsoft 365 / Power Tools also an advantage
• Knowledge of Catia V5/V6, 3D Experience and/or IFS a distinct advantage
• Effective Communication - must be comfortable building working relationships with key technical and non-technical stakeholders, such as Engineering and Finance Hub representatives

J21392

Excel VBA Developer – Design Office Data Management

APPLY ONLINE HERE

Upload .pdf or .doc CV File

Thanks for submitting, a Contechs Recruitment Representative will email/call you ASAP.