Senior Data Analyst

Foundation Risk Partners, one of the fastest growing insurance brokerage and consulting firms in the US, is adding a Senior Data Analyst to their enterprise team.

Foundation Risk Partners (FRP) is seeking a Senior Data Analyst to design, build, and maintain enterprise-level business intelligence and data solutions that drive trusted insights across the organization. This role combines strong data engineering skills with expertise in BI visualization and governance, with a focus on Microsoft Fabric as FRP's enterprise data platform. The ideal candidate will be both a hands-on builder and a strategic partner, supporting the VP of Enterprise Reporting in shaping the future of enterprise reporting at FRP.

Key responsibility

• Partner with the VP of Enterprise Reporting to implement FRP's reporting strategy and governance standards.
• Design and maintain enterprise data models with a focus on security, compliance, and scalability.
• Build and optimize Microsoft Fabric-based data pipelines, Lakehouses, and semantic models to support scalable, governed reporting.
• Develop and maintain BI dashboards that transform complex data into actionable insights for business leaders.
• Collaborate with stakeholders across FRP to understand business requirements and deliver effective reporting solutions.
• Support and enforce FRP's data governance, data quality, and validation practices.
• Provide technical mentorship and guidance to analysts and business users on best practices in Fabric, Power BI, and self-service BI.
• Troubleshoot and optimize queries, reports, and data models for performance.

Stay current with emerging BI, Microsoft Fabric, and data engineering trends to recommend continuous improvements.

Requirements

• Proven expertise in BI visualization tools, with Power BI strongly preferred (Tableau or Qlik also acceptable).
• 5+ years of experience in data engineering, BI development, or analytics.
• Familiarity with SQL and relational databases such as SQL Server or MySQL.
• Proficiency in Microsoft Fabric components including Data Factory, Data Engineering, Lakehouse, Warehouse, and semantic modeling.
• Experience with data governance, data quality, and security best practices.
• Ability to design scalable, secure, and compliant enterprise data models.
• Strong communication skills and ability to collaborate across technical and business teams.
• Skilled in troubleshooting and optimizing queries, reports, and data models for performance.
• Exposure to version control and deployment practices (e.g., Git, CI/CD pipelines) is a plus.

Preferred Qualifications

• Experience with cloud-based data platforms (e.g., Azure Synapse, Databricks, Snowflake).
• Strong SQL skills and experience with relational databases (e.g., SQL Server, MySQL).