Lead Data Engineer

About the Role:

As a Sr Lead Database Engineer, you will be responsible for designing, expanding and optimizing our enterprise scaled intelligent data platforms and data products having complex data pipelines. The ideal candidate is an experienced data engineer and data wrangler who enjoys optimizing data systems and building them from the ground up. The Sr Lead Database Engineer must be self-directed and comfortable supporting the data needs of multiple tean1s, 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.

What You’ll Do:

• Manage day-to-day operations and support of enterprise databases.
• Set up and configure complex databases, interfaces, and production environments.
• Work with application developers to create innovative programs and systems.
• Oversee production application systems, the information warehouse, and business intelligence systems.
• Direct installation and configuration, performance tuning, backup and recovery, partitioning strategies, and automation techniques.
• Manage user security and access to the databases to ensure a controlled environment.
• Investigate, review, and test patches and bug fixes.
• Coach others to develop in-depth knowledge and expertise in most or all areas within the function.
• Apply advanced knowledge to seek and develop new, better methods for accomplishing both individual and department objectives.
• Showcase expertise in own job discipline and in-depth knowledge of other job disciplines within the organization function.
• Coach others to develop in-depth knowledge and expertise in most or all areas within the function.
• Lead by example and model behaviors that are consistent with CBRE RISE values. Anticipate potential objections and persuade others, often at senior levels and of divergent interest, to adopt a different point of view.
• Impact the achievement of customer, operational, project, or service objectives across multi-discipline teams. Work is guided by functional policies which impact the design of procedures and policies.
• Contribute to new products, processes, standards, and/or operational plans in support of achieving functional goals.
• Communicate difficult and complex ideas with the ability to influence.

What You’ll Need:

• Strong Experience in SQL with experience in relational database(PostgreSQL preferrable cloud hosted in AWS/Azure/ GCP) or any cloud based Data Warehouse(like Snowflake)
• Competence in data preparation and ETL tools like snap logic, IBM Stream sets, DBT etc.
• Understanding of data modelling techniques and working knowledge with OLAP systems.
• Experience with CI/CD automation tools.
• Exposure to source control like GIT, Azure Devops.
• Deep knowledge of databases, datamarts, data warehouse enterprise systems and handling of large datasets.