About the opportunity : CBRE is on a transformational journey in digital, data and technology. With the growth in our data driven ambition, it is critical that we have world-class data products, visualisations and insights.
This role partners with our UK business and technology teams to deliver best in class reusable data to support our data visualisations and insights.
CBRE have unbeatable data, and this role will ensure that data is front and centre of the UK business, and is embedded in all our client's decision-making processes.
The successful candidate will be a key delivery person helping us to manage our internal data (ETL / ELT data processing pipelines, data engineering, data analysis and visualisation) and to ingest and connect it with key UK public data sets.
The team will be working on a leading-edge technology stack focused on cloud and open source Go, Python, scripts (bash, grep, sed, awk, Terraform), Git / Github, Jira / Confluence, PostgreSQL (plpgSQL), AWS / Azure (CI / CD), PostGIS, pgRouting).
The role will form part of a new data team based in our Chief Data Office team in India working together with data analysts and engineers to deliver data products to support CBRE UK’s Data Strategy.
About you : The ideal candidate will understand the value of data and the importance of data quality. As a member of our team your communication and analytical skills are essential.
You must be passionate about data and be able to articulate how it can be used to transform how we live and work. Key responsibilities : As part of our team, you'll become an expert in our data and will enable us to address key client questions that help CBRE to differentiate through data.
Key activities in this role will include :
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
Assist in preparation of requirement specifications
Actively participate in agile and design meetings to drive the technical outcomes
Prepare high-level ETL mapping specifications
Develop complex code data scripts (primarily SQL) for ETL
Code, test, and document software programs as per the requirement specifications
Troubleshoot & determine best resolution for data issues and anomalies
Manage exploratory data analysis to support database and dashboard development
Assist in development of software technical documentation and creation of a data dictionary
Collaborate and support other team members to drive a one team culture where everyone can grow together and perform to the best of their abilities
Required knowledge and skills : Experience
A bachelor's degree in Science, Technology, Engineering, Mathematics, or a relevant other subject
8 years of experience in extracting and analysing data from various formats and sources
Demonstratable proven track record delivering data products
Demonstrated ability to quickly learn new tools, systems and processes
Strong programming language experience in Golang, Python, shells scripts (bash / zsh, grep / sed / awk etc..), SQL
Experience with automated testing and coverage tools
Experience with back-end service, REST API's and Microservice architecture
Experience with Cloud IaaS and PaaS platforms
Strong analytical skills
Attention to details with a strong focus on data accuracy, quality, validation and integrity
Deep knowledge of databases, stored procedures, optimizations of huge data
In-depth knowledge of ingestion techniques, data cleaning, de-dupe, partionning
Experience with building the infrastructure required for data ingestion and analytics
Ability to fine tune report generating queries
Ability to articulate insights from the data and help business teams make decisions
Strong knowledge of, and experience with, reporting, databases, writing medium complexity SQL statements, programming (ETL frameworks)
Experience in understanding the source data from various platforms and mapping them into Entity Relationship Models (ER) for data integration and reporting
Understanding of data modelling techniques and working knowledge with OLTP and OLAP systems
Communication and presentation
Fluent English in speaking and writing is a must
Ability to communicate with stakeholders to gain requirements and gather information
Able to work with ambiguous requirements, to seek clarity around uncertainty and to manage risks
Ability to communicate complex concepts to non-data audiences
Always follows up and presses for a timely and complete response from stakeholders
Confident and self-motivated with ability to escalate where required
Fast learner who is self-motivated to explore existing data model and make connections
Intellectually curious and critical thinker with a focus on outcomes
Logical problem solver who seeks simple, creative solutions to problems
Comfortable breaking down tasks into manageable deliverables, estimating work effort, identifying potential issues and managing multiple concurrent deliverables
Shows initiative, flexibility and a collaborative team player
Focused on getting things done
Aptitude to follow process