Power BI Analytics Specialist – Homeownership Lending

Idaho Housing and Finance Association; Boise (ID); On-site; USD 70,000 - 100,000; Full time

Job summary

Idaho Housing and Finance Association is seeking a detail-oriented Business Analyst to join the Homeownership Lending team. You will design, build, and maintain Power BI dashboards, develop lender scorecards, and produce operational reports to support strategic objectives.

The role is full-time and on-site at IHFA’s headquarters in Boise, Idaho. You will collaborate with Lending, Finance, Servicing, and Compliance teams to drive performance and program success.

Qualifications

• Bachelor’s degree or equivalent work experience in a related field.
• Proficiency in Power BI, including DAX, data modeling, and interactive visualization.
• Strong experience with Excel (pivot tables, lookups, data validation) and familiarity with SQL or relational databases.
• Strong analytical and problem-solving skills with the ability to translate complex data into clear, actionable insights.
• Excellent interpersonal and communication skills; able to work effectively with technical and non-technical stakeholders.
• Ability to manage multiple projects and deadlines in a fast-paced, mission-driven environment.

Responsibilities

• Design, build, and maintain Power BI dashboards to track performance trends and key lending metrics
• Develop and distribute lender scorecards to evaluate partner performance and support engagement strategies
• Produce recurring and ad-hoc reports related to loan production, pipeline management, servicing metrics, and strategic goals
• Collaborate with Lending, Finance, Servicing, and Compliance teams to identify reporting needs and improve business processes
• Ensure data accuracy and integrity by identifying and resolving discrepancies in reporting or source data
• Provide leadership with actionable insights to support business planning, funding allocation, and performance reviews
• Other job duties as assigned

Skills

Power BI

DAX

Data modeling

Pivot tables

Lookups

Data validation

SQL

Relational databases

Analytical thinking

Communication

Project management

Education

Bachelor’s degree in Business Analytics, Finance, Economics, Computer Science, or related field

High school diploma or equivalent

Job description

Idaho Housing and Finance Association is seeking a detail-oriented Business Analyst to join the Homeownership Lending team. You will design, build, and maintain Power BI dashboards, develop lender scorecards, and produce operational reports to support strategic objectives.

The role is full-time and on-site at IHFA’s headquarters in Boise, Idaho. You will collaborate with Lending, Finance, Servicing, and Compliance teams to drive performance and program success.