MetLife

The Pet Senior Data & Analytics Consultant is responsible for delivering on the data needs of the pet business. This new position on the Pet Product Team will serve as the internal leader for data structure, reporting, and analysis, and will play a key role in efforts to improve and further develop the data capabilities of the department. They will ensure the business has the necessary data and accurate reporting to achieve our objectives and key results. This is a very visible role within the organization and will operate closely with various business leaders on a day-to-day basis to business' data and analytic requirements.

Principal Responsibilities:

·        Supporting Pet Executive Team in extracting reporting from our data tables and systems of record (SORs)

·        Develop and maintain tooling to track cross functional performance, giving guidance where necessary

·        Manage analytics initiatives end-to-end, collaborating with the Data & Analytics and IT teams

·        SQL modeling for complex and layered problems not yet solved by Data Engineering

·        Utilize data and dashboards to identify opportunities for improving policy holder retention

·        Audit and reconcile differences in reporting across various teams 

·        Organize multiple data sources and tables to build and prepare data foundations for each business use case

·        Will be responsible for UAT & QA testing, data analysis, data visualization, measurement, and analytics

·        Work closely with Pet Executive Team to review and monitor reporting requirements. This is a very technical hands-on role and is responsible for the functional design of the end-to-end data process

·        Work with business owners and data scientists to translate given business problems into analytical solutions with defined outcomes

·        Drive Continuous Improvement: Constantly analyze existing processes and systems to identify opportunities for automation and optimization

·        Perform other related duties as assigned or required

Knowledge/Skills/Competencies Required:

• 5+ years of relevant experience (Pet Insurance knowledge a plus)
• Expert proficiency in SQL required for data extraction and transformation
• Expert proficiency in Microsoft Excel required (VBA a plus)
• Proficiency with PowerBI and data visualization
• Understanding data warehousing concepts and architecture
• Experience designing and maintaining scalable reporting solution
• Excellent organizational, interpersonal, and communication skills, both written and verbal
• Strong project management skills including problem solving, attention to detail, analytical thinking, and decisiveness
• Ability to work autonomously; effectively handle multiple tasks, prioritize deadlines appropriately and remain flexible