11+ Macros Jobs in India

Job Description: PEL Data Analyst

Job Title PEL Data Analyst / PEL ADMIN OFFICER

About the Group

Our Client is one of the most reputed service groups in Oman’s construction and mining industry. The organization has grown from a small family

business to one that leads the industry in construction contracting, manufacturing of cement products, building finishes products, roads, asphalt &

infrastructure works and mining amongst other product offerings. The Group has achieved this by basing everything it does on its core values of HSE

& Quality. With a diverse team of over 22,000 employees, The Group endeavours to serve the Sultanate with international quality products &

services to meet the demands of the growing nation.

Purpose of the job

Responsible for all day-to-day activities supporting the improvement of organizational effectiveness by working with extended teams & functions to

develop & implement; high-quality reports, dashboards and performance indicators for the PEL Division.

Key Responsibilities & Activities:

1. Responsible for data modeling and analysis.

2. Responsible for deep data dives and extremely detailed analysis of various data points collected during the need identification phase.

Organize and present data to line management for appropriate guidance and subsequent process mapping.

3. Responsible for rigorous periodic reviews of various individual, functional, business unit, and group metrics and indicators of success.

Through but not limited to – key productivity indicators, result areas, heath meter, performance goals etc. Report results to line

management and support the decision-making process.

4. Responsible for the development of high-quality analytical reports, and training packs.

5. Responsible for all individual and specific departmental productivity targets, financial objectives, KPIs and attainment thereof.

Other tasks:

1. Promoting The Group Values, Code of Conduct and associated policies

2. Participating and providing positive contributions to technical, commercial, planning, safety and quality performance of the organization

and by Client, Contractual, and regulatory requirements

3. Visiting Sites and Project locations to discuss operational aspects and carry out training.

4. Undertaking any other responsibilities as directed and mutually agreed with the Line Management.

The above list is not exhaustive. Individuals may be required to perform additional job-related tasks and duties as assigned.

Educational Qualifications

• Bachelor’s degree in engineering

• Masters (preferred)

Professional Certifications • Certifications related to Data Analyst or Data Scientist (preferred)

Skills

• Advanced Excel, Macros, & MS Power Query and MS Power BI, Google Data Studio (Looker Studio)

• Knowledge of Python, M Code and DAX is a plus

• Data management, Bigdata, Data analysis

• Attention to details and strong analytical skills.

• Strong data management skills

Experience • 4 years position specific experience

• 7 years overall professional experience

Language

• English (fluent)

• Arabic (preferred)

1.       Core Responsibilities

·      Building feasible solutions/applications for our clients – this includes developing bots using Automation Anywhere new cloud-based platform A360, assisting in the design and development of Automation TaskBots to automate Business Processing involving various technologies including Web & Windows applications, Database, Image Recognition (OCR), PDF Integration, API, and Web Services

2.       Experience Requirements

·      5 plus years of Software Development experience in any RPA tool. Preferably Automation Anywhere

·      Providing guiding and training for customers around the application best practices

·      Assist with guidance for the application environment and helping to troubleshoot if necessary

·      Understand the technological pain areas of prospective customers and helping create a Proof of Concept that aligns to their needs and budget

·      Knowledge Requirements

·      Experience with Automation Anywhere, or related robotic process automation software

·      Programming or development experience (Java, .Net, C#, Visual Basic, VB.net, R, etc.)

·      Scripting knowledge or experience (Python, Perl, VB Script, Shell script, PowerShell, etc.)

·      Experience creating macros

·      Ability to understand and create business process workflow diagrams or procedural documentation

·      Understanding of SDLC, Waterfall, and Agile Development Methodologies

·      Exposure to performance measurement and continuous improvement methodologies

·      Strong problem solving and troubleshooting skills

We are looking for a passionate and experienced Data Analyst to join our team! As a Data Analyst at Oneistox, you will play an extremely important role as your insights and findings will be crucial for our growth and success.

Job Responsibilities

• Execution of data validation, profiling, auditing and data cleansing activities
• Collaboration with internal and external stakeholders
• Development, production and management of data quality reports
• Development of key metrics, rules and notifications to identify critical gaps
• Identify opportunities for business process improvements
• Develop and maintain KPIs Dashboards
• Support all Marketing and Sales data requests
• Standardization and automation of data collection and processing
  
  

Job Requirements

• BS in Computer Science, Mathematics or a similar field
• 2-3 years of experience as a Data Analyst or a similar role
• Experience with analytics platforms like Google Analytics, Hubspot and Amplitude is a must
• Familiarity with Javascript is preferred
• Advanced excel a must; Pivot Tables, Macros preferred
• Experience with using a range of data analysis tools
• Advanced analytics capability is a preferred skill
• Understanding of multiple regression analyses
• Experience with performing analysis in a database environment is preferred

Task:

• Make documentations with formatting and in proper detailing
• Basic knowledge on Excel working with formula handling & reporting.
• Need to do multitasking, able to deliver tasks on time with expected quality
• Candidate should have thinking out of the box which supports the department to deliver good results in the pre-defined processes.
• Needs to be quick learner and able to come up with own thoughts on the tasks explained/shared to deliver good results
• Work closely with German team for operative processes/execution/deliverables.
• Flexible to adopt the changes in terms of processes/task handling.
• Knowledge on order fulfillment processes, managing support content on the website, inputs on support handling processes are added advantage.

We wish:

• At least bachelor in any stream or equivalent experience
• At least 1 year of experience in MS-Excel or similar office tools – is preferred
• Knowledge on VB script, macros is preferred
• Documentation skills
• Good Communication skills, at least speaking in English is required
• Good analytical skills
• Eager to know/experiment new technology and tools
• Web Browsing , ability to search quick results from web
• Experience on process documentation & presentation is preferred
• Ability to work independently with little or no daily supervision
• Out of box thinking and quick learner with willingness to learn new things

We Offer:

• Freedom to realise your own ideas & individual career & development opportunity.
• A motivating work environment, flat hierarchical structure, numerous company events which cannot be forgotten and fun at work place with flexibilities.
• Professional challenges and career development opportunities.

• Assess automation opportunities from a technical perspective and provide document solutions in the form of SDD
• Perform detailed estimations towards the finalized scope
• Design, develop, and test automation workflows
• Prepare solution presentation documents, present the solution and implementation plan to the CoE teams and project stakeholders
• Understand client’s business requirements and clearly document them in order for RPA developers to deploy the automation projects in an optimal manner
• Deploy RPA components including bots, robots, development tools, code repositories, and logging tools
• Create process and end-user documentation
• Collaborate with other development team members and guide junior developers to ensure proper implementation and integration of the solutions
• Perform peer review of developed components and test cases
• Support deployments or troubleshoot production issues; flexible to work in shifts when the demand arises
• Should be able to report project status to the stakeholders.

Skills Required

• UiPath
• UiPath Orchestrator
• Sound Knowledge of Microsoft VB, Excel, Macros
• Microsoft Visio, Freemind or equivalent tool
• Documentation and presentation using Microsoft Word and Powerpoint
• Understanding of CSS, HTML
• Experience in automating SAP flows in UiPath
• Excellent communication and presentation skills
• Template development in ABBYY OCR tool and integration if the solution in UiPath
• Knowledge of processes in the Manufacturing/Automotive domain
• Certified Advanced RPA Developer (UiARD)
• Knowledge of other RPA tools

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

• 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