22+ Excel VBA Jobs in India

1. Bridging the gap between IT and the business using data analytics to assess processes, determine requirements and deliver data-driven recommendations and reports to executives and stakeholders.

2. Ability to search, extract, transform and load data from various databases, cleanse and refine data until it is fit-for-purpose

3. Work within various time constraints to meet critical business needs, while measuring and identifying activities performed and ensuring service requirements are met

4. Prioritization of issues to meet deadlines while ensuring high-quality delivery

5. Ability to pull data and to perform ad hoc reporting and analysis as needed

6. Ability to adapt quickly to new and changing technical environments as well as strong analytical and problem-solving abilities

7. Strong interpersonal and presentation skills

SKILLS:

1. Advanced skills in designing reporting interfaces and interactive dashboards in Google Sheets and Excel

2. Experience working with senior decision-makers

3. Strong advanced SQL/MySQL and Python skills with the ability to fetch data from the Data Warehouse as per the stakeholder's requirement

4. Good Knowledge and experience in Excel VBA and advanced excel

5. Good Experience in building Tableau analytical Dashboards as per the stake holder's reporting requirements

6. Strong communication/interpersonal skills

PERSONA:

1. Experience in working on adhoc requirements

2. Ability to toggle around with shifting priorities

3. Experience in working for Fintech or E-commerce industry is preferable

4. Engineering 2+ years of experience as a Business Analyst for the finance processes

Management skills for supervising individuals and departments

 Interpersonal and communication skills for building relationships with their teams, peers, and directors

 Numeracy skills for managing quality reports

 Writing skills for preparing reports

 Negotiating skills for handling the resources per quality performance  Organizational skills for prioritizing their deliverables

 Must be well versed with quality standards and parameters and checks

 Training skills for providing project instructions and feedback to team members

 Proven work experience as a Quality Analyst or similar role

 Experience in quality inspection, auditing and testing

 Strong computer skills and knowledge of QA databases and applications

 Strong analytical and problem-solving skills

 Meticulous attention to detail

Role:

 Data Sourcing and cleaning –

• Includes Data mapping, format standardisation and creation & management of

Master Data files

 Iterative modelling –

• Managing multiple data sets and set connections keeping the flexibility and

efficiency in mind

 Visualization and output creation

• Provide actionable insight through easy-to-use dashboards based on the guidelines

from the client

 Reporting –

• Compiling and reporting on time based on the timelines set for each task

Please apply with updated CV and the following details:

 Current Salary (fix and variable)

 Expected Salary

 Current Employer

 Current Location

 Notice Period, if an

Is your next career move to work in a team which uses data, reporting and analytical skills to help answer business questions to make DAZN a data-driven company?

DAZN is a tech-first sport streaming platform that reaches millions of users every week. We are challenging a traditional industry and giving power back to the fans. Our new Hyderabad tech hub will be the engine that drives us forward to the future. We’re pushing boundaries and doing things no-one has done before. Here, you have the opportunity to make your mark and the power to make change happen - to make a difference for our customers. When you join DAZN you will work on projects that impact millions of lives thanks to your critical contributions to our global products

This is the perfect place to work if you are passionate about technology and want an opportunity to use your creativity to help grow and scale a global range of IT systems, Infrastructure, and IT Services. Our cutting-edge technology allows us to stream sports content to millions of concurrent viewers globally across multiple platforms and devices. DAZN’s Cloud based architecture unifies a range of technologies in order to deliver a seamless user experience and support a global user base and company infrastructure.

This role will be based in our brand-new Hyderabad office. Join us in India’s beautiful “City of Pearls” and bring your ambition to life.

Responsibilities:

• Communicate with different stakeholders such as Ad Tech Engineers and Product Owners
• Should be able to extensively work in Google Analytics and strong SQL knowledge is expected.
• Strong analytical skills

Key Competencies:

• 4-8 years of experience as Data Analyst
• Advanced Microsoft Excel Skills
• Strong command on Google Analytics
• Reporting platform UI experience (Tableau, Looker, etc)
• Experience with VAST tags, pixels trackers, etc.
• Experience with DSPs & third-party ad platforms (GAM, YoSpace, etc)

At DAZN, we bring ambition to life. We are innovators, game-changers and pioneers. So, if you want to push boundaries and make an impact, DAZN is the place to be.

As part of our team, you'll have the opportunity to make your mark and the power to make change happen. We're doing things no-one has done before, giving fans and customers access to sport anytime, anywhere. We're using world-class technology to transform sports and revolutionise the industry and we're not going to stop.

Position Full-Time: Investment Engineering Associate

Specific Responsibilities

The Investment Engineering Associate’s main responsibilities will include supporting the investment team by building technology-based analytical tools. The Investment Engineering Associate will design and maintain workflows vital to the firm’s investment process - this ranges from creating adhoc analysis to information rich dashboard construction. Typical tasks will include web crawler scripting/collection, web application development, programming (including API integrations), and optimal database/library/query management.

Qualifications

• BS or MS in Computer Science, Engineering, or Data Science

• 2+ years of experience • Candidates should have extensive experience with several of the following languages: Python, Ruby, C/C++, Javascript, HTML5, CSS3, SQL, PHP, etc.

• The Investment Solutions Associate should be familiar with Office VBA • Characteristics of the Solutions Associate include: effective communication skills, attention to detail, and strong ethical values

Responsibilities

• To Co-ordinate with regional teams and collect the required data
• Knowledge of advanced MS Excel, Presentation is a must
• Candidate must be able to handle large data sets and handle spreadsheets.
• Good at analyzing the data & Presentation
• Coordination with the team for timely submission of reports, tracking progress
• Understand the reporting model infrastructure and implement streamlined process solutions toward a more efficient reporting model.
• Preparation and analysis of daily, weekly, and monthly reports of different functions and summarizing the same
• Must be able to Generate/Update Reports, Create dashboards, Pivot tables
• Monthly/ Quarterly reconciliations and data cleansing to ensure the integrity of reported numbers.
• Review and investigate trends and provide commentary for management.
• Finding discrepancies in the process and arriving at a resolution

Eligibility

• Proven experience in MIS
• Ability to be self-motivated and self-directed and think and act independently while also being team oriented
• Good follow-up skills, the ability to understand, adaptability to process changes, and a strong sense of importance and ownership
• Good in numbers (Mathematics)
• Good in Excel
• Good communication skills

Personal skills:

Strong interpersonal and team working skills

Self-motivated that is able to work with minimal supervision

Demonstrate strong analytical and problem-solving skills

Ability to communicate effectively at all levels Strong attention to detail

Experience creating PowerPoint slide decks and along with that experience in automating the PowerPoint slide creation using excel VBA Formats extracted data based on expected report output with batching capability and multiple data formatting requirements Consolidate and combine extracted data from multiple resources using automated tools excel, VBA macro, SQL database, and/or from different system/tools/Database in one single database using SQL queries to standardize data structure

Professional Attributes :
Gathers and analyse report requirements from stakeholders Identify the processing tool Excel / SQL and provide a robust solution which can be easily leveraged or extended to other domains Building complex VBA scripts to automate Excel spreadsheet processes

• Strong technical skills on UiPath, and end to end UiPath offerings
• Understanding of workflow-based logic and hands on experience with RE-framework.
• Excellent communication skill is a must
• Basic programming/Scripting knowledge on VBA/VB/java/C# script is must
• Knowledge in cognitive automation with OCR tools, AI/ML skills is a plus.
• Excellent software development background with any of the following (C#, C++, Java, .NET) is a plus
• Experience working on other RPA tools/vendors is a plus
• Experience in the field of Bot development
• UiPath RPA developer advanced certificate must.

Job Description

We are looking for a senior resource with Analyst skills and knowledge of IT projects, to support delivery of risk mitigation activities and automation in Aviva’s Global Finance Data Office. The successful candidate will bring structure to this new role in a developing team, with excellent communication, organisational and analytical skills. The Candidate will play the primary role of supporting data governance project/change activities. Candidates should be comfortable with ambiguity in a fast-paced and ever-changing environment. Preferred skills include knowledge of Data Governance, Informatica Axon, SQL, AWS. In our team, success is measured by results and we encourage flexible working where possible.

Key Responsibilities

• Engage with stakeholders to drive delivery of the Finance Data Strategy
• Support data governance project/change activities in Aviva’s Finance function.
• Identify opportunities and implement Automations for enhanced performance of the Team

Required profile

• Relevant work experience in at least one of the following: business/project analyst, project/change management and data analytics.
• Proven track record of successful communication of analytical outcomes, including an ability to effectively communicate with both business and technical teams.
• Ability to manage multiple, competing priorities and hold the team and stakeholders to account on progress.
• Contribute, plan and execute end to end data governance framework.
• Basic knowledge of IT systems/projects and the development lifecycle.
• Experience gathering business requirements and reports.
• Advanced experience of MS Excel data processing (VBA Macros).
• Good communication

Additional Information

Degree in a quantitative or scientific field (e.g. Engineering, MBA Finance, Project Management) and/or experience in data governance/quality/privacy
Knowledge of Finance systems/processes
Experience in analysing large data sets using dedicated analytics tools

Designation – Assistant Manager TS

Location – Bangalore

Should be CA qualified, or an MBA Finance, similar & relevant qualification, Big4 experience preferred

Work Experience : 3-5 years of relevant experience required.
Salary Range 6-8LPA

Financial Reporting:
•Management Accounting, Reconciliation, Intercompany Reconciliation,   accounts payable and receivable
•Ensure that all tax returns, tax declarations, and other required reports are submitted accurately and on time, management of Companies Act Compliances
•Responsible for oversight and providing guidance to core activities such as: fixed asset management, taxation
•Compliance with federal, state, and local legal requirements
•Responsible for preparation of monthly performance decks, sales and other reporting requirements

• 5 to 8 years of hands-on experience in automating MS Office applications like Excel, Word, PPT and Outlook using VBA
• 5 plus years of experience in the design, development, and implementation of programming code
• Experience in database development
• VBA - Should have good experience in developing efficient logic/algorithms using VBA
• Solid understanding of SDLC concepts
• Solid experience in MS Excel (2003, 2007, 2010, 2013,2016)
• Must be good at all excel features and excel formulas
• Well versed with complete MS Office package (Excel, Word, Outlook, PPT)
• Work both independently and as part of a team
• Experience in requirements gathering, effort estimate, designing and implementation, and creating mock-up screens
• Experience in databases like MS SQL Server(2005 to 2012,2014), MySQL, and MS Access
• Must have strong database concepts and DB designing skills
• SQL - must be good at writing efficient, fine-tuned queries using joins and aggregates
• Experience in writing Stored procedures, Triggers and T-SQL
• Nice to have programming knowledge in C# coding should be MANDATORY
• working with C# DLL development and integration with Excel VBA

Interpersonal

• Strong analytical and problem-solving skills
• Excellent interpersonal and communication skills
• Should be able to take complete ownership of the project from requirements gathering to delivery and maintenance
• Should be able to work independently
• Must be Proactive and Self-motivated
• Must have the ability to prioritize the work, execute tasks and meet the deadline without fail
• Effective time management skills
• Customer Focus, Willing to learn and self-teach any new technology
• Strong business and collaboration skills, and responsive to service needs and operational demands

• 5 to 8 years of hands on experience in automating MS Office applications like Excel, Word, PPT and Outlook using VBA 
• 5 plus years of experience in the design, development, and implementation of programming code
• Experience in database development
• VBA - Should have good experience in developing efficient logic/algorithms using VBA
• Solid understanding of SDLC concepts 
• Solid experience in MS Excel (2003, 2007, 2010, 2013,2016)
• Must be good at all excel features and excel formulas 
• Well versed with complete MS Office package (Excel, Word, Outlook, PPT)
• Work both independently and as part of a team 
• Experience in requirements gathering, effort estimate, designing and implementation and creating mock-up screens 
• Experience in databases like MS SQL Server (2005 to 2012,2014), MySQL and MS Access 
• Must have strong database concepts and DB designing skills 
• SQL - must be good at writing efficient, fine-tuned queries using joins and aggregates 
• Experience in writing Stored procedures, Triggers and T-SQL
• Nice to have programming knowledge in C# 

• VBA, SQL 

• Strong analytical and problem-solving skills 
• Excellent interpersonal and communication skills 
• Should be able to take complete ownership of the project from requirements gathering to delivery and maintenance 
• Should be able to work independently 
• Must be Proactive and Self-motivated
• Must have the ability to prioritize the work, execute tasks and meet the deadline without fail 
• Effective time management skills 
• Customer Focus, Willing to learn and self- teach any new technology 
• Strong business and collaboration skills, and responsive to service needs and operational demands.

Job Description

Create intelligent dashboards and analytics for business team using advanced excel/access and powerpoint

Understand the sales and leadership metrics and create business reports with insights and recommendation

Maintain documentation related to reports/procedures and personal tasks

Collaborate with internal team for required inputs within deadline

Perform quality checks for data correctness and execute with fine attention to details

2-5 years of industry experience in MIS reports

Proficiency in advanced excel including Macros

High attention to details with ability to keep track of the assigned tasks

Willingness to work on flexible hours, ability to plan, estimate deadlines, prioritize workload

Skills required:

1. Advanced excel knowledge

2. Practical knowledge of Macros

3. Graduation is necessary

4. Min. experience of 2-3 years