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 company's 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 company's 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 company's 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

Bachelor's 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"