Senior BI Systems Analyst

Join Our Team as a Senior Business Systems Analyst!  

About the Role

The Family Security Plan is seeking a highly skilled Senior Business Intelligence Analyst to join our team. In this role, you will design and deliver impactful dashboards, develop robust data models, and transform complex data into actionable insights that drive our sales strategies.

You’ll play a key role in advancing data-driven decision-making by leveraging Power BI, optimizing reporting processes, and collaborating across departments to ensure data accuracy and efficiency.

Key Responsibilities

Power BI Development

• Design, develop, and maintain interactive Power BI dashboards and reports 
• Create DAX measures and calculated columns to support KPIs and business metrics 
• Build and manage data models, including relationships and hierarchies 
• Ensure reports are accurate, user-friendly, and aligned with business needs 

Data Integration & ETL

• Develop and maintain ETL processes using SSIS or similar tools 
• Integrate data from multiple systems into cohesive reporting datasets 
• Support data validation and transformation to ensure data quality and consistency 

Data Analysis & Insights

• Analyze data to identify trends, anomalies, and actionable insights 
• Investigate and resolve data discrepancies and reporting issues 
• Translate business questions into meaningful analytical solutions 

Stakeholder Collaboration

• Partner with stakeholders to define reporting requirements and KPIs 
• Communicate insights through clear visualizations and reports 
• Continuously improve existing dashboards and BI solutions 

Qualifications

Required:

• Bachelor’s degree in Data Analytics, Computer Science, Information Systems, Business, or related field (or equivalent experience) 
• 4+ years of experience in an analytical or BI role 
• 4+ years of SQL experience (query development and data manipulation) 
• 3+ years of Power BI experience building dashboards and reports 
• Experience writing DAX for metrics and KPIs 
• 2+ years of ETL experience (SSIS or similar tools) 
• Strong understanding of relational databases and data modeling 
• Excellent analytical, problem-solving, and critical thinking skills 
• Ability to communicate technical concepts to non-technical stakeholders 

Preferred:

• Master’s degree in a related field 

Why You’ll Love Working Here

• Opportunity to make a real impact on business strategy
• Collaborative, supportive team environment
• Exposure to leadership and cross-functional initiatives
• Work with modern BI tools and evolving data practices
  

What We Value

• At PFP, we look for individuals who embody our core values:
  Caring, Integrity, Drive, Passion, and Resilience