Analytics Specialist II

				Overview:

The Analytics Analyst II is responsible for supporting the Claims organization by developing advanced reporting and dashboard solutions, leveraging their expertise in PowerBI, DAX and associated tools, to evaluate data and identify opportunities to improve efficiency and effectiveness in our programs. The right candidate will bring a balance of experience working with and manipulating large/complex datasets (claims data expertise preferred), technical capabilities, presentations skills, creativity and execution to the table. The ability to utilitize business intelligence tools to identify/project significant shifts in key business metrics and communicate observations to business owners and technical partners will be critical to success in this position.

This position will report to the AVP of Claims Reporting. Candidate will be expected to maintain a solid understanding of AmTrust's mission, vision, and values while upholding the standards of the AmTrust and Claims organization.

Responsibilities:

* Collaborates with department heads to coordinate blending data from multiple sources for unified reporting and looks to identify cross-functional opportunities to either simplify or improve current processes.
* Learns business processes and understand relevant data.
* Adept and evaluating and pivoting very large data sets with an ability to spot trends and present business insights.
* Prepares deliverables for, and collaborates with, senior leaders and cross-functional teams.
* Works with IT resources to test and validate ETL processes, report building, process automation, and dashboard development.
* Supports Claims leadership team with ad-hoc requests.
* Design and build reporting and dashboarding solutions
* Design and build report automation and distribution using Power BI
* Establish a monthly claims operational reporting package that includes dashboard, scorecards and reports utilizing Power BI, MS Excel, and SQL
* Work with subject matter experts to generate reporting requirements
* Identify, synthesize, and recommend actionable analytical insights to drive improvement within the Claims organization
* Support the build out of executive level presentations with actionable insights and recommendations
* Develop complex analyses and present findings to senior Claims and Actuarial leadership
* Keeps current with market trends and demands.
* Performs other functionally related duties as assigned.

Qualifications:

* Bachelor's degree or equivalent experience
* 3+ years financial or operational analytical experience
* Strong experience with PowerBI and DAX  
* Experience using SQL with BI software suites
* Prior experience in reporting and data visualization solutions, consulting or business analysis
* Ability to operate under limited supervision and play an active role in cross-functional work

Preferred: 

* Property Casualty Insurance industry experience
* Experience with MS Office toolkit, particularly Sharepoint, Teams, and Planner
* Experience with Python, VBA, or other data and coding languages

This job description is designed to provide a general overview of the requirements of the job and does not entail a comprehensive listing of all activities, duties, or responsibilities that will be required in this position.

The expected salary range for this role is $66,900-$97,000/year.

Please note that the salary information shown above is a general guideline only. Salaries are based upon a wide range of factors considered in making the compensation decision, including, but not limited to, candidate skills, experience, education and training, the scope and responsibilities of the role, as well as market and business considerations.

#LI-BL1

#LI-REMOTE

#AmTrust
			

Apply

Share this job:

Share this Job

View company profile

AmTrust Financial Services, Inc.

Connect To Our Company