Business Intelligence Analyst
About The Position
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.
Requirements
- 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
Nice To Haves
- 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
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
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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
