Gurgaon,

Sr Data Engineer

Job ID

9771

Posted

20-Apr-2021

Service line

Advisory Segment

Role type

Full-time

Areas of Interest

Digital & Technology / Information Technology

Location(s)

Gurgaon - Haryana - India

As a Senior Data Engineer, you will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross-functional teams. The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up.

The Data Engineer will support our software developers, database architects, application reporting team and will ensure optimal data delivery architecture is consistent throughout ongoing projects. They must be self-directed and comfortable supporting the data needs of multiple teams, systems and products. The right candidate will be excited by the prospect of data process automation and optimizing or even re-designing our company's data architecture to support our next generation of products and data initiatives.

Key Responsibilities :

- Create and maintain optimal data pipeline architecture,

- Assemble large complex data sets that meet functional / non-functional business requirements.

- Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

- Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and Azure - big data- technologies.

- Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.

- Keep our data separated and secure across national boundaries through multiple data centers and Azure regions.

- Work with data and analytics experts to strive for greater functionality in our data systems.

- Test databases and perform bug fixes.

- Develop best practices for database design and development activities.

- Ability to quickly analyze existing T-SQL code and make improvements to enhance performance, take advantage of new SQL features, close security gaps, and increase robustness and maintainability of the code.

- Take on technical leadership responsibilities of database projects across various scrum

teams

Required Knowledge & Skills :

- Experience: 6-10 years would be preferable. Knowledge details are:

- Expert knowledge in Azure Data Factory to building and maintain data pipelines and flows.

- Solid understanding of normalization and denormalization of data, database exception handling, transactions, profiling queries, performance counters, and debugging techniques

- Experience with NoSQL database to migrate data into another type of databases with real-time replication.

- Understanding of index design and performance-tuning techniques

- Reviewing query performance and optimizing code

- Writing queries used for front-end applications (websites, desktop applications, or cloud apps)

- Familiarity with SQL security techniques such as data encryption at the column level, Transparent Data Encryption (TDE), signed stored procedures, and assignment of user permissions

- Designing and coding database tables to store the application's data

- Data modeling to visualize database structure

- Working with application developers to create optimized queries

- Creating database triggers for automation, e.g., automatic email notifications

- Creating table indexes to improve database performance

- Programming views, stored procedures, and functions

- Adhere to standards for all database e.g., Data Models, Data Architecture and Naming Conventions

- Exposure to Source control like GIT

- Understanding of Agile methodologies

- Competence in SQL Server (2016 experience preferred). Advanced PL/SQL, Stored Procedures etc.

Personal Attributes:

- Very good communication skills.

- Ability to easily fit into a distributed development team.

- Customer service-oriented.

- Enthusiastic/High initiative.

- Ability to manage timelines of multiple initiatives.

- Very good attention to detail and the ability to always follow up

Gurgaon,

CBRE Group, Inc. (NYSE:CBRE), a Fortune 500 and S&P 500 company headquartered in Los Angeles, is the world’s largest commercial real estate services and investment firm (based on 2019 revenue). The company has more than 100,000 employees (excluding affiliates) and serves real estate investors and occupiers through more than 530 offices (excluding affiliates) worldwide. CBRE offers a broad range of integrated services, including facilities, transaction and project management; property management; investment management; appraisal and valuation; property leasing; strategic consulting; property sales; mortgage services and development services. Please visit our website at www.cbre.com .

We are in particular need of Building Maintenance Technicians and Maintenance Managers.  Folks that have current hands on experience with HVAC, refrigeration, plumbing, electrical, PLC’s, robotics, conveyor systems, carpentry, automation, controls and/or general maintenance.  And we need Managers that can direct these employees.  

We have job openings in many locations here in the US.  We offer a competitive salary and benefits including some matching 401K, vacation, etc.  All our jobs are full-time and permanent.  

Similar jobs