Database Engineer

Job ID

187041

Posted

04-Oct-2024

Service line

Corporate Segment

Role type

Full-time

Areas of Interest

Digital & Technology/Information Technology

Location(s)

Hyderabad - Telangana - India

About CBRE:

CBRE Group, Inc. is the world’s largest commercial real estate services and investment firm, with a revenue of $26.106 Billion (as recorded on September 30, 2021) and more than 100,000 employees (excluding affiliate offices). CBRE has been on the Fortune 500 list each year since 2008, ranking #122 in 2021.

It has also been voted ‘Industry’s top brand’ by the Lipsey Company for 21 consecutive years, in addition to being one of Fortune’s “Most Admired Companies” for 12 years in a row, including being ranked number one in the real estate sector in 2020, for the second consecutive year.

CBRE’s Digital and Technology (D&T) organization is dedicated towards revolutionizing the real estate space with its software products. Our breakthrough products have brought real estate management to the fingertips for our clients.

Our small, fast-paced teams are responsible for creating innovative software that enhances the experiences of both our internal and external clients. As part of CBRE’s Digital & Tech organization, you’ll be able to learn from the most brilliant software engineers and designers while tackling tough problems, solution to which will drive our technology forward.

Job Role:

As a Database Engineer, you will be responsible for enabling and optimizing our data and data pipeline needs, as well as enabling data flow and collection for cross functional teams. The ideal candidate will be a key to manage our internal data (ETL/ELT data processing pipelines, data engineering, data analysis and visualization) and to ingest and connect it with crucial data sets. The Data Engineer will support our software developers, database architects, application reporting team and will ensure optimal data delivery 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 to support our next generation of products and data initiatives.

Job Title: Database Engineer

Job Location: Hyderabad / Gurugram / Noida

Key Responsibilities:

• Create and maintain optimal data pipeline.

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

• Build the data pipeline for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and cloud database technologies.

• Consult with product, engineering and business stakeholders to understand business problems and identify the best way to deliver a solution – educating stakeholders about options where required

• Prepare high-level ETL mapping specifications. Develop complex code data scripts (primarily SQL) for ETL

• Manage exploratory data analysis to support database and dashboard development.

• Unit test databases and perform bug fixes.

• Develop best practices for database design and development activities.

• Ability to quickly analyze existing 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.

• Actively participate in agile and design meetings to drive the technical outcomes

Key Requirements:

Experience: 5-8 years would be preferable.

Required Skills:

• Good knowledge in Database like PostgreSQL (preferably cloud hosted), with strong programming experience in SQL.

• Strong understanding of and practical working experience with Data warehouse (incl. Cloud based DW like Snowflake, Azure Synapse) and Data marts.

• Competence in data preparation and/or ETL tools like SnapLogic /StreamSets/DBT (preferably good exposure in one or more or similar ones) to build and maintain data pipelines and flows.

• Understanding of data modelling techniques and working knowledge with OLAP systems

• Good knowledge of databases, stored procedures, optimizations of huge data

• In-depth knowledge of ingestion techniques, data cleaning, de-dupe, partitioning.

• Experience with building the infrastructure required for data ingestion and analytics

• Ability to fine tune report generating queries

• 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

• Experience in understanding the source data from various platforms and mapping them into Entity Relationship Models (ER) for data integration and reporting (desirable).

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

• Exposure to Source control like GIT, Azure DevOps

• Understanding of Agile methodologies (Scrum, Kanban)

• Experience with NoSQL database to migrate data into other type of databases with real time replication (desirable).

• Experience with CI/CD automation tools (desirable)

• Programming language experience in Golang, Python, any programming language, Visualization tools (Power BI/Tableau) (desirable).

Personal Attributes:

• Very good communication skills.

• Ability to easily fit into a distributed development team.

• Ability to manage timelines of multiple initiatives.

• Ability to articulate insights from the data and help business teams make decisions

• Able to work with ambiguous requirements, to seek clarity around uncertainty and to manage risks

• Ability to communicate complex concepts to non-data audiences

Reference Links:

CBRE D&T LINKS -

?https://www.cbre.com/about/tech-vantage

?https://www.youtube.com/watch?v=Lj8P5q2RMWY

?https://www.forbes.com/sites/peterhigh/2019/08/12/cbres-digital-and-technology-chief-on-why-these-roles-should-be-combined/#4fdfefa15692

CBRE, Inc. is an Equal Opportunity and Affirmative Action Employer (Women/Minorities/Persons with Disabilities/US Veterans)