Business Intelligence (BI) Analyst - Mid
This mid-level role bridges actuarial modeling and business intelligence to design scalable reporting solutions using Power BI and cloud-based automation. The BI Analyst will optimize data workflows, ensure report accuracy, and collaborate cross-functionally to enhance decision-making processes.
Skills required
About this role
The BI Analyst partners with Actuaries to identify reporting priorities driven by actuarial models. In this role, you will leverage business intelligence and analytical expertise to develop new reports and enhance existing reporting solutions.
Job Responsibilities
- Collaborate with actuarial teams to design and deliver actionable reporting solutions
- Develop and enhance reports using Power BI and Microsoft Power Platform tools for data analysis and visualization, and maintain comprehensive semantic models within Power BI
- Build, configure, and maintain automated testing workflows within cloud environments
- Create and maintain scalable CI/CD pipelines for reporting solutions, leveraging Git-based workflows
- Perform regular validation of report outputs in partnership with QA teams
- Produce and maintain clear documentation for internal use and UAT
- Partner with data engineering teams to improve reporting data models and architecture
- Collaborate with cross-functional stakeholders; implement reporting standards and align practices with governance and compliance requirements in partnership with IT teams
Qualifications
- 2+ years of experience developing reports in Power BI
- 5+ years of experience building reports and dashboards using visualization tools (e.g., Power BI, QlikView, Tableau)
- Experience supporting analytics or actuarial functions, preferably within an insurance environment
- Ability to independently troubleshoot and resolve technical challenges
- Strong analytical thinking and problem-solving capabilities
- Commitment to continuous learning and exploration of emerging tools and technologies
- Ability to leverage data to drive business insights and decision-making
- Familiarity with SQL, Snowflake, or Python is a plus
- Familiarity with Streamlit or Sigma is a plus
Technical Skills
Required
Power BI report developing
DAX Language
Power Automate
Power App
Microsoft Office Products
(MS Teams, Outlook, Word, PowerPoint, etc.)
Optional
User request gathering
UI/UX and Wireframing
Power Query
Git/GitHub
Databases (SQL Server, Snowflake)
Microsoft Excel
Python for Data Analytics
Additional Information
Education:
- Bachelor’s degree in statistics, mathematics, information technology, computer science, business analytics, data analytics, or equivalent work experience
