Manager, Reporting & Analytics at Ventas, Inc. in Chicago, IL | USD120,000-180,000 | Kablio

Role

Description

bi monitoring

etl

dashboard design

data modeling

stakeholder interaction

governance

Continuously monitor and improve BI solutions for performance, usability, and reliability
Mentor and manage reporting portfolio and workload for other BI developers
Create and maintain comprehensive documentation for BI reports, data models, and processes
Extract, Transform, and Load (ETL) data from various sources into reporting models. This includes working with databases, multi-dimensional models, spreadsheets, and other data storage solutions.
Lead the reporting & analytics team to design, create, and maintain interactive, user-friendly dashboards and reports to provide actionable insights
Interact with business stakeholders, data analysts, and other IT team members to understand requirements and deliver solutions that meet business needs
Design and manage data models, including relationships, hierarchies, and measures to ensure data integrity and optimal performance
Foster a culture of innovation and continuous improvement by staying current with BI tools and best practices
Execute on a business intelligence strategy aligned with Ventas’s strategic goals. Advocate for the effective use of BI tools in decision-making and promote adoption across departments.
Analyze complex datasets to identify trends, patterns, and insights that can support decision-making processes
Coach functional power users to be able to derive the full value of reporting solutions
Define governance approaches and act as a business and/or technical expert to attain objectives, including gateway setups, capacity & license planning, optimization, etc.

Requirements

powerbi

t-sql

mdx

bachelor’s

8-10 yrs

detail oriented

Experience with T-SQL, MDX, and relational databases
Willingness to adapt and thrive in a blended work environment with 3-days in office, seamlessly transitioning between remote work and in-office operations.
Proficiency in PowerBI, including DAX and Power Query
3-5 years of experience in leading reporting and analytics teams
8-10 years of experience in developing reporting solutions and dashboards
High attention to detail and commitment to data accuracy and quality
Strong understanding of data modeling using tabular and multi-dimensional models, ETL processes, and data warehousing concepts
Must be located in Chicago, IL surrounding area or willing to relocate for the duration of employment.
Strong verbal and written communication skills with the ability to convey complex information to non-technical stakeholders
Ability to work collaboratively in a team environment and simultaneously manage multiple tasks and projects
Bachelor’s degree in Computer Science, Information Technology, Data Science, related field or equivalent degree with experience
Excellent analytical and problem-solving skills with the ability to interpret complex data sets
Must be legally authorized to work in the United States without need for employer sponsorship now or in the future
Knowledge of AnaplanXL and other BI tools and/or platforms is a plus

Benefits

Information not given or found

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

no employer sponsorship required; must be authorized to work in the united states.

Security clearance

Information not given or found

Company

Overview

$44B portfolio

Real estate holdings

The company has assembled a large portfolio across North America and the UK.

86,000 seniors

Seniors supported

Provides housing for seniors in expertly operated communities.

40 million visits

Annual patient visits

Facilitates millions of patient visits annually at outpatient medical and research campuses.

19% returns

Annualized returns

Delivers strong returns for shareholders since 2000.

Over 25 years, it assembled a portfolio across North America and the UK, including ~1,400 properties across four key asset types.
Its outpatient medical and research campuses span ~22 million sq ft.
In its triple‑net healthcare holdings, it provides roughly 10,000 beds and 2.4 million patient days each year.
Through its institutional private capital platform, it manages $5 billion in third‑party assets.

Culture + Values

90% Coverage

Health Benefits

Employees receive premium health coverage with 90% of the plan's cost covered by the company.

20 Days PTO

Paid Time Off

Employees are entitled to a minimum of 20 days of paid time off annually for rest and personal well-being.

4% Match

Retirement Savings

The company matches 4% of employees' contributions to their 401(k) plan, fostering financial preparedness.

Collaboration
Respect
Commitment to excellence
Hybrid work schedule (2 days remote, 3 days in-office)

Environment + Sustainability

100% Renewable by 2035

Energy Commitment

Aims to source all electricity from renewable or zero-carbon sources by 2035, reflecting a strong commitment to clean energy.

60% Renewable by 2030

Energy Procurement

Already procures 60% of its energy from renewable sources, demonstrating significant progress toward sustainability goals.

$60M Investment

Energy Efficiency

Invested $60 million in upgrades since 2018, achieving a 15% return on investment, showcasing financial and environmental benefits.

>95% Natural Gas Reduced

Carbon Emissions

Plans to reduce natural gas consumption by over 95% by 2040, marking a dramatic shift toward low-carbon operations.

Net‑zero operational carbon emissions target by 2040
Annual same‑store energy intensity reduction >5% (2018–2020)
Property‑specific net‑zero roadmaps for ~800 properties using machine learning and physics‑based modeling
219 + certified green buildings
Awards: CDP A‑List; ENERGY STAR Partner of the Year; #1 Healthcare REIT in GRESB since 2017; Nareit Leader in the Light

Inclusion & Diversity

36% Women

Board Composition

Women account for 36% of the board of directors.

45% Diverse

Board Diversity Metrics

The board is 45% diverse by gender or ethnicity.

Established DEI committee; unconscious‑bias training for interviewers
Enhanced applicant‑tracking system providing candidate diversity metrics
Strengthened relationships with HBCUs to diversify recruitment
Listed on Bloomberg Gender Equality Index for multiple consecutive years

Articles

Investor Relations

Careers

Company Overview

Role

Description

bi monitoring

etl

dashboard design

data modeling

stakeholder interaction

governance

Continuously monitor and improve BI solutions for performance, usability, and reliability
Mentor and manage reporting portfolio and workload for other BI developers
Create and maintain comprehensive documentation for BI reports, data models, and processes
Extract, Transform, and Load (ETL) data from various sources into reporting models. This includes working with databases, multi-dimensional models, spreadsheets, and other data storage solutions.
Lead the reporting & analytics team to design, create, and maintain interactive, user-friendly dashboards and reports to provide actionable insights
Interact with business stakeholders, data analysts, and other IT team members to understand requirements and deliver solutions that meet business needs
Design and manage data models, including relationships, hierarchies, and measures to ensure data integrity and optimal performance
Foster a culture of innovation and continuous improvement by staying current with BI tools and best practices
Execute on a business intelligence strategy aligned with Ventas’s strategic goals. Advocate for the effective use of BI tools in decision-making and promote adoption across departments.
Analyze complex datasets to identify trends, patterns, and insights that can support decision-making processes
Coach functional power users to be able to derive the full value of reporting solutions
Define governance approaches and act as a business and/or technical expert to attain objectives, including gateway setups, capacity & license planning, optimization, etc.

Requirements

powerbi

t-sql

mdx

bachelor’s

8-10 yrs

detail oriented

Experience with T-SQL, MDX, and relational databases
Willingness to adapt and thrive in a blended work environment with 3-days in office, seamlessly transitioning between remote work and in-office operations.
Proficiency in PowerBI, including DAX and Power Query
3-5 years of experience in leading reporting and analytics teams
8-10 years of experience in developing reporting solutions and dashboards
High attention to detail and commitment to data accuracy and quality
Strong understanding of data modeling using tabular and multi-dimensional models, ETL processes, and data warehousing concepts
Must be located in Chicago, IL surrounding area or willing to relocate for the duration of employment.
Strong verbal and written communication skills with the ability to convey complex information to non-technical stakeholders
Ability to work collaboratively in a team environment and simultaneously manage multiple tasks and projects
Bachelor’s degree in Computer Science, Information Technology, Data Science, related field or equivalent degree with experience
Excellent analytical and problem-solving skills with the ability to interpret complex data sets
Must be legally authorized to work in the United States without need for employer sponsorship now or in the future
Knowledge of AnaplanXL and other BI tools and/or platforms is a plus

Benefits

Information not given or found

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

no employer sponsorship required; must be authorized to work in the united states.

Security clearance

Information not given or found

Company

Overview

$44B portfolio

Real estate holdings

The company has assembled a large portfolio across North America and the UK.

86,000 seniors

Seniors supported

Provides housing for seniors in expertly operated communities.

40 million visits

Annual patient visits

Facilitates millions of patient visits annually at outpatient medical and research campuses.

19% returns

Annualized returns

Delivers strong returns for shareholders since 2000.

Over 25 years, it assembled a portfolio across North America and the UK, including ~1,400 properties across four key asset types.
Its outpatient medical and research campuses span ~22 million sq ft.
In its triple‑net healthcare holdings, it provides roughly 10,000 beds and 2.4 million patient days each year.
Through its institutional private capital platform, it manages $5 billion in third‑party assets.

Culture + Values

90% Coverage

Health Benefits

Employees receive premium health coverage with 90% of the plan's cost covered by the company.

20 Days PTO

Paid Time Off

Employees are entitled to a minimum of 20 days of paid time off annually for rest and personal well-being.

4% Match

Retirement Savings

The company matches 4% of employees' contributions to their 401(k) plan, fostering financial preparedness.

Collaboration
Respect
Commitment to excellence
Hybrid work schedule (2 days remote, 3 days in-office)

Environment + Sustainability

100% Renewable by 2035

Energy Commitment

Aims to source all electricity from renewable or zero-carbon sources by 2035, reflecting a strong commitment to clean energy.

60% Renewable by 2030

Energy Procurement

Already procures 60% of its energy from renewable sources, demonstrating significant progress toward sustainability goals.

$60M Investment

Energy Efficiency

Invested $60 million in upgrades since 2018, achieving a 15% return on investment, showcasing financial and environmental benefits.

>95% Natural Gas Reduced

Carbon Emissions

Plans to reduce natural gas consumption by over 95% by 2040, marking a dramatic shift toward low-carbon operations.

Net‑zero operational carbon emissions target by 2040
Annual same‑store energy intensity reduction >5% (2018–2020)
Property‑specific net‑zero roadmaps for ~800 properties using machine learning and physics‑based modeling
219 + certified green buildings
Awards: CDP A‑List; ENERGY STAR Partner of the Year; #1 Healthcare REIT in GRESB since 2017; Nareit Leader in the Light