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:

Company Overview

Fidelity Investments is a privately held company with a mission to strengthen the financial well-being of our clients. We help people invest and plan for their future. We assist companies and non-profit organizations in delivering benefits to their employees. And we provide institutions and independent advisors with investment and technology solutions to help invest their own clients' money.

Join Us

At Fidelity, you'll find endless opportunities to build a meaningful career that positively impacts peoples' lives, including yours. You can take advantage of flexible benefits that support you through every stage of your career, empowering you to thrive at work and at home. Honored with a Glassdoor Employees' Choice Award, we have been recognized by our employees as a top 10 Best Place to Work in 2024. And you don't need a finance background to succeed at Fidelity-we offer a range of opportunities for learning so you can build the career you've always imagined.

Fidelity's hybrid working model blends the best of both onsite and offsite work experiences. Having the majority of our associates work onsite is important for our business strategy and our culture. We also value the benefits that working offsite offers associates. Most roles listed as Hybrid will require associates to work onsite all business days of every other week in a Fidelity office. This does not apply to roles listed as Remote or Onsite.

At Fidelity, we value honesty, integrity, and the safety of our associates and customers within a heavily regulated industry. Certain roles may require candidates to go through a preliminary credit check during the screening process. Candidates who are presented with a Fidelity offer will need to go through a background investigation, detailed in this document, and may be asked to provide additional documentation as requested. This investigation includes but is not limited to a criminal, civil litigations and regulatory review, employment, education, and credit review (role dependent). These investigations will account for 7 years or more of history, depending on the role. Where permitted by federal or state law, Fidelity will also conduct a pre-employment drug screen, which will review for the following substances: Amphetamines, THC (marijuana), cocaine, opiates, phencyclidine.

We invite you to Find Your Fidelity at fidelitycareers.com.

Fidelity Investments is an equal opportunity employer. We believe that the most effective way to attract, develop and retain a diverse workforce is to build an enduring culture of inclusion and belonging.

Fidelity 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 HR Accommodation Team by sending an email to accommodations@fmr.com.