The real estate market is undergoing a significant and exciting change - driven by data and technology. The skillful use of data and insights play a vital role in CBRE's mission to create unmatched value for our clients. CBRE is assembiling a new team of software and data engineers tasked with bringing to fruition a data integraton platform for the EMEA region. The team will be working on a leading-edge technology stack - focused on cloud and open source - and our aim is to bootstrap quickly, move fast and bring about data driven change to the organisation. This is a fantastic opportunity to join a business critical software team from it's inception and help to drive innovation and high-velocity delivery. Key Responsibilities ? Interpret and analyze data from various source systems to support data integration and data reporting needs within CBRE. ? Identify, analyze, and interpret trends or patterns in complex data sets ? Work with team leads to prioritize business and information needs ? Prepare high-level ETL mapping specifications. ? Develop complex code data scripts (Primarily SQL) for ETL ? Data Quality Control, Metrics ? Troubleshoot & determine best resolution for data issues and anomalies ? Manage exploratory data analysis to support database and dashboard development, as well as advanced analytics efforts ? May assist in development of software technical documentation ? Designs, specifies, implements, and maintains systems using Agile scrum methodology.
? Previous in-depth experience in a Data Engineer Role, working within a large corporate matrix environment ? Strong SQL skills - Adept at queries, report writing and presenting findings ? Expertise in Data Analysis, Data Profiling and Data Quality analysis using tools such as Ataccama, Trillium or Informatica IDQ. ? SQL Tuning ? Expertise in translating business requirements to project design, development, and execution ? Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy ? Ability to clearly communicate capabilities, opportunities, and recommendations to both technical and nontechnical audiences ? Experience working in Data warehouse ETL & BI platforms such as MS SSIS, Ab Initio or Informatica. Has good understanding of related development activities and challenges ? Strong knowledge of and experience with reporting, databases (SQL etc), programming ( ETL frameworks) ? Experience in understanding the source data from various platforms and mapping them into Entity relationship model(ER) for data integration and reporting. ? Has deep understanding of data architecture & data modeling best practices and guidelines for different data and analytic platforms. Experience with data modelling tools such as Erwin or Powerdesigner.
CBRE is the world's leading commercial real estate services firm with offices located around the globe. We have over 100,000 employees worldwide, with almost 2,500 of those in the UK alone. The company's core services include property sales, leasing and management, facilities and project management, investment management and, research and consulting. In Central London, CBRE advises on more commercial property than any other adviser and across the United Kingdom with offices in Aberdeen, Birmingham, Bristol, Edinburgh, Glasgow, Leeds, Liverpool, Manchester, and Southampton.