General Description: Sr. Database Developer/Analyst
On quarterly and monthly business cycles, manage the data import and processing for multiple commercial real-estate databases. Work directly with CBRE Economic Advisors' market forecasting teams to provide required inputs to forecasting processes and answer data-related inquiries. Under the supervision of the Team Lead, design new and upgrade existing databases and processes. Support forecasting specialists with technical and analytical insights, ad hoc reports and context for aggregate sets. Identify areas of inefficiencies in product process and assist in the automation or streamlining of existing workflows. Utilize geo-spatial software to maintain and enhance location-related data, provide mapping support for development projects and analysis of datasets and trends via mapping features.
Assume responsibility for the maintenance of multiple internal commercial real estate databases. This includes monthly and quarterly data import, data cleansing and normalization, aggregations and statistical calculations, and geospatial/location analysis. Design new and enhance existing databases and processes on an ongoing basis under the supervision of the team Lead.
Environments: MS SQL Server 2012/2016, MS Office Applications and Technologies, T-SQL,
ODBC Database Connectivity, Visual Studio, SSIS, SSRS, and Python 3.x.
Work directly with CBRE EA's forecasting team to provide specified input data to forecasting processes. Assist the forecasting team with data inquiries and forecasting processes. Provide occasional client support for detailed data-related questions. Provide additional insights and analysis that speaks to the veracity of the datasets.
Environments: MS SQL Server 2012/2016, Python 3.x, MS Office, Stata, R
Assist CBRE EA's product development/production and QC teams in the timely release of cyclical data products including: update of end-user databases in the CBRE-EA data warehouse, concise communications regarding data availability and status, fulfilling data inquiries from the production and QC teams, and responding to data structure/definition questions. Provide support to CBRE-EA's Strategy Services and Marketing departments with data inquiries and detailed custom data requests. Provide infrastructure for ongoing reporting in Power BI.
Environments: MS SQL Server 2012/2016, MS Office Applications and Technologies
Bachelor's degree (or higher) in Computer Science or related field or similar work experience. Technical Requirements: Structured Query Language (SQL) Database connectivity using ODBC or OLEDB Database design fundamentals (Visio / ER Design Studio) Microsoft Office proficiency (particularly Excel) Python 3.X Experience with R a Plus T-SQL Stored Procedures Experience with SSIS/SSRS/Power BI a plus Experience with SSAS a plus Experience with geo-spatial software a plus Familiarity with Visual Studio a plus
Strong mathematical ability Strong analytical skills coupled with an attention to detail Strong written and verbal communication skills Self-starter Ability to accept and adhere to CBRE database conventions and structures Ability to implement complex data processing methodologies Willingness to continue educational experience and growth in the workplace Ability to work in a team, taking direction from a Team Lead, essential.
Internal Number: 18029418
With broader and deeper capabilities than any other company, CBRE is the leading full-service real estate services and investment organization in the world.
CBRE Group, Inc. is the world’s largest commercial real estate services and investment firm, with 2017 revenues of $14.2 billion and more than 80,000 employees (excluding affiliate offices). CBRE has been included in the Fortune 500 since 2008, ranking #214 in 2017. It also has been voted the industry’s top brand by the Lipsey Company for 17 consecutive years, and has been named one of Fortune’s “Most Admired Companies” in the real estate sector for six years in a row. Its shares trade on the New York Stock Exchange under the symbol “CBRE.”
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.