Excel VBA Jobs

At Nyteco we’re proud to offer innovative solutions that meet the needs of the recycled materials industry and manufacturing supply chains. We aim to build, acquire or invest in industry start-ups. To help us continue to grow and improve our offerings we are looking for a Senior data analyst to lead our data management processes. 

Be part of a high-impact role that focuses on data management and analysis tasks within a specific functional area or data type. This role involves heavy communication with data sources. 

Key areas of focus: Data integration, data migration, data warehouse automation, data synchronization, automated data extraction, or other data management projects.

• Build and maintain data pipelines from internal databases.
• Understand and gather the requirements, and convert into ETL logic.
• Data mapping of data elements between source and target systems.
• Create data documentation including mappings and quality thresholds.
• Build and maintain analytical SQL queries, scripts, and dashboards.
• Identify and develop data quality initiatives and opportunities for automation.
• Investigate, track, and report data issues.
• Undertake and complete new data onboarding and/or production data management functions as assigned/required.
• Utilize various data workflow management and analysis tools.
• Automated document generation; creating documents by combining data with pre-existing templates to deliver a custom, personalized document specific to client needs.
• Ability and desire to learn new processes, tools, and technologies.

Skills and Qualifications we are looking for 

• Bachelor's degree in Computer Science, Engineering, or Data related field required; Master's degree not required but preferred.
• 2+ years’ experience in data management.
• Advanced proficiency with Microsoft Excel and VBA.
• Advanced proficiency with SQL.
• Familiarity with Python for data manipulation and process automation; optional but preferred.
• Proficiency with various data types and formats including, but not limited to JSON.
• Intermediate proficiency with HTML.
• Strong background in data analysis, data reporting, and data management coupled with the adept process mapping and improvements.
• Strong research skills.
• Attention to detail.

What we offer 

Work closely with a global team helping bring market intelligence to the recycling world. As a part of our team, we look to foster relationships and help you grow with us. You can also expect: 

• As a global company, we treasure and encourage, diversity, perspective, interest, and representation through inclusivity. The more we have, the better the solution. 

• Connect and work with leading minds from the recycling industry and be part of a growing, energetic global team, across time zones, regions, offices and screens. 

• Exposure to developments and tools within your field ensures evolution in your career and skill building. 

• Flexibility and freedom in how you work along with competitive compensation and yearly appraisal 

• Health insurance coverage, paid vacation days and flexible work hours helping you maintain a work-life balance 

• Have the opportunity to network and collaborate in a diverse community. 

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

We are looking for a Seasoned VBA Excel Macro developer to automate business process steps. Who will work independently as full stack developer creating Macros from scratch, modify existing macros to suit additional requirement or change in environment / input or output formats and provide user support.

In this role, you should be able to write functional Excel Macros with a sharp eye for spotting defects. You should be a team player and excellent communicator. If you are also passionate about the Macro Development with Microsoft Excel, we’d like to meet you.

Your goal will be to work with various operations teams to design, develop and maintain Excel Macros using VBA.

Responsibilities

• Participate in scoping, requirements analysis and solution design

• Collaborate with internal teams to produce software design and architecture

• Write clean, scalable code using Visual Basic for Applications (VBA) languages

• Test and deploy Excel Macros. Revise, update, refactor and debug VBA code

• Develop documentation throughout the software development life cycle (SDLC)

• Update progress of assignment to all concerned stakeholders

• Highlight automation feasibility risks upfront and get buy-in from stakeholders before moving to next step.

Requirements

• 3-5 years Proven experience as a Excel VBA Macro Developer

• Familiarity with the Advance Microsoft Excel Formulas

• Familiarity with Database design and development with MS Access and SQL Server

• Excellent troubleshooting and communication skills

• Attention to details

• BSc/BE in Computer Science, Engineering or a related field.

Qualifications

BE-IT, MCA, BCA, BSc., Any IT graduate

Notice Period- Immediate to 15 Days.

We are looking for a Seasoned VBA Excel Macro developer to automate business process steps. Who will work independently as full stack developer creating Macros from scratch, modify existing macros to suit additional requirement or change in environment / input or output formats and provide user support.

In this role, you should be able to write functional Excel Macros with a sharp eye for spotting defects. You should be a team player and excellent communicator. If you are also passionate about the Macro Development with Microsoft Excel, we’d like to meet you.

Your goal will be to work with various operations teams to design, develop and maintain Excel Macros using VBA.

Responsibilities

• Participate in scoping, requirements analysis and solution design

• Collaborate with internal teams to produce software design and architecture

• Write clean, scalable code using Visual Basic for Applications (VBA) languages

• Test and deploy Excel Macros. Revise, update, refactor and debug VBA code

• Develop documentation throughout the software development life cycle (SDLC)

• Update progress of assignment to all concerned stakeholders

• Highlight automation feasibility risks upfront and get buy-in from stakeholders before moving to next step.

Requirements

• 3-5 years Proven experience as a Excel VBA Macro Developer

• Familiarity with the Advance Microsoft Excel Formulas

• Familiarity with Database design and development with MS Access and SQL Server

• Excellent troubleshooting and communication skills

• Attention to details

• BSc/BE in Computer Science, Engineering or a related field.

Qualifications

BE-IT, MCA, BCA, BSc., Any IT graduate

Notice Period- Immediate to 15 Days.

We are looking for a Seasoned VBA Excel Macro developer to automate business process steps. Who will work independently as full stack developer creating Macros from scratch, modify existing macros to suit additional requirement or change in environment / input or output formats and provide user support.

In this role, you should be able to write functional Excel Macros with a sharp eye for spotting defects. You should be a team player and excellent communicator. If you are also passionate about the Macro Development with Microsoft Excel, we’d like to meet you.

Your goal will be to work with various operations teams to design, develop and maintain Excel Macros using VBA.

Responsibilities

• Participate in scoping, requirements analysis and solution design

• Collaborate with internal teams to produce software design and architecture

• Write clean, scalable code using Visual Basic for Applications (VBA) languages

• Test and deploy Excel Macros. Revise, update, refactor and debug VBA code

• Develop documentation throughout the software development life cycle (SDLC)

• Update progress of assignment to all concerned stakeholders

• Highlight automation feasibility risks upfront and get buy-in from stakeholders before moving to next step.

Requirements

• 3-5 years Proven experience as a Excel VBA Macro Developer

• Familiarity with the Advance Microsoft Excel Formulas

• Familiarity with Database design and development with MS Access and SQL Server

• Excellent troubleshooting and communication skills

• Attention to details

• BSc/BE in Computer Science, Engineering or a related field.

Qualifications

BE-IT, MCA, BCA, BSc., Any IT graduate

Notice Period- Immediate to 15 Days.

VB Macros expert

Mandatory Skills :

• Should have Expertise in VBA skills (Ability to create complex forms/functions/subroutines, Experience using constants and visibility modifiers, Programmatic manipulation of objects/tables/data connections/formulas/loop)

• Experience with consolidating extracted data from multiple resources using automated tools (excel, VBA macro, SQL database), and/or from different system/tools/Database

• Expertise in building complex VBA scripts to automate Excel spreadsheet processes.
  
  

Location : Chennai

Timings : UK shift

Experience- 5 to 7 YRS

Designation-  Assistant Manager

Location- Mumbai

Notice Period- Immediate to 15 Days.

Job Description –

We are looking for a Seasoned VBA Excel Macro developer to automate business process steps. Who will work independently as full stack developer creating Macros from scratch, modify existing macros to suit additional requirement or change in environment / input or output formats and provide user support.

In this role, you should be able to write functional Excel Macros with a sharp eye for spotting defects. You should be a team player and excellent communicator. If you are also passionate about the Macro Development with Microsoft Excel, we’d like to meet you.

Your goal will be to work with various operations teams to design, develop and maintain Excel Macros using VBA.

Responsibilities : 

• Participate in scoping, requirements analysis and solution design
• Collaborate with internal teams to produce software design and architecture
• Write clean, scalable code using Visual Basic for Applications (VBA) languages
• Test and deploy Excel Macros. Revise, update, refactor and debug VBA code
• Develop documentation throughout the software development life cycle (SDLC)
• Update progress of assignment to all concerned stakeholders
• Highlight automation feasibility risks upfront and get buy-in from stakeholders before moving to next step

Requirements : 

• 3-5 years Proven experience as a Excel VBA Macro Developer
• Familiarity with the Advance Microsoft Excel Formulas
• Familiarity with Database design and development with MS Access and SQL Server
• Excellent troubleshooting and communication skills
• Attention to detailS
• BSc/BE in Computer Science, Engineering or a related field

Qualifications : 

BE-IT, MCA, BCA, BSc., Any IT graduate

Experience- 5 to 7 YRS

Designation-  Assistant Manager

Location- Mumbai

Notice Period- Immediate to 15 Days

Job Description-

Good Excel knowledge - able to create dashboards, pivots, formulas, keyboard shortcuts

·         Mandatory skills are good knowledge of object-oriented concepts and candidate must have clear understanding of database concepts

·         Must have good 3-4 years of SQL Queries (using Access database) & Java scripts

·         Good communication skills to interact with clients

·         Overall have finance & accounting domain knowledge

·         Ability to comprehend emails from other employees and action work accordingly

·         Time Management: must be able to multi-task, be detail oriented and demonstrate strong organizational skills

Additional information

Should be ok with working in 24* 7 environment.

• 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