Business Intelligence Analyst at Pivotal Housing Partners LLC – West Chester, Ohio

Key things that you want to know about this role:

• Job Level: Early Career (0–3 years experience)
• Job Location: Cincinnati, OH
• Position Type: Full-Time
• Salary Range: Starting at $60,000+ annually - Pay depends on experience level

About Us

Pivotal, ranked in the Top 50 Affordable Housing Developers in 2017-2024, is an industry leader revolutionizing the housing market – one community at a time. An integrated real estate company specializing in the development and operations of multi-family housing, Pivotal strives to provide exceptional service to enhance the lives of our residents.

We are able to provide high quality properties and customer service because of the commitment to excellence by all of outstanding team members. If you hold yourself to a high set of standards, embrace a positive service-minded demeanor, enjoy working through shifting priorities, and want to join a fulfilling environment with growth opportunity, Pivotal has an outstanding position for you.

Position Overview

Pivotal Housing Partners is seeking a Business Intelligence Analyst to support the company’s growing analytics and reporting capabilities.

This role will focus primarily on building and maintaining Power BI dashboards, supporting operational and financial reporting, and helping translate business questions into actionable data insights. This role requires someone who can translate business questions into clear dashboards and visualizations.

The Junior BI Analyst will work closely with operations leadership and analytics stakeholders to support reporting for portfolio performance, property-level operations, financial analysis, and key portfolio KPIs. This role plays an important part in ensuring teams across the organization have access to clear, accurate, and useful data.

The ideal candidate enjoys working with data, solving business problems, and turning complex information into clear and useful visualizations.

Summary of responsibilities

• Design and build Power BI dashboards and reports using existing data models
• Maintain and enhance existing dashboards to improve usability and accuracy
• Translate business questions into meaningful reports and visualizations
• Support operational reporting across property management and portfolio performance
• Assist with financial and KPI reporting for leadership teams
• Troubleshoot report issues and resolve data discrepancies
• Perform data validation and quality checks to ensure reporting accuracy
• Support ad-hoc analysis requests from operations leadership
• Work with Regional Managers and internal stakeholders to understand reporting needs
• Document report logic, definitions, and dashboard usage to support internal knowledge sharing
• Assist with identifying opportunities to improve analytics workflows and reporting efficiency

How this role evolves over time

• Early months: Learn Pivotal’s reporting environment and Power BI dashboards; build and update dashboards using existing semantic models; support ad-hoc reporting requests and data validation efforts
• Mid-term growth: Take ownership of recurring reports and operational dashboards; improve existing reports through better design, usability, and performance; help identify opportunities for new dashboards
• Long-term development: Contribute ideas to improve analytics processes and reporting standards; gain deeper knowledge of portfolio analytics and property operations

Required Skills

• Bachelor’s degree in Data Analytics, Information Systems, Computer Science, Finance, Business Analytics, or related field
• 0–3 years of experience working with data analytics or business intelligence tools
• Experience building dashboards or reports using Power BI or similar BI tools
• Working knowledge of SQL for querying and analyzing data
• Understanding of basic data modeling concepts (tables, relationships, measures)
• Strong analytical and problem-solving skills
• Ability to translate business questions into meaningful data insights
• Strong attention to detail and commitment to data accuracy
• Ability to manage multiple priorities in a fast-paced environment

Preferred Skills

• Experience with Power BI dashboard development and report design
• Familiarity with Power Query and data transformation concepts
• Exposure to Python, automation tools, or AI-assisted analytics tools
• Interest in real estate, housing, or operational analytics environments
• Experience explaining data insights to non-technical audiences

Full-Time Benefits:

Medical Coverage: Choice of two medical plans (PPO and HDHP) to fit your needs

HSA Contributions: Company-funded contributions to your Health Savings Account (HSA) each year

Dental, Vision & More: FSA, dental, vision, life, accident insurance, plus short- and long-term disability coverage

Retirement Savings: 401(k) plan with company match to support your future

Time Off: Company-paid holidays and unlimited PTO

Yearly Bonus Opportunities –Eligible for performance-based bonuses, rewarding strong results and teamwork.

Emotional Wellbeing: Employee Assistance Program (EAP) for you, your dependents at home, and even children away at college

Professional Growth: Professional development assistance to support your career goals

Pivotal is an Equal Opportunity Employer and Prohibits Discrimination and Harassment of Any Kind.At Pivotal, we understand that no candidate is perfectly qualified for any job. Experience comes in different forms; many skills are transferable -- and passion goes a long way. Even more important than your resume is a clear demonstration of dedication, impact, and the ability to thrive in a fluid and collaborative environment. We want you to learn new things in this role, and we encourage you to apply if your experience is close to what we’re looking for. We also know that diversity of background and thought makes for better problem solving and more creative thinking -- which is why we're dedicated to adding new perspectives to the team.