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.
Specific Responsibilities: 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.
MS SQL Server 2016, MS Office Applications and Technologies, T-SQL, ODBC Database Connectivity, Visual Studio, SSIS and SSRS.
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.
MS SQL Server 2016 MS Office, WinRATs, Stata
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 SSRS/SSIS.
MS SQL Server 2016, MS Office Applications and Technologies
QUALIFICATIONS To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Bachelor's degree (or higher) in Computer Science or related field or similar work experience.
Structured Query Language (SQL)
Database connectivity using ODBC or OLEDB
Database design fundamentals (Visio / ER Design Studio)
Microsoft Office proficiency (particularly Excel)
T-SQL Stored Procedures
Experience with Python a plus
Experience with SSIS/SSRS 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
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
Typically, has 3 - 5 years of relevant work experience
Internal Number: 19016970
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.