Automation Developer

GlobalData PLC; City Of London; On-site; GBP 50,000 - 70,000; Full time

Job summary

A leading information services provider in the UK is seeking a highly skilled automation developer. The ideal candidate will possess advanced proficiency in Excel, VBA, and Python programming to automate tasks and streamline processes. You will be responsible for developing complex models, scripting, and providing end-user training. The role requires strong analytical skills and a proactive attitude towards learning about the healthcare industry. This position offers an exciting opportunity in a fast-paced and collaborative environment.

Benefits

Professional development opportunities

Dynamic team environment

Healthcare sector insights

Qualifications

• Advanced proficiency in Excel, VBA, and Python programming.
• Experience in automating tasks and streamlining processes.
• Proficiency with data manipulation libraries in Python.

Responsibilities

• Develop and maintain Excel/VBA models and Python applications.
• Automate tasks and improve workflow efficiency.
• Provide training and support for Excel/VBA and Python functionalities.

Skills

Excel development

VBA programming

Python programming

Problem-solving skills

Communication skills

Leadership skills

Education

BSc/MSc in Computer Science or related field

Tools

Snowflake

Job description

Our Competitive Intelligence Pharma business require a highly skilled automation developer to join the team. The ideal candidate will possess an advanced level of proficiency in both Excel, VBA and Python programming, with a strong ability to automate tasks and streamline processes.

• Develop, maintain and troubleshoot complex Excel/VBA models or Python applications, spreadsheets, and templates to support various business functions.
• Design and implement advanced VBA macros and scripts or Python code to automate repetitive tasks, enhance data analysis, and improve workflow efficiency with good documentation. Collaborate with stakeholders and other IT professional and departments to provide technical expertise in designing solutions using Excel and VBA or Python.
• Provide training and support to end-users on Excel/VBA or Python functionalities, best practices, and troubleshooting techniques.
• Stay updated on the latest developments in Excel and VBA/Python technology and proactively identify opportunities to leverage new features or techniques to improve processes.
• Document technical specifications, guidelines, and procedures for Excel/VBA/Python solutions to ensure maintainability and scalability.
• Collaborative and team‑focused attitude.
• Demonstrate basic understanding and enthusiasm about the healthcare industry.
• Be willing to deepen knowledge of the healthcare industry and disease portfolios.
• Be willing to attend conferences and contribute to deliverables where required beyond the automation and tool maintenance responsibilities.
• BSc/MSc in Computer Science, Information Technology, Engineering, or related field.
• Proven experience in advanced Excel development, including proficiency in complex formulas, pivot tables, data visualization, and spreadsheet design principles.
• Strong proficiency in VBA programming, with demonstrable experience in developing macros, user‑defined functions, and custom applications for Excel.
• Proficiency in Python programming, with experience in data manipulation libraries (e.g., pandas, openpyxl), automation scripting and interacting with third‑party APIs for data retrieval and integration.
• Experience with Snowflake database operations, including SQL query development, data extraction, and integration with Python and Excel workflows.
• Excellent communication and decision‑making skills.
• Strong analytical, problem‑solving and decision‑making skills.
• Must be willing to guide, help and train other members within the team.

Problem Solving Skills

• Ability to prioritize, multi‑task at the same time and deliver results without compromise of quality or time.
• Excellent logical ability, problem‑solving skills and attention to detail.
• Excellent analytical skills with experience in dealing with large volumes of data.

Eagerness to Learn

• Should be keen to expand skill sets and learn about business, markets, and industries.
• Willingness to take up additional responsibilities.
• Self‑driven with a keen eye to enhance data quality and processes.

Communication Skills

• Excellent verbal, written and presentation skills.
• Flair for writing and eye for detail.

Leadership Skills

• Positive and proactive attitude, ability to interact with many levels, ability to face and deal with issues in a mature and professional manner.
• Self‑motivated, with proven ability to work efficiently and independently.
• A team player, with strong inter‑personnal skills, who can collaborate effectively within and across the organization.

GlobalData Healthcare is a specialist information services business on a mission to help our Pharma, Biotech and Medical Devices clients decode the future, make better decisions and reach more customers. Using our unique data, expert analysis and innovative solutions we deliver intelligence for companies, government organisations and industry professionals.

We began our GlobalData journey in 2016, by combining a diverse range of specialist information services companies, with decades of trusted customer relationships and deep sector specialism. Why join GlobalData? GlobalData Healthcare is GlobalData's largest division, and at a pivotal point in its growth journey. Following multiple acquisitions and having recently received transformational investment, we are in the process of being carved out from the main GlobalData business. We need curious, ambitious, courageous people to support us in achieving our vision of becoming the world's trusted source of strategic industry intelligence. Our big ambitions mean that life at GlobalData Healthcare is fast‑paced, entrepreneurial and rewarding. We recognise the collective power of our people, and it's the collaboration of our teams that have shaped our success and will continue to do so in the future.