Senior Data Analyst

  • 37746
  • Non-Life - Data Science
  • |
  • Massachusetts, United States
  • |
  • Jul 16, 2020
  • Develop, modify, and improve data sets and reporting processes to be used by other members of the department, including Marketing, Actuarial, and Product teams.
  • Gather requirements across groups and incorporate insights as to how these customers think about their business and incorporate these insights into processes and reporting.
  • Propose, develop, automate and implement best-in-class visualizations to address business questions.
  • Create, automate and document new reports, data elements, and processes.
  • Manage our volume forecasting process in its entirety. This includes communication with Product, Finance and Marketing teams, assumption selection, the volume projection model, the downstream output and reporting, and communicating the projection results.
  • Use an AGILE approach to iteratively revisit and improve upon design while meeting scheduled deliverables.
  • Troubleshoot processes and reports for performance and accuracy.
  • Answer complex data-related inquires and provide data to internal customers in a timely manner with clear communication.
  • Advanced degree in a quantitative field of study required.
  • At least 5 years in a data analyst position, preferably working as a Data Analyst in a fast-pace Property & Casualty business setting with experience designing and creating report, visualizations, and forecasting.
  • At least 5 years of experience with complex SQL coding
  • Advanced proficiency in Microsoft SSAS Cube development and management.
  • Mastery level of Microsoft Excel, including inter-sheet operability, pivot table development and design, PowerPivot, and PowerQuery.
  • The position also requires expertise researching raw data and using that data to build optimized analytical data stores.
  • Ability to create, troubleshoot, and enhance downstream data processing.
  • Comprehensive understanding of property and casualty insurance terms, concepts, products, and finance, and insurance-related analysis.
  • Strong written and verbal communication skills are a must.
  • Must be able to demonstrate the ability to creatively solve complicated data problems.