Company Information
Solid reputation, passionate people and endless opportunities. That's Travelers. Our superior financial strength and consistent record of strong operating returns mean security for our customers - and opportunities for our employees. You will find Travelers to be full of energy and a workplace in which you truly can make a difference.

Job Summary
PI Platform Information Delivery has an exciting opportunity for a passionate, driven and naturally curious candidate! In the Business Intelligence Lead Developer role, you will work closely with customers across Product, Actuarial and Finance value streams to deliver innovative solutions ranging from Data Discovery to Business Intelligence application development. You will partner with developers from a wide variety of technical and domain experience levels thus creating a culture of collaboration, creativity and growth. Strong technical skills (i.e. SQL/Teradata, Big Data, Geospatial and MicroStrategy) and a basic understanding of insurance operations and core functions are desired.



Primary Job Duties & Responsibilities
Develops analytic and reporting solutions aligned to defined business requirements. Completes root cause analysis of production defects. Contributes to solution design within assigned tasks and validates that developed solutions align with defined business requirements. Analyzes internal/external data sets using SQL Management Studio and visualization tools. Compiles and verifies data utilized for periodic scheduled reporting. Develops an understanding of all data contained within multiple data marts and source systems. Translates business requirements into technical requirements for enhancements and new custom reports. Utilizes a rapid prototyping methodology to perform ad-hoc analysis to find solutions to business inquiries. Performs regular data analysis monitoring to provide prescriptive recommendations based on data. Develops knowledge of Business Intelligence products and tools. Develops project timelines and plans, for assigned projects. Provides guidance to less experienced peers. Perform other duties as assigned.

Minimum Qualifications
Bachelors Degree in Information Systems, Mathematics, Economics, Finance or other quantitative subject. 5 years of experience in data and analytics experience required.

Education, Work Experience & Knowledge

• 8 years of general business experience.
• 6 years' experience working with MS Office Suite with advanced knowledge of Excel.
• 6 years' experience coding SQL.
• Experience with modern data visualization tools.
• These may include, but are not limited to Qlik, MicroStrategy, Power BI and Tableau.
• Experience with industry standard statistical programming languages.
• These may include, but are not limited to R, Python or SAS.
• Understanding of database structures.
• Demonstrated excellent written and verbal communication skills.
• Ability to work independently, as well as collaborate with others.
• Must be a team player and able to effectively work with team members located in different locations.
• Demonstrate an ability to tell a story using data.
• Problem solving and issue resolution skills necessary.
• Demonstrates the ability to operate independently to design, develop, and prepare reports.

Job Specific & Technical Skills & Competencies
Core Technical Competencies: MS Office especially Excel with VBA, SQL Server, Qlik, Cognos, TM1, Data Knowledge: Data Acquisition, Preparation and Exploration Experience working with industry standard data platforms. These may include, but are not limited to Teradata, SQL, Big Data, NoSQL, etc., Development techniques (Visualizations, Geospatial, etc.), Web Development approach and skills in support of Modern Business Intelligence platforms, Intermediate analytics and diagnostic skills, Intermediate project management skills. Lead Solution Design and Development: Demonstrated ability to see results to completion. Demonstrate ability to think strategically. Intermediate problem solving and decision making skills. Ability to think strategically. Listening/Influencing: Intermediate interpersonal, communications and presentation skills. Demonstrated ability to influence others. Ability to interact effectively with other functions. Build and maintain credibility with others. Critical Thinking/Problem Solving: Intermediate problem solving and decision making skills. Creativity/Innovation: Seeks opportunities to learn and to influence others. Ability to consider others ideas seriously and accept feedback. Teams: Ability to work independently and as part of a team. Intermediate leadership skills including ability to: Leverage Differences, Manage in participative manner, Develop employees.

Physical Requirements
Requires extended periods of computer use. Requires extended periods of sitting.

Licensing or Certificates
Business Intelligence certification preferred.

Equal Employment Opportunity Statement
Travelers is an equal opportunity employer.