Senior Business Analyst (Remote) Overland Park, Kansas, United States 1 additional location Austin, Texas, United States Accounting/Finance Requisition # 20014127 Post Date Jun 17, 2020 JOB SUMMARY The purpose of this position is to provide complex research, data mining/analysis, reporting and interpretation of global, national, regional, local and/or account company performance metrics. ESSENTIAL DUTIES AND RESPONSIBILITIES Designs, generates, reviews and understands reports. Uses aggregate data from multiple sources to create a complete analysis, improvement and/or recommendation(s). Prepares and presents results of analysis and reports with their impact(s) to the business to all levels of management. Utilizes data visualization techniques to present a comprehensive 'data story'. Acts as project lead, including supervisory and/or managerial activities, in the coordination of the analyst team to successfully complete specified projects. Continues to build sustainable, scalable business intelligence (BI) foundation enabling fact-based, productive discussions. Develops scenario planning tools/models (exit/maintain/grow). Prepares forecasts and analyzes trends in general business conditions. Identifies opportunities for improvements by and among the clients and/or companies. Also, identifies opportunities to maximize data usage, applying modeling and optimization methods to develop new strategies and improve business performance. Defines data requirements. Gathers and validates information. Utilizes programming and analytical tools to formulate models and algorithms that identify patterns to extract insights. Reviews accuracy of information provided and responds to requests from management and vendors. Acts as a Subject Matter Expert (SME) for key systems/processes in subject teams and day-to-day functions. Designs workflows and procedures. Coordinates involvement of personnel from other departments and information technology groups to facilitate successful project implementations. Other duties may be assigned. SUPERVISORY RESPONSIBILITIES No formal supervisory responsibilities in this position. Provides informal assistance such as technical guidance and/or training to coworkers. May lead project teams plan and supervise assignments of lower level employees. 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. EDUCATION and EXPERIENCE Bachelor's degree (BA/BS) from 4-year college or university required. Master's degree preferred. Minimum of 5 years of related experience and/or training. CERTIFICATES and/or LICENSES Considered a plus for certification in: Â· Microsoft SQL Server-related tools (T-SQL, SSIS, SSAS, SSRS) Â· Azure-related services (SQL Databases, Data Factory, Machine Learning) Â· Tableau Â· Python COMMUNICATION SKILLS 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. FINANCIAL KNOWLEDGE Requires advanced knowledge of financial terms and principles. Ability to calculate intermediate figures such as percentages, discounts and commissions. Conducts advanced financial analysis. REASONING ABILITY Ability to comprehend, analyze, and interpret complex documents. Ability to solve problems involving several options in situations. Requires advanced analytical and quantitative skills. OTHER SKILLS and/or ABILITIES Advance experience in MS Office Products (Excel, Access, Power Point, Word, etc). Familiar with pivot tables. Ability to use query and report generation tools. Self-service/web based application experience desired. Intermediate experience with Tableau and SQL (preferably, T-SQL). Experience with ETL tool (such as SSIS) preferred. Considered a plus for: Â· Knowledge about Stored Procedures (in Microsoft SQL Server), SSAS and SSRS. Â· Understanding of data warehouse fundamentals, API and JSON. Â· Experience with Azure, Python, machine learning, forecasting, statistics, XML, Power Automate, Power Apps, spatial data, NoSQL and/or Windows Task Scheduler. Â· Familiarity with other Microsoft products or features that include Visio, SharePoint, Excel VBA, Excel/Access macros, Power Pivot and/or Power Query. Â· Bilingual - Spanish. SCOPE OF RESPONSIBILITY Decisions made with thorough understanding of procedures, company policies, and business practices to achieve general results and deadlines. Responsible for setting work unit and/or project deadlines. Errors in judgment may cause short-term impact to department. US Company Profile About CBRE Group, Inc. CBRE Group, Inc. (NYSE:CBRE), a Fortune 500 and S&P 500 company headquartered in Los Angeles, is the world's largest commercial real estate services and investment firm (based on 2019 revenue). The company has more than 100,000 employees (excluding affiliates) and serves real estate investors and occupiers through more than 530 offices (excluding affiliates) worldwide. 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. Please visit our website at ~~~.