Analyst

Analyst | Business Intelligence

Chicago, IL (Hybrid)

The Analyst, Business Intelligence role offers a unique opportunity to drive strategic decision-making across Remedy's portfolio of medical outpatient buildings through data ownership, financial analysis, and business intelligence. You'll own critical data pipelines, support internal analytics platforms, and provide insights that directly inform asset management, leasing, and investment decisions. If you're analytically curious, detail-oriented, and motivated to build deep expertise in healthcare real estate analytics, we want to hear from you. This role combines data management, lease and financial analysis, and problem-solving to support the firm's ongoing operational and financial success. As part of a growing analytics team, you'll have significant autonomy and exposure to modern data tools and platforms.

Responsibilities:

• Data Ownership & Pipeline Management
• Reporting, Analysis & Platform Support
• Lease & Financial Analysis
• Process Improvement
• Own the accuracy and completeness of the firm's key data sources, including lease data, tenant information, market highlights, and occupancy metrics.
• Collect, validate, clean, and manage data from internal systems (including Yardi/DataFreedom), third-party platforms, and manual sources on a regular cadence while maintaining data integrity and database hygiene.
• Maintain and continuously improve databases and reference files used across the firm.
• Research and compile tenant, prospect, and market data to support Asset Management, Investments, Leasing, and other business functions.
• Support the development, maintenance, and enhancement of internal reporting tools and platforms used across the organization.
• Perform exploratory analysis to identify trends, anomalies, and meaningful patterns across leasing, tenant, operational, and market datasets.
• Write and modify SQL queries to retrieve, validate, and analyze data, ensuring accuracy and consistency across reporting outputs.
• Create data visualizations and dashboards to support decision-making across departments.
• Analyze lease structures, terms, and renewal timing to inform asset renewal strategy, renegotiation timing, and portfolio benchmarking.
• Research healthcare real estate market conditions, leasing benchmarks, and competitive positioning to inform asset management decisions; stay current on market trends and tenant credit.
• Analyze property and portfolio-level financial statements, including income statements, balance sheets, and cash flow statements, to identify opportunities and risks.
• Compile and organize data for property- and portfolio-level business plans and supplemental reporting materials.
• Support forecasting, budgeting, and reporting efforts to drive improved property-level outcomes and insights.
• Calculate and track key real estate metrics including occupancy, WALT (weighted average lease term), NOI, rent growth, delinquency, and mark-to-market IRR.
• Identify opportunities to automate, streamline, or improve existing data processes and reporting workflows.
• Document data sources, processes, and methodology to ensure the team's work is consistent, repeatable, and scalable.
• Contribute ideas and best practices that enhance team effectiveness and strengthen support across the organization.
• Prioritize across competing requests from multiple departments and manage recurring responsibilities independently.

This job description is intended to provide a general overview of the position and is not an exhaustive list of all duties, responsibilities, or qualifications. Responsibilities may be modified, expanded, or reassigned as business needs evolve.

The ideal candidate will possess the following qualifications:

• Bachelor's degree in a relevant field (e.g., finance, real estate, business analytics, computer science, economics, statistics, or similar).
• 13 years of experience in real estate, healthcare, data analytics, statistics, or a related field.
• Proficiency in Microsoft Excel and strong financial modeling skills are required.
• General SQL or database querying knowledge is strongly preferred.
• Experience with Yardi, Argus Enterprise, healthcare real estate platforms, or business intelligence tools is strongly preferred.
• Exceptional attention to detail and a genuine commitment to data accuracy.
• Strong organizational skills and the ability to manage recurring responsibilities independently and prioritize across competing requests.
• Familiarity with real estate concepts (occupancy, WALT, NOI, lease structures, tenant credit) is preferred.
• Excellent written and verbal communication skills, with the ability to present complex financial analysis to technical and non-technical audiences.
• Ability to work effectively in a team environment and collaborate with cross-functional departments.
• Comfort learning new tools and platforms, including cloud-based data environments and analytics applications.
• Internship or coursework experience in real estate, healthcare, or a data-intensive environment is preferred.
• Ability to work from Remedy's Chicago office on a hybrid schedule (24 days per week).

$60-80K salary range, based on experience plus benefits and bonus.

Now is a great time to join our growing team at Remedy! You will work side-by-side with firm leadership to serve clients and build the business, having a direct impact on the firm's success. We offer competitive health benefits: Medical, Dental, Vision, Life (including spouse & child), 401K, STD/LTD, Parental leave, AD&D, Tuition Reimbursement, and Commuter benefits. We offer flexibility in how and where you get your work done and meaningful relationships with clients, teammates and leadership who truly care about you and your development.

Remedy Medical Properties is committed to providing equal employment opportunities to all employees and applicants and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, marital status, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.