Data Architect

The Company

Egon Zehnder

Egon Zehnder, 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: Experts, Research Operations, Visual Solutions, Projects/CV Capture and Global Technology Services.

**Requirements**:
The data architect is expected to formulates the organizational data strategy, including standards of data quality, the flow of data within the organization, and security of data.

The Data Architect 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.

**Experience and Key Competencies**:

- Engineering Degree or equivalent.
- 10+ 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.
- Experience in integrating new/replacing vendor products in existing ecosystem.
- Experience in migrating data structured, unstructured data to Data lake
- Experience and hands on experience in Application Integration.
- Experience or understanding of performance engineering both at system level and database level.
- Solid understanding of Microservices based architecture.
- Experience or understanding of Data Governance, Data Quality, Data Issue Management.
- Stakeholder management with an ability to gain others support for ideas, proposals, projects, and solutions.
- 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.
- Ensure code can be deployed using Azure DevOps.

**Skills**
- Experience with one or more of the following databases: SQL Server, MySQL, PostgreSQL, Oracle, Couch-base, Redis, Elastic Search or other NoSQL technologies. Experience on Azure Purview is a plus
- 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.
- Ability to Understand and articulate the technical merits.
- 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 mínimal supervision
- Experience with JSON, JSON-LD, XML data structures.
- Experience implementing data pipelines using latest technologies and techniques.
- Experience with SDLC products (JIRA, Confluence, Github, etc) or similar agile project management tools.
- Experience handling Structured and unstructured datasets.
- Expert in USQL, Python, Spark SQL, Data Bricks.
- Strong t-SQL skills with experience in Azure SQL Data Warehouse.
- Experience in Data Modelling and Advanced SQL techniques.
- Azure Cloud migration methodologies and processes including tools like Azure Data Factory, Event Hub, etc.

**Location**

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

Sector 32

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**
- 5 Days working
- Hybrid Work option
- Reward and Recognition
- Employee friendly policies
- Personnel development and training
- Health Benefits, Accident Insurance
- Gender Diversity