Country: India
Position Location: Noida, Bangalore
Contract Type: Permanent
Work Pattern: Full Time
Sector: Digital Ventures
Discipline: Digital design
Job Ref: 2362
Recruiter Contact: Shael Bansal
Job Description
Mott MacDonald digital hub is currently in the middle of an exciting digital program, which involves developing automation tools for different businesses. As a VBA Developer for Business Applications you will be working with the team to enhance and further develop the new automation tools and maintain and do essential updates to the legacy systems. In addition, you will be creating and updating interfaces of various systems over time.
Roles And Responsibilities
- Develop solutions using VBA to automate various business processes followed by various teams
- Automate data extraction and data validation in Excel using VBA
- Automate Word document and Power Point presentation creation using VBA
- Development of excel spreadsheets using Power Query and Advanced formulas.
- The team is also responsible for several other applications and you will have the opportunity to do development of:
- Create complex business logic using a no-code solution like Power Platform.
- Create applications and scripts using Python and SQL.
Your Other Responsibilities Will Include
- Discuss and refine requirements with the stakeholders in the initial phase of development.
- Advise business analysts on technical requirements and create automation process prototypes where necessary.
- Peer Review the work of other developers when needed.
- Undertake developer testing on system changes made, before these changes are passed to the Business Analyst for Functional testing.
- Create change records in line with IT policy and carry out deployments between the development and test environments.
Candidate Specification
- Strong knowledge in writing VBA codes in Excel or other Office applications (3+ years of experience is desirable)
- Have extensively used excel formulas to solve complex automation problems
- Have used power query to connect data from different sources in excel
- Good verbal and written communication skills
- Experience in any of these is highly desirable
- Python
- SQL
- Experience working in an agile environment
- Ability to work both independently and in a team-oriented, collaborative environment.
- An excellent level of written and spoken English is essential.
We Can Offer (subject To Company's Policy)
- Agile and safe working environment
- Competitive annual leave and sick leaves
- Group incentive scheme
- Group term life insurance, Workmen's compensation and Group medical insurance coverage
- Short and Long-term Global employment opportunities
- Global collaboration and knowledge sharing
- Digital Innovation and Transformation
Equality, diversity and inclusion
We put equality, diversity and inclusion at the heart of our business, seeking to promote fair employment procedures and practices to ensure equal opportunities for all. We encourage individual expression in our workplace and are committed to creating an inclusive environment where everyone feels they have the opportunity to contribute.
Agile working
At Mott MacDonald, we believe it makes business sense for you and your manager to choose how you can work most effectively to meet your client, team and personal commitments. We embrace agility, flexibility and trust.
