Transaction Analyst

Job Title

Transaction Analyst

Job Description Summary

The Analyst is responsible for assisting in analytical report development and data warehouse development in support of the account team. This includes but is not limited to providing insights for management operations financials and client facing decision support.

The Analyst will support transactions generated by various sales teams including debt/equity financing for portfolios joint ventures loan sales and institutional-quality asset sales. Additionally the Financial Analyst will be responsible for the initial due diligence and financial analysis of sales transactions screening and evaluation of financial and operating statements and supporting the team Associate and/or Brokers in evaluating deal feasibility market strength and pricing/valuation structures.

Job Description

Key responsibilities:

Shape transform organize and objectively analyze data to support company strategy key performance indicators operational objectives and profitable outcomes

Leverage market-leading business intelligence (BI) technology to drive the automation and support of the companys data warehousing and BI strategy/operations

Assist the organization in making data-driven decisions and identifying new solutions that support its short and long-term goals for profitable growth responsible expense management and customer service excellence

As needed oversee and conduct training of staff on the use of the tools that are developed for data management and business insights

Leverage internal and external data to enhance reporting and insights

Collaborate with IT soft services hard services vendors Human resources MAC procurement finance and other departments to identify innovative solutions and information needs

Proactively support the company by assisting with information strategy building rapport with stakeholders and satisfying information and BI requests in a timely manner

Develop and maintain appropriate documentation metadata schemas and corporate communications for business intelligence tools and solutions built for production use by the company

Develop personal industry skills and knowledge to meet the companys culture and expectations of continuous learning and career enrichment

Maintain knowledge of current trends conditions competitive intelligence reporting and product and service innovations

Ability to interact collaboratively and collegially with colleagues agents and customers in a professional manner

Prepare financial models in Excel for clients which outline valuation and pricing structures

Prepare discounted cash flow analyses

Research analyze and evaluate market feasibility for various real estate transactions

Understand and review real estate documents (leases appraisals etc.) to determine if any issues/inconsistencies exist

Job Requirements:

At least 3-5 years of experience in business intelligence financial analysis analytics or data science areas

Competence in building databases datasets and performing queries in Microsoft Power BI Tableau or related technologies

Experience/competence with mainstream data shaping business intelligence statistical analysis and data visualization tools (preferably MS SQL Server SQL Microsoft Power BI Microsoft Excel Python R Tableau QGIS)

Open to learning a continuous array of new and evolving technology tools and skills

Ability to effectively absorb understand and communicate complex business concepts with data and analytics at the core

Ability to organize and lead meetings

Exceptional critical thinking and research skills

Experience and skill with cross-functional teams and working collaboratively with diverse internal and external stakeholders and vendors

Must be a self-starter and career learner that takes pride in maintaining knowledge of the facilities maintenance industry trends and current events and the complex interrelationships of the companys businesses to the marketplace and the competitive landscape

Exceptional organizational skills to prioritize multiple tasks with high attention to detail

A keen focus on on-time and on-budget delivery of work products

Proactive opportunity seeker who understands that opportunity often is self-created through hard work innovation and organizational value generation

Proven experience delivering reports dashboards and visualizations to business users.

Demonstrated ability to respond in a positive professional manner to multiple deadlines and shifting priorities.

Ability and desire to work in fast-paced environment

Ability to adapt well to change and see big picture

Bachelors degree preferred

Computer Skills and Knowledge of Hardware & Software Required:

Intermediate BI/reporting tool knowledge required (Power BI Famis 360 Tableau Crystal Reports etc.)

Beginner SQL (SQL Server Oracle) and relational database knowledge preferred.

Proficient in word processing spreadsheet database and report development applications.

Exposure to Data Modeling concepts.

Experience in the facility services industry is preferred.

Cushman & Wakefield is an Equal Opportunity employer to all protected groups including protected veterans and individuals with disabilities. Discrimination of any type will not be tolerated.

In compliance with the Americans with Disabilities Act Amendments Act (ADAAA) if you have a disability and would like to request an accommodation in order to apply for a position at Cushman & Wakefield please call the ADA line at 1- or email. Please refer to the job title and job location when you contact us.

INCO: Cushman & Wakefield