Senior Data Engineer

The CompanyEgon Zehnder is trusted advisor to many of the worlds most respected organizations and a leading Executive Search firm with more than 550 consultants and 63 offices in 36 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 Knowledge Centre India KCI Established in January 2005 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 Who we are We are part of Digital-IT team established 17 years ago in Gurgaon India to provide technology support and rollout digital initiatives to 60 plus global offices Digital IT has six key pillars Collaboration Technology Functional Technology Digital Technology Security Architecture Infrastructure Services Digital Success to support business and to take lead on digital transformation initiatives with the total strength of 150 team members across the globeRequirements As a Data Engineer you will be responsible for establishing and optimizing the flow of data throughout the organization while ensuring its security Executing end-to-end data pipeline from designing the technical architecture and developing the application to finally testing and implementing the proposed solution The Data Engineer is expected to help in driving the database architecture and design for Egon Zehnder large-scale Intranet and Internet-based applications The Data Engineer should research new tools and technologies and come up with recommendations on how they can be used in Egon Zehnder applications The Data Engineer will also be expected to actively participate in design and implementation of projects bearing a high degree of technical complexity and or scalability and performance significance Identifying data sources both internal and external and working out a plan for data management that is aligned with organizational data strategy Collaborate cross-functionally with roles such as IT infrastructure Digital application development and Legal to identify and highlight gaps and risks around Cybersecurity and Data Protection such as GDPR Experience Key Competencies Engineering Degree or equivalent 3 years of experience of SQL writing and data modelling skills with a solid understanding of data technologies including RDBMS No-SQL databases Experience with one or more of the following databases SQL Server MySQL PostgreSQL Oracle Couch-base Redis Elastic Search or other NoSQL technologies Proven experience in building ETL ELT pipelines preferably from SQL to Azure services Architecture experience of making ETL operations such as Medallion Architecture etc Familiarity with CI CD practices for data pipelines and version control using Git Experience in integrating new replacing vendor products in existing ecosystem Experience in migrating data structured unstructured data to Data lake Experience or understanding of performance engineering both at system level and database level Experience or understanding of Data Governance Data Quality Data Issue Management Work closely with the implementation teams of the various product lines to ensure that data architectural standards and best practices are being followed consistently across all Egon Zehnder applications Ensure compliance with all regulations policies and procedures Escalate issues risks pro-actively to appropriate stakeholders Regularly communicate status and challenges to team members and management Self-driven with keenness to master suggest and work with different technologies toolsets Excellent communication skills and interpersonal skills suitable for a diverse audience with ability to communicate in a positive friendly and effective manner with technical or non-technical users customers Excellent and resourceful problem-solving skills adaptable and willingness to learn Good analysis skills - to be able to join the dots across multiple applications and interfaces between them Skill Set Experience with one or more of the following databases SQL Server MySQL PostgreSQL Oracle Couch-base Redis Elastic Search or other NoSQL technologies Experience in Data factory and Data Lake technologies Rich Experience in data modelling techniques and creating various data models Experience in Azure cloud services and architecture patterns Understanding of RESTful APIs for data distribution Understanding of deployment architecture and infrastructure in both on-prem and cloud hosting environments Excellent oral and written communication with an ability to articulate complex systems to multiple teams Self-motivation and the ability to work under minimal supervision BenefitsBenefitsBenefits which make us uniqueAt 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 xc2xb7 5 Days working in a Fast-paced work environmentxc2xb7 Work directly with the senior management teamxc2xb7 Reward and Recognitionxc2xb7 Employee friendly policiesxc2xb7 Personal development and trainingxc2xb7 Health Benefits Accident InsurancePotential 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 LocationThe position is based at Egon Zehnders KCI office in Gurgaon Plot no 29 Institutional Area Sector 32 EZIRS Commitment to Diversity InclusionEgon 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 EmployerEgon 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