Under broad supervision, assists DSA Data Analytics Manager in the preparation of analyses on various data sets. Prepares reports and presentations for various audiences. Works independently with internal clients to determine their reporting needs. Manages databases, works with data owners to ensure data integrity, and performs trend analyses, creates visualizations and presents to stakeholders.. Role typically requires between 3 and 5 years of experience.
ESSENTIAL DUTIES AND RESPONSIBILITIES
Performs reoccurring and ad-hoc analysis of structured and unstructured data across multiple data sources, leveraging DSA and other business relevant data to perform workforce analysis and measurements.
Develops data structures and pipelines to organize, collect, cleanse, and standardize data in order to generate insights and addresses reporting needs.
Design, produce, and maintains various DSA dashboards and scorecards to provide key workforce measures utilizing a variety of tools (Excel, Alteryx, Tableau, etc.) in accordance with governance procedures. Monitors trends and highlights areas of concern for possible intervention.
Utilizes programming and analytical tools, including open source programs including Python, R and SAS, SQL, Oracle, or similar relational database tools to formulate models and/or extract insights. Well versed in knowledge of creating algorithms, identifying patterns and insights from structured and unstructured data sets utilizing graphs, trees and/or other data representation techniques as required.
Identifies and troubleshoots data integration and integrity issues. Documents global definitions, processes and practice to ensure consistent usage of data.
Identifies opportunities to maximize data usage, applying modeling and optimization methods to develop new strategies and improve business performance.
Exhibits analytical rigor, judgment, and ability to present a comprehensive 'data story' to multiple levels of the organization.
May coordinate involvement of personnel from other departments and information technology groups to facilitate successful project implementations.
Other Duties as Assigned
No formal supervisory responsibilities in this position. May provide informal assistance such as technical guidance, and/or training to coworkers. May coordinate and assign tasks to co-workers within a work unit and/or project.
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.
EDUCATION and EXPERIENCE
Bachelor's degree (BS or BA) and 3 years of experience in quantitative analysis, data modeling, reporting, relational database tools, data warehousing, database architecture, and SQL, SAS and/or SPSS including. Technical experience in statistical analysis, data engineering, data visualization and machine learning.
CERTIFICATES and/or LICENSES
Excellent written and verbal communication skills. Strong organizational and analytical skills. Ability to provide efficient, timely, reliable and courteous service to customers. Ability to effectively present information.
Requires knowledge of financial terms and principles. Ability to calculate intermediate figures such as percentages, discounts, and/or commissions. Conducts basic financial analysis.
Ability to comprehend, analyze, and interpret documents. Ability to solve problems involving several options in situations. Requires intermediate analytical and quantitative skills.
OTHER SKILLS and ABILITIES
Intermediate analytical skills. High attention to detail and accuracy is required to assure data products are reliable and actionable
Proficient in Microsoft Office Suite including Word, PowerPoint, Excel, and Outlook.
Knowledge and ability to work with confidential personal data, GDPR and apply data privacy controls
SCOPE OF RESPONSIBILITY
Decisions made with general understanding of procedures and company policies to achieve set results and deadlines. Errors in judgment may cause short-term impact to co-workers and supervisor.
Internal Number: 19040414
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.