Data Analyst

Job Description:

The Team­­­­

Pembroke is an international real estate advisor that acquires, develops and manages properties and places - specializing in mixed-use and office environments in the world's leading cities. We believe that properties that stand the test of time deserve a lot of time. So, we take a different approach: a thoughtful approach.

Facilitating patient capital of FMR LLC (Fidelity Investments) and FIL (Fidelity International Limited), we invest in global markets with long-term growth potential.

Over the past twenty years, we've grown to include offices in Boston, Hamburg, London, Munich, Stockholm, Sydney, Tokyo, and Washington DC, and manage approximately 762,000 sq m/8.2m sq ft in North America, Europe, and Asia Pacific. By combining a global point of view with local expertise, we're able to create and manage world-class properties that deliver the best outcomes for our tenants, investors and the communities in which we work. Our US portfolio is comprised of office buildings with retail at street level.

At Pembroke, we're united by a belief that real estate is more than just buildings. Our mission is to create long-term value through our global expertise, local knowledge and passion for real estate. Comprised of experts across a variety of fields, our team consistently strives for excellence, achieves with integrity and embraces collaboration. Working together, we create places people love.

For more information, visit our website: www.pembroke.com

The Role

We are seeking a Data Analyst to support Pembroke’s data and reporting needs. The successful candidate will have 2+ years of prior data analytics experience and exhibit strong analytical / organizational skills, as well as a robust understanding of databases and analytical tools including PowerBI. This role reports to Pembroke's Senior Director, Business and Technology Operations.

This individual will be responsible for the end-to-end data management process, including data integrity and accuracy, as well as the creation and maintenance of new and existing reports to support the needs of the business.

Responsibilities:

• Understand data definitions, structures, and business rules within source systems for data.

• Develop, implement, and execute data validation techniques and maintain Pembroke’s data warehouse.

• Develop and champion data management policies and best practices.

• Collaborate with other Pembroke departments (i.e. Sustainability; Finance) and 3rd party consultants to use Power BI to develop new reports as required by the business.

• Develop and lead in house training of other analysts/associates to increase Power BI knowledge and adoption.

• Present to functional, regional and team leaders to showcase new reporting opportunities.

The Expertise and Skills You Bring

• Bachelor's degree in a related field required; 2+ years of relevant experience, including business analysis, data analytics, and/or report development; real estate experience a plus.

• Proficient with data analysis and PowerBI for data visualization, with advanced proficiency in DAX & Power Query/M or equivalent languages.

• Proficient with SQL and database management and knowledge in developing custom Data Pipelines to extract data, map data, transform data, and to load data in various data stores.

• Enterprise-level experience in data presentation through dashboard/other visualization techniques.

• Capable of clearly communicating complex analyses to a non-technical audience.

• Demonstratable ability to produce results, meet deadlines, and manage complex and shifting priorities.

• Collaborative and team-oriented work style, and an entrepreneurial / motivated character.

• Experience in Hyperion/PBCS, Yardi, Argus Enterprise, VTS or other real estate applications is preferred.

Note: Fidelity is not providing immigration sponsorship for this position

Certifications:

Category:

Fidelity’s hybrid working model blends the best of both onsite and offsite work experiences. Working onsite is important for our business strategy and our culture. We also value the benefits that working offsite offers associates. Most hybrid roles require associates to work onsite every other week (all business days, M-F) in a Fidelity office.