CBRE Business Systems Analyst in Redmond, Washington
Under general supervision, formulates and defines systems scope and objectives through research and fact-finding combined with an understanding of applicable business systems and industry requirements. With this knowledge, develops or modifies moderately complex information systems. Includes analysis of business and user needs, documenting requirements, and revising existing system logic difficulties as necessary. Competent to work in some phases of systems analysis and considers the business implications of the application of technology to the current business environment. Generally, uses existing procedures to resolve standard problems.
ESSENTIAL DUTIES AND RESPONSIBILITIES
Provides end user support for a specific application while learning about the application and customer. Assists in application implementations and assists in testing end user processes using defined guidelines. Updates existing application tables and verifies the accuracy. Collects data and runs reports in response to client inquiries as directed by more senior associates. Interacts with clients, both internal and external, to supply information. Analyzes business and user needs, documenting requirements, with the guidance of a senior associate. Documents business rules/functional requirements to support system enhancements with the guidance of a senior associate.Logs and tracks problems/work tickets with external product vendors or support organizations.Performs other duties as assigned.
SCOPE OF RESPONSIBILITY
Responsible for the management of 3rd party lease application used to manage data for Microsoft’s global real estate portfolio of leased, subleased, sublet and/or owned properties.
This position will manage Microsoft’s data of contractual and financial responsibilities, act as the interface for remote and on on-site team members to ensure quality of data relating to the dates and dollars of leased sites. Also will coordinate with Microsoft business and IT team on data warehousing and reporting.
Data and Records Management:
Work with the team to manage the lease administration process and the corporate real estate database.
Use the lease database to access information for both Leased and Owned sites and write Management reports as necessary.
Perform research, analysis, and resolution of issues utilizing the Lease Admin application.
Review audit reports and resolve errors to ensure integrity of information. Identify problems with database management policies and procedures, provide input for revisions.
Provide direction or assistance to field personnel regarding data requirements and status of documentation. Ensure all policies and procedures are up-to-date and provide input for ideas and suggestions to improve workflow processes.
May train other users of the Lease Admin application.
Generate, review and understand reports. Use aggregate data from multiple sources to assist in creating a complete analysis, improvement and/or recommendation. Review the accuracy of information provided and respond to requests from management and partners.
May act as a Subject Matter Expert (SME) for key systems/processes in subject teams and day-to-day functions and ongoing projects.
Provide documentation and other reports as necessary in an accurate, concise and timely manner.
Develop and/or manage both high level and detailed financial reports and statements for use by Management or as necessary to measure and manage the property management and lease administration functions in a timely and accurate manner.
Support monthly creation of financial statements, including verification of Rent Rolls and submission of templates to Microsoft A/P.
Knowledge and Skills Required:
Ability to assume a Global Super User role, supporting global lease administrators with tool, data and report support
Ability to enter data into a database
Proficient in Excel (querying, pivot tables, formatting) and PowerBI
Experience in database reporting – Access, BOBJ, Crystal reports, SQL, etc.
Knowledge of Data-mapping between systems. Managing a real estate system such as SLIM, LA8, Lucernex, CoStar, etc. a plus
No formal supervisory responsibilities in this position. May provide informal assistance such as functional guidance, and/or training to coworkers. May coordinate and assign tasks to co-workers within a work unit and/or project.
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 in business or related field and 0-3 years of 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.
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.
Equal Opportunity and Affirmative Action Employer Women/Minorities/Persons with Disabilities/US Veterans
- CBRE Jobs