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 Real Estate Data Analyst to support Pembroke’s data and reporting needs. The successful candidate will have 1 to 3 years of prior data management experience and exhibit strong analytical / organizational skills, as well as a robust understanding of databases and analytical reporting tools such as Power BI. 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 Pembroke departments (i.e. Sustainability; Finance) and 3rd party consultants to leverage Power BI to develop new reports and maintain existing 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 and 1 to 3 years of relevant experience, including database design and management, data analytics, business analysis, and/or report development required.
Proficient with SQL and database management, including knowledge in developing custom data pipelines to extract, map, transform, and load data in various data stores required.
Experience with data analysis and visualization tools such as Power BI (or alternatives, e.g Tableau), with advanced proficiency in DAX & Power Query/M or equivalent languages required.
Real estate experience, including experience with real estate applications is preferred.
Ability to translate business requirements into visual solutions.
Proven ability to produce results, meet deadlines, and manage complex and shifting priorities.
Collaborative and team-oriented work style, and an entrepreneurial / motivated character.
Note: Fidelity is not providing immigration sponsorship for this position
At Pembroke, we believe the most effective way to attract, develop and retain a diverse workforce is to build an enduring culture of inclusion and belonging.
Pembroke will reasonably accommodate applicants with disabilities who need adjustments to participate in the application or interview process. To initiate a request for an accommodation, contact the Pembroke Human Resources team by sending an email to PembrokeHR@fmr.com
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.
Certifications: