VBA Developer
Bangalore, IN
Colt provides network, voice and data centre services to thousands of businesses around the world, allowing them to focus on delivering their business goals instead of the underlying infrastructure.
Job ID - 34624
Job Level: PT1 Advance
Job Location: Bangalore
Function: Digital Information Office
Employment Type: Perm
Working pattern: Hybrid
What you will do:
The PPD team are responsible for:
• Process optimisation and re-engineering;
• Business delivery and business acceptance of key strategic projects and programmes and training of the operational teams on new technologies;
• The PPD team is organised 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 programmes 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.
The role will cover all aspects of Project Management Office including, Data Analysis , Stakeholder Management, Project Review cycle, Risk Management, Governance, Financial Management, Reporting and KPIs
• Extract Data from different sources, using formulas, pivot tables and graphs to manipulate the data.
• Develop advanced Excel-based applications and tools. - Design and implement complex Excel formulas, macros, and VBA scripts. - Collaborate with stakeholders to understand data and reporting needs. - Optimize workbook performance and ensure data integrity.
• Establish project documentation requirements and/or procedures and ensure stakeholders adherence to the Governance processes
• Produce, track and report programme / project progress and performance, identify issues and recommend changes when necessary
• Support adoption and delivery of corporate governance expectations and setup and management of SharePoint sites for individual projects
• Carry out risk assessments and capture them in a risk register, involving stakeholders and referring to specialists where relevant (e.g. legal and regulatory requirements)
• Assess potential impact of change requests and make recommendation(s)
• Provides the day-to-day level support to program and project teams within the specified discipline
• Provides guidance and advice within the specific discipline to the project or program team and peer level contacts within the customer organisation
• Update relevant programme / project documents to reflect agreed changes and ensure traceability e.g. plan, schedules, product backlogs and the business case
• Share information, good practice and expertise with others
• Produce forecasts for project and PMO performance based on historical analysis for resource planning, budgeting, and timeline prediction
• Recognise and rectify data exceptions through working with project teams or colleagues in the PMO
• Lead and support regular stakeholder meetings, including resource meetings, operational updates and team meetings / produce and circulate minutes capturing records of decisions, update action logs as required and manage relationships and expectations with key stakeholders
• Collaborate with team mates to manage teams shared email inbox, share knowledge & best practice, cover absence and ensure delivery of consistent quality service to customers
What we’re looking for:
Skills & Experience
Must haves:
• Excellent knowledge Excel Macro’s, VBA a must.
• Good knowledge of Microsoft Office tools including Word and PowerPoint, MS Project.
• Good knowledge of project management Life Cycle.
• Good communicator, both written and verbal.
• Excellent organisational and multi-tasking skills with an ability to balance priorities.
• Possesses Go-getter approach with a 'can-do' attitude.
• Strives for continuous improvement in the work area.
• A team player with an approach of building and maintaining a collaborative work environment.
• Proven ability to work in diverse and a multi-cultural working environment.
• Proven ability to thrive in a fast-paced environment and work well under pressure.
• Works on own initiative where necessary.
• Proactive, flexible and helpful attitude.
Might haves:
• Good knowledge in Project management Methodologies such as Waterfall and /or Agile
• Candidates with background in Financial Services, Banking, Insurance and Capital Markets
• 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 statistical analyses and execute them using VBA.
• Certification in Project/Programme Management.
Qualifications
• Bachelor’s in engineering/computes science/information technology or any relevant degree.
What we offer you:
Looking to make a mark?
At Colt, you’ll make a difference. Because around here, we empower people. We don’t 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 that’s 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) Colties 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.
Job Segment:
.NET, Data Analyst, Project Manager, Developer, Information Technology, Technology, Data