Data Analyst (VBA)

Egon Zehnder

Egon Zehnder ( is trusted advisor to many of the world’s most respected organizations and a leading Executive Search firm, with more than 400 consultants and 69 offices in 41 countries spanning Europe, the Americas, Asia Pacific, the Middle East and Africa. Our clients range from the largest corporations to emerging growth companies, government and regulatory bodies, and major educational and cultural institutions. The firm is a private partnership which allows us to operate independent of any outside interests. As a result of this unique culture, Egon Zehnder has the highest professional staff retention rate for a global firm in our profession. We have a blue chip client base across all industries and operate at the Board and senior management level.

Egon Zehnder, Knowledge Centre India (KCI)

Established in December 2004, KCI in Gurgaon, works in close collaboration with the Global offices of Egon Zehnder. There are 5 teams that make up KCI: Research, Research Operations, Visual Solutions, Projects/CV Capture and Digital IT.

To know more about the teams, our culture

The position

Data Analyst – Data Analytics

The Analyst will be responsible for work on day-to-day Power BI requests. He/She should be able to help the stakeholders on improving the processes via automation of projects. The analysts should be able to deep dive into the data for insights and also be able to formulate Power BI tasks and solutions. 

Shift Timings: Flexible

Principal Responsibilities

• Request processing – Working on ad-hoc requests, communication with stakeholders.
• Process management – Quality Control, Maintenance of Power BI Dashboards
• Timely and accurate MIS reporting
• Able to cater excel automation requests.

Key Result Areas

• Participate and contribute to formulate Power BI tasks and solutions.
• Should be able to work on automating the processes for stakeholders using macros.
• Drive end-to-end insights creation-to-consumption lifecycle, leading business problem definition, designing and delivering the solutions.
• Oversee the mapping of data sources, data movement with the goal of ensuring data quality.
• Active participation in the trouble shooting issues including root cause analysis.
• Designing documents for the newly introduced tasks and processes along with maintaining the existing ones. 

Candidate Profile

• 1 year of experience in Business Intelligence & Data Visualization.
• 1 year of experience VBA and Excel.
• Basic technical knowledge about best practices in VBA automation.
• Understanding of data modelling techniques, meta data preparation, types of mapping etc. would be a plus.
• Knowledge about Azure platform is a benefit.
• Knowledge about finance/ controlling also considered a benefit (understanding of basic concepts)
• Ability to work with colleagues from diverse geographies.
• Advance Excel skills
• Self-motivated, must be able to work independently, prioritize daily activities.
• Flexible to work in any business shift as per the business requirement.

Location

The position is located at Plot no. 29, Institutional Area, Sector 32, Gurgaon within the offices of Egon Zehnder Knowledge Center India (EZKCI).

Egon Zehnder is an Equal Opportunity Employer

Egon Zehnder provides equal employment opportunities to all applicants and employees without regard to race, color, creed, religion, sex, sexual orientation, gender identity, marital status, citizenship status, age, national origin, disability, or any other legally protected status and to affirmatively seek to advance the principles of equal employment opportunity.

Benefits which make us unique

At EZ, we know that great people are what makes a great firm. We value our people and offer employees a comprehensive benefits package. Learn more about what working at Egon Zehnder can mean for you!

Benefits Highlights:

• 5 Days working in a Fast-paced work environment
• Work directly with the senior management team
• Reward and Recognition
• Employee friendly policies
• Personal development and training
• Health Benefits, Accident Insurance

Potential Growth for you!

We will nurture your talent in an inclusive culture that values diversity. You will be doing regular catchups with your Manager who will act as your career coach and guide you in your career goals and aspirations.

Location

The position is based at Egon Zehnder’s KCI office in Gurgaon, Plot no. 29, Institutional Area Sector 32.

EZIRS Commitment to Diversity & Inclusion

Egon Zehnder Information Research & Services (EZIRS) aims for a diverse workplace and strive to continuously lead with our firm values. We respect personal values of every individual irrespective of race, national or social origin, gender, religion, political or other opinion, disability, age and sexual orientation as warranted by basic rights enshrined in the UN Declaration of Human Rights. We believe diversity of our firm is central to the success and enables us to deliver better solutions for our clients. We are committed to creating an inclusive environment and supportive work environment, where everyone feels comfortable to be themselves and treated with dignity and respect and there is no unlawful discrimination related to employment, recruitment, training, promotion or remuneration.

Egon Zehnder is an Equal Opportunity Employer

Egon Zehnder provides equal employment opportunities to all applicants and employees without regard to race, color, creed, religion, sex, sexual orientation, gender identity, marital status, citizenship status, age, national origin, disability, or any other legally protected status and to affirmatively seek to advance the principles of equal employment opportunity.