Senior Data Analyst

Westchester Specialty Group’s growing Business Analytics team is seeking a Senior Data Analyst focused specifically on our pet insurance products under the Healthy Paws brand. This person will be responsible for the ideation, development, and management of automated, end-to-end reporting and visualization tools that are critical for successful business decision-making. We are looking for someone with a passion for analytics and experience harnessing the power of data and automation, who is willing to explore new tools, techniques, and businesses to create impactful analytical solutions for our partners.

This role will work on building the next level of advanced analytical processes and reports for our dynamic pet insurance business, Healthy Paws, which will enable more accurate and faster information delivery to business partners while working directly with financial, underwriting, and IT leadership. This role will also be key in identifying gaps and growth areas within the analytics function and executing project plans designed to expand the impact and exposure of the Business Analytics team.

Critical factors for success include:

• Enthusiasm for analytics and creative problem-solving, with a desire to be on the front foot when it comes to tools and techniques.
  
• Ability to meet deadlines with high-quality end-products in a fast-paced environment.
  
• Self-starter and innovator who can successfully set direction and priorities, manage own work, and drive results.
  

Focus on process improvement and efficiency, and continuous development, both technically and professionally.

• Lead the scoping, development, maintenance, and enhancement of insightful reporting for the Healthy Paws Pet Insurance business, leveraging advanced tools and techniques (e.g., SQL, Python, etc.) to drive automation and efficiencies.
  
• Design and build new automated data connections and reports in various data visualization tools (e.g., QlikView and Qlik Sense, Power BI, Excel) using input from business leaders, while adapting to dynamic business needs.
  
• Visualize and develop solutions (dashboards, scorecards, analytic reports) to highlight trends and anomalies in the data, while designing and delivering end-user training and technical support.
  
• Manage data from multiple sources, including underwriting, claims, actuarial, and product databases, to create integrated views and to ensure data integrity and consistency.
  
• Own the user story from idea to implementation, including onboarding, training, and engagement, while continuing to promote and demonstrate the value of analytics.
  
• Explore new data models, software, and algorithms that improve data visualization, presentation, and ease of information delivery to our business partners.
  
• Lead and execute projects designed to increase the impact and exposure of the analytics team within the organization, by identifying new or underserved areas of the business and developing analytical solutions to close the gaps.
  
• Identify opportunities for automation, efficiency, and overall process improvement in all aspects of job, while offering support to team members as well.
  
• Bachelor�s degree with focus on Computer Science, Statistics, Mathematics, Programming, MIS, or other related fields of study.
  
• Minimum of 4-6 years of relevant experience. Preferred experience in insurance industry with in-depth knowledge of insurance financials, data, and applications.
  
• Proficiency in maximizing the power of dashboarding and reporting tools (e.g. Qlik Sense, Tableau, Power BI).
  
• Experience with database querying, ETL, and related tools and languages (e.g. SQL, Python, R).
  
• Strong data analysis skills, with the ability to synthesize data, identify and highlight trends, assess business impacts, and make recommendations for improvement.
  
• Excellent problem-solving skills with the ability to exercise sound judgment and make solid recommendations.
  
• Ability to adjust quickly to meet business priorities.
  
• Strong written and oral communication skills with demonstrated ability to present information in differing degrees of detail and form depending on the audience.
  
• Strong interpersonal skills with demonstrated ability to build relationships and trust with cross-functional teams.
  
• Collaborative, results-oriented attitude.
  
• Demonstrated integrity and dedication.
  
• Professional attitude and demeanor.
  
• Proficiency in end-user applications (e.g. Microsoft Excel, PowerPoint, and Word).