As a Senior Business Analyst / Data Engineer, you will be responsible for delivering key analytical insights, building dashboards and automating reports to serve all layers of the Claims organization. This high visibility role has direct exposure to senior leaders across Arch Insurance. Your efforts will have a high impact on delivering performance metrics to the Claim organization to facilitate achieving our growth and profitability targets. This role reports to the Manager of Claims Analytics and is an individual contributor position.

1. Collaborate with stakeholders to gather requirements for building Power BI dashboards and reports.
2. Work with various data sources to provide insights into business performance.
3. Collaborate with IT, Strategic Analytics and other inter-departments to deliver innovative solutions.
4. Compile information into presentations for senior leaders.
5. Identify and analyze KPIs across various PBI’s.
6. Adherence to best practices, naming conventions and version control.
7. Support Data Governance initiatives and assist in the build of Claims Data & Analytics data library.

1. SNOWFLAKE: Proficient with snowflake database environments and queries.
2. SQL: Proficient with MSSQL database environments and queries.
3. PBI: Proficient in Power BI development (including workflows), implementation, QA, and troubleshooting.
4. Has advanced knowledge in creating KPI analytics to support business needs.
5. Strong ability troubleshoot and problem solve, with ability to present & document findings.
6. Excellent communication skills in addressing business and technical matters with members of senior management and the technical teams.
7. EXCEL: Advanced skills with Microsoft Excel spreadsheet knowledge, formulas, pivot tables, queries, macros, etc.
8. Adept at identifying opportunities and strategies to improve existing process efficiency (proactive and reactive).
9. Exceptional analytical skills to understand key drivers of the business as well as forecast how various levers can impact business trends and results.
10. Strong collaboration and partnering skills to work directly with management to identify scope of projects and timelines.
11. Background in P&C insurance is preferred but not required.
12. Experience delivering results as an individual contributor as well as in a team setting.

Bachelors Degree