Senior Data Analyst

Brookfield Properties; Cleveland (OH); Híbrido; USD 88 000 - 123 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Full benefits package

Generous paid time off

401(k) with company match

Growth and advancement opportunities

Lucrative referral bonus program

Resumo da oferta

Brookfield Properties is seeking a Senior Analyst to support analytics for the U.S. Housing platform, with a primary focus on Multi-Family. You will develop SQL queries, data models, and Power BI reports to drive decisions and growth across portfolios.

You will collaborate with business partners, Product, Technology, and Engineering, delivering insights and exploring AI-assisted approaches to speed information delivery while maintaining data quality and governance.

Qualificações

• Undergraduate degree in a quantitative field or related experience.
• Strong dashboard development experience with Power BI and data modeling.
• Experience with SQL, Redshift, and data quality practices.

Responsabilidades

• Data Extraction, Integration & Quality Assurance. Write, test, and optimize SQL queries to extract, transform, and analyze data from Redshift, Yardi, and other source systems.
• Dashboard & Reporting Development. Build, maintain, and enhance Power BI dashboards and reports with clear definitions.
• Business Partnership & Analytical Consulting. Translate business questions into analytical solutions and communicate findings clearly.
• Cross-Functional Collaboration & Innovation. Partner with Product, Technology, and Engineering to deliver scalable data solutions and explore AI-assisted workflows.

Conhecimentos

SQL

Power BI

Data modeling

Python

Redshift

DAX

Analytical thinking

Communication

Formação académica

Undergraduate degree in Data Science / Statistics / Economics / Finance / CS

Ferramentas

Amazon Redshift

Git

Excel

Descrição da oferta de emprego

Business

We know that a "one-size-fits-all" approach doesn't work when it comes to residential living. That's why our portfolio features a wide range of options for any stage of life. And though our properties may be diverse, one thing is universal: all offer the unparalleled quality, service, and support our residents deserve.

Location

Key Tower - 127 Public Square

Job Description

Position Summary

The Senior Analyst will support the analytics function for the U.S. Housing platform, with a primary focus on Multi-Family. This role will work closely with business partners, Product, Technology, and Engineering to deliver analyses, reporting, and insights that drive measurable business impact. This individual will develop SQL queries and data models to answer business questions, and build and maintain reports and dashboards, primarily in Power BI, that make data easier to understand and use in decision-making. While the role primarily supports Multi-Family, this individual will also have opportunities to work on broader U.S. Housing initiatives, helping connect data, tools, and ways of working across both businesses. They will also help explore and adopt AI-assisted approaches to delivering information to the business, making insights faster to produce and easier to consume. This is a hands-on, individual-contributor role. The ideal candidate is comfortable rolling up their sleeves to work directly with data and analytical problems, is eager to learn, and can manage multiple priorities. The role requires strong analytical skills, attention to detail, growing business judgment, and solid communication and relationship-building skills.

Essential Job Functions

• Data Extraction, Integration & Quality Assurance. Write, test, and optimize SQL queries to extract, transform, and analyze data from Redshift, Yardi, and other source systems. Validate and reconcile data across platforms, and support data quality through QA practices-testing and validating data and reports for accuracy across Single-Family and Multi-Family portfolios.
• Dashboard & Reporting Development. Build, maintain, and enhance Power BI dashboards and reports, applying consistent standards for visualization and KPIs. Promote self-service analytics by building intuitive dashboards and maintaining clear documentation of data sources, report logic, and definitions.
• Business Partnership & Analytical Consulting. Partner with business stakeholders to translate business questions into analytical solutions. Perform ad hoc analyses and clearly communicate findings, insights, and recommendations to stakeholders, using SQL, Power BI, and Python/Redshift as needed to solve analytical problems.
• Cross-Functional Collaboration & Innovation. Partner with Product, Technology, and Engineering to deliver scalable, reliable data and reporting solutions. Explore and help adopt AI-assisted tools and workflows to deliver information to the business more quickly and effectively, driving continuous improvement of the analytics function.

Education

This position requires a(n) Undergraduate (Bachelor) Degree in Data Science, Statistics, Economics, Finance, Computer Science, Engineering, or a related field (or equivalent experience).

Work Experience

• Strong experience building, maintaining and enhancing dashboards in Power BI including data modeling and DAX.
• Strong SQL skills, including writing and optimizing queries; experience with Amazon Redshift or a similar cloud data platform is a plus.
• MS Office products to include Power BI visualizations and excel modeling.
• Familiarity with Git, Agile development methodologies, and collaborative software development practices.
• Knowledge of or experience in the Multi-Family real estate industry; exposure to Single-Family, asset management, or financial services is a plus.
• Note: 5-7 Years of experience can offset minimum educational requirements for this position

Compensation

Commensurate with Experience

$87,900 - 122,955 annually

Great Incentives!

Benefits

• Full benefits package
• Generous paid time off
• 401(k) with company match
• Growth and advancement opportunities
• Lucrative referral bonus program

Hybrid Work Model

The Cleveland corporate office follows a hybrid work model that requires employees to be in the corporate office at least four days per week to foster collaboration, innovation, and team celebration.

Equal Opportunity Employer

Equal Opportunity Employer: Minorities/Religion/Sex/Protected Veterans/Disability/Sexual Orientation/Gender Identity/Marital Status/Pregnancy/Age/National Origin/Genetic Information. Drug free workplace

We are proud to create a diverse environment and are proud to be an equal opportunity employer.