Vba Developer

Job ID: 34666

Job Level: S2

Job Location: Bangalore/Gurgaon

Function: Digital & Information Office (DIO)

Employment Type: Permanent

Working pattern: Hybrid

Why we need this role:

The Project and Portfolio Delivery (PPD) team work in partnership with the business to deliver projects and portfolios that drive Colt's success. We are brave in what we do, trusted by the business, and creative in outthinking.

The PPD team are responsible for:

• Process optimization and re-engineering.
• Business delivery and business acceptance of key strategic projects and programmed and training of the operational teams on new technologies.
• The PPD team is organized into key business portfolios, each responsible for project delivery and process transformation;
• The PMO sits within the PPD, guiding the portfolios through the delivery of projects and programmed in line with our project methodologies; the PMO are responsible for providing quality assurance, reports and tools and leading the portfolios through all planning activities.

What were looking for:

Skills & Experience

Excellent knowledge of Excel Macros, VBA a must

Strong proficiency in advanced Excel functionalities, including VBA, macros, and complex formulas.

Candidate should have 8+ years of relevant experience in VBA Macros Scripting and Coding.

Demonstrate experience in creating sophisticated Excel-based tools and dashboards.

SQL competency: Applicants should be comfortable with database management systems for importing and exporting data from Excel. Data analysis: Applicants should be able to design robust

Good knowledge of Microsoft Office tools including Word and PowerPoint, MS Project statistical analyses and execute them using advanced Excel Macros, VBA scripts, VBA.

Excellent interpersonal and communication skills, with the ability to explain complex data insights in a clear manner.

Excellent organizational and multi-tasking skills with an ability to balance priorities.

Desirable Skills

The below are not essential for the role but full training will be provided:

Good knowledge in Project management Methodologies such as Waterfall and /or Agile

Candidates with background in Financial Services, Banking, Insurance and Capital Markets.

What we offer you:

Looking to make a mark?

At Colt, youll make a difference. Because around here, we empower people. We dont tell you what to do.

Instead, we employ people we trust, who come together across the globe to create intelligent solutions.

Our global teams are full of ambitious, driven people, all working together towards one shared purpose: to put the power of the digital universe in the hands of our customers wherever, whenever and however they want.

We give our people the opportunity to inspire and lead teams, and work on projects that connect people, cities, businesses, and ideas. We want you to help us change the world, for the better.

Diversity and inclusion

Inclusion and valuing diversity of thought and experience are at the heart of our culture here at Colt. From day one, you'll be encouraged to be yourself because we believe thats what helps our people to thrive. We welcome people with diverse backgrounds and experiences, regardless of their gender identity or expression, sexual orientation, race, religion, disability, neurodiversity, age, marital status, pregnancy status, or place of birth.

Most recently we have:

Signed the UN Women Empowerment Principles which guide our Gender Action Plan

Trained 60 (and growing) Colies to be Mental Health First Aiders

Please speak with a member of our recruitment team if you require adjustments to our recruitment process to support you. For more information about our Inclusion and Diversity agenda, visit our DEI pages.

Benefits

Our benefits support you through all parts of life, for both physical and mental health.

Flexible working hours and the option to work from home.

Extensive induction program with experienced mentors and buddies.

Opportunities for further development and educational opportunities.

Global Family Leave Policy.

Employee Assistance Program.

Internal inclusion & diversity employee networks.

A global network

When you join Colt you become part of our global network. We are proud of our colleagues and the stories and experience they bring – take a look at ‘Our People’ site including our Empowered Women in Tech.