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-888-365-5406 or email HRServices@cushwake.com. Please refer to the job title and job location when you contact us.

INCO: “Cushman & Wakefield”