Responsible for the overall support of CBRE client's real estate outsourcing contract. Conducts and documents complex financial and operational analyses and ad hoc projects, including review and investigation of financial data and results, as well as key operational metrics. Establish and maintain excellent relationships with internal and external clients working within a matrix reporting environment: Dedicated Account Team, Regional Finance, Corporate and Client Accounting, and the Client on all aspects of accounting, finance and reporting. Involved in other special projects as necessary.
ESSENTIAL DUTIES AND RESPONSIBILITIES
Supports Finance Director and regional, operational field teams in a variety of areas of financial analysis.
Experience with working with and manipulating large data sets - ability to scrub, synthesize and summarize into decision making outputs. Ability to decipher complex situations and generated key takeaways and conclusions for presentation to others.
Knowledge of financial terms and principles. Compile, decipher, analyze, and interpret financial information and the ability to accurately explain/report activity in verbal and written communications.
Review, perform, and coordinate financial analysis across different departments, regions or business segments including monthly management reporting, variance analyses, account reconciliations, strategic planning, budgeting and forecasting.
Constant drive towards process improvements and gains in efficiency by brainstorming new, automated ways of accomplishing tasks (excel, web-based, etc).
A thirst to understand processes and data and what they mean, rather than just following a checklist of steps and delivering the output for someone else to review
Assist with CBRE invoicing allocations associated with the portfolio book of record and completing AP upload templates.
Weekly Pre-funding Request Review; Commodity Code/Op Code Changes, and responding to client questions
Vendor management including invoice reconciliations
PO creation and PO management
No formal supervisory responsibilities in this position. May coordinate and assign tasks to co-workers within a work unit and/or project. As a "go-to resource," duties may encompass technical guidance and/or training to co-workers, as well as policy development and participation in special initiatives (modeling, system implementations, acquisition integrations, other).
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 a four-year college or university in a business related field plus a minimum of four years related experience.
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 in written and verbal form to subordinates, customers and supervisors. FINANCIAL KNOWLEDGE
Requires strong knowledge of financial terms, concepts and accounting principles and the ability to comprehend and interpret complex financial transactions.
Ability to comprehend, analyze, and interpret complex financial information and transactions and accounting principles. Ability to problem-solve, both independently and working as a team. Requires strong analytical and quantitative skills.
Prefer strong analytical and quantitative skills that go beyond just working with numbers - ability to know how to problem solve, give data output a sanity check and search for errors, suggest solutions and how to show / communicate the data to less detailed audiences.
OTHER SKILLS and/or ABILITIES
Strong computer skills, including specific knowledge of Microsoft Office Suite (Excel, Word, Outlook, PowerPoint, etc.). Broad experience with other software and financial systems is desired such as HFM Consolidation, PeopleSoft Financials and Cognos Planning. Knowledge of real estate service industry and terminology is helpful. Strong work ethic and adaptable.
Advanced experience in Excel preferred: Ability to calculate results using pivots, formulas: (sumifs, lookups, etc) filtering, sorting, named ranges, graphing, formatting preferred.
Experience with JDE, Tradeshift, PeopleSoft Financials, or Cognos preferred. Access a plus.
Prefer detailed orientation - accuracy, quality and meeting deadlines.. Ability to manage multiple priorities with high flexibility and rapid response time
Prefer proactive and high energy candidates
Prefer strong work ethic and adaptable
Ability to be flexible and meet client and corporate deadlines preferred
Prefer ability to provide efficient, timely, reliable, and courteous service to customers. Ability to understand the audience and customize approach to maximize and simplify understanding. Ability to effectively present information to supervisors, management and client.
Design, generate, review, and understand reports preferred. Create presentations and other client facing materials. Presentation elements may also include maps, charts, tables, illustrations, and other features using Word, Powerpoint, Excel, or other software.
Knowledge of real estate service industry and terminology is helpful. Strong work ethic and adaptable, with future goals of becoming a financing manager/director preferred.
SCOPE OF RESPONSIBILITY
Decisions made with understanding of procedures and company policies to achieve set results and deadlines. Responsible for setting own project deadlines. Errors in judgment may cause short-term impact to co-workers and supervisor.
Internal Number: 20021945
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.