About the job

About Omnicom Media Group Nepal

Our mission is to provide exceptional technology services to OMG agencies. Established in 2013, Omnicom Media Group Nepal is a software company in Nepal and a subsidiary of OmnicomMediaGroup Australia - ranked top in media agencies in Australia. 

We are a team of around 200+ professionals who are involved in design, development, testing and maintenance of software projects developed in latest technologies. Besides that, our people are also involved in Programmatic projects which involves conversion of business.

Our core competency is Software development in the latest stack of technologies, Business Intelligence, Programmatic and Delivering Finance Function tasks. 

We strive to go “above and beyond” through our culture of continuous development and improvement and has embedded those into our company values:

• We are all in this together
• Lead from the back/everyone is a boss
• Continuous Improvement & Development
• Open and Honest Communication is vital
• Everyone has access to all information 

We offer:

• Great work culture and environment
• Employee growth and development
• Exposure to latest technologies, teams and tools
• World class best practices

About OMG Facilitator

OMG Facilitator is a centralized business unit within OMG AU combining the services of Digital Ad Operations, Reporting & BI, Media Systems Support (MSS) and data services via our Datawarehouse (DAWA). OMG Facilitator is also responsible for development of business automation services such as the OMG Master Media Plan (MMP) template.

About the role

The Process Automation Analyst (Excel) role will work predominantly with our RPA Solutions Engineer, with a focus on supporting and developing the latest version of the MMP. Other tasks will include creating ad-hoc excel based reporting solutions for our Reporting & BI team.

Qualifications, Skills and Competencies: 

• Understand VBA syntax, functions, and procedures, using the macro recorder
• 1-2 years’ experience writing and debugging VBA code in applications like Microsoft Excel and Outlook (dependent on frequency of use, give examples of usage)
• Proficiency in debugging VBA (Stepping through code F8; How to set and use breakpoints F9; Use the Immediate Window for debugging; return information, or execute code; Understand how values are passed or called between procedures and functions)
• Can read, understand, and trace formulas, able to determine what each step in the calculation is being returned
• 1 year experience with Power Query
• Understand the M language and how to use the Advanced Editor
• Able to identify where errors occur and diagnose what is causing the error
• Understand SQL and set connections to data sources
• Have strong problem-solving skills, keen to learn, have a good understanding of Office applications

Why you'll love us

Through our people philosophy, we believe that happy people with a great work/life balance are able to bring the #WOW factor to work and they're more fun to share an office with. Join us and surround yourself with like-minded, high-achieving individuals and unbeatable career development opportunities.

To know more about us, please visit the link at https://www.omnicommediagroup.com.np/

Our working hours are from 7 AM till 4 PM, Monday to Friday.