Junior Analytics Engineer

Location

Brookfield Place New York - 225 Liberty Street, 8th Floor

Business - Real Estate

Brookfield Real Estate Group is one of Brookfield’s primary operating groups. The Real Estate Group is one of the world's largest investors in real estate, with a global portfolio that includes office, retail, multifamily, logistics, hospitality and alternative real estate assets on five continents. The Group owns and operates approximately $268 billion of assets representing the most iconic properties in the world’s most dynamic markets. We seek to generate value by leveraging our operating expertise and focusing on our core real estate capabilities of leasing, financing, development, design and construction as well as property and facilities management. For more information, visit .

Brookfield Culture

Brookfield has a unique and dynamic culture. We seek team members who have a long-term focus and whose values align with our Attributes of a Brookfield Leader: Entrepreneurial, Collaborative and Disciplined. Brookfield is committed to the development of our people through challenging work assignments and exposure to diverse businesses.

Job Description

We are seeking a Junior Analytics Engineer to join Brookfield in New York, NY. In this role, you will play a key role in inspiring change and continual improvement. If you are committed to excellence and ready to contribute to a dynamic culture, we would love to meet you.

The Junior Analytics Engineer will sit within the Data Intelligence team and focus primarily on supporting Funds Portfolio Management (Funds PM). This role will develop and maintain trusted data models and analytics solutions that provide reliable, actionable insights to Funds PM stakeholders.

Funds PM supports Brookfield’s private real estate funds across investment valuations, fund management, fundraising, investor communications, and financial and operational reporting. Reporting follows recurring monthly and quarterly cadences.

The ideal candidate will have hands-on experience with SQL, dimensional data modeling, data transformation, and business intelligence tools. This individual will work closely with Funds PM and Finance stakeholders, Business Analysts, Data Engineers, and other team members to understand business needs and develop scalable data models, metrics, dashboards, and reporting solutions.

This is a junior-level position suited to someone who can independently complete defined development tasks while receiving guidance on more complex solutions. The role offers an opportunity to build deep knowledge of private real estate fund operations while taking meaningful ownership of high-visibility data and reporting products.

Role & Responsibilities:

• Develop and maintain data models, datasets, dashboards, and reports supporting Funds PM’s monthly and quarterly reporting cycles
• Transform raw data into reliable, well-structured, and reusable datasets for analytics and reporting
• Design and maintain analytical models using dimensional modeling principles
• Define appropriate fact tables, dimension tables, data grain, relationships, hierarchies, metrics, and business definitions
• Write and maintain SQL transformations to retrieve, integrate, validate, reconcile, and analyze data
• Develop analytics and reporting solutions using Sigma Computing and other business intelligence tools
• Partner with Data Engineers to understand source data, establish data pipelines, resolve upstream issues, and support end-to-end analytics solutions
• Collaborate with Business Analysts and stakeholders, including fund and portfolio leads, to translate business requirements into data models, metrics, and reporting products
• Validate data and troubleshoot discrepancies across data models, analytics products, and source systems
• Develop and execute unit and data-quality tests for SQL transformations, analytical models, metrics, dashboards, and reports
• Document data models, business logic, metrics, lineage, and reporting processes
• Support the deployment, monitoring, and ongoing maintenance of analytics solutions
• Participate in code reviews and incorporate feedback from senior team members
• Contribute to the development of analytics-engineering standards and reusable modeling practices

Your Qualifications:

• One to three years of relevant professional experience
• Strong working knowledge of SQL, including joins, aggregations, filtering, subqueries, window functions, and common table expressions
• Understanding of dimensional data modeling concepts, including fact tables, dimension tables, grain, star schemas, and relationships
• Experience transforming raw data into structured, reusable datasets for analytics and reporting
• Experience developing dashboards or reports using a modern business intelligence or data-visualization platform
• Experience collaborating with Data Engineers to understand source data, address data-quality issues, and support end-to-end analytics solutions
• Familiarity with data-testing and quality-assurance practices
• Familiarity with Git or another version-control platform
• Strong attention to detail and commitment to producing accurate, reliable work
• Strong written, verbal, and interpersonal communication skills
• Ability to explain technical concepts clearly to technical and non-technical stakeholders
• Ability to manage assigned tasks and collaborate effectively within a team
• Bachelor’s degree in computer science, information systems, data analytics, finance, or a related field, or equivalent practical experience

Preferred Qualifications

• Experience with or exposure to Sigma Computing
• Experience with or exposure to dbt or a similar data-transformation framework
• ·Exposure to Snowflake and AWS
• Exposure to Airflow, DataHub, or similar data-orchestration and metadata-management tools
• Experience developing automated data-quality tests and documenting data models and lineage
• Familiarity with software-development practices such as modular design, code reviews, testing, and deployment workflows
• Familiarity with financial-modeling concepts
• Experience working within an Agile delivery methodology
• Familiarity with master-data-management concepts
• Familiarity with finance, private equity, asset management, or real estate

Your Career @ Brookfield:

At Brookfield, your career progression is important to us. As a successful employee, you will have the opportunity to grow within your team, department, and across the Brookfield organization. Our leadership teams are dedicated to the accomplishments of their employees. We also invest time into training and developing our people.

End your job search and find your career today, at Brookfield.

Why Brookfield?

We imagine, create, and operate on a foundation of values to build a better world, together. Brookfield strives to create spaces where going to work never feels routine. As a Brookfield employee, you will enjoy many benefits such as 401K matching, tuition reimbursement, summer Fridays, paid maternity leave and more. There is also a generous employee referral program because we want our existing team members to help us build a more diverse workplace through their networks.

Compensation & Benefits:

Salary Type: Exempt

Pay Frequency: Bi-weekly

Annual Base Salary Range: $115,000-$130,000

Medical & Pharmacy Coverage: Yes, under Brookfield Medical Plan

Dental Coverage: Yes, under Brookfield Medical Plan

Vision Coverage: Yes, under Brookfield Medical Plan

Retirement: 401(k)

Insurance: Employer-paid life & short/long term disability

Our compensation structure is comprised of a base salary and a short-term incentive program (cash bonus). Cash compensation tends to vary based on geography to account for local market conditions and is set to be market competitive. Compensation decisions are based on a number of factors including relative experience, overall years of experience, industry experience, education and designations.

Brookfield is committed to maintaining a Positive Work Environment that is safe and respectful; our shared success depends on it. We do not tolerate workplace discrimination, violence or harassment. We are proud to be an Equal Opportunity Employer and make employment decisions based on qualifications, merit and business needs, without regard to any characteristic protected by applicable law. Applicant information is collected and handled in accordance with our Applicant Privacy Notice.