Product Analytics Analyst with SQL / SAS

Hartford, Connecticut

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
Position is an intermediate level role, requiring previous experience in Descriptive Analytics. Position accountable for performing moderately complex core tasks of Descriptive Analytics (the exploration and investigation of past business performance), partnering with team members on more complex tasks. This job does not manage others This job works under General Supervision: Incumbent independently performs a variety of duties, including potentially complex duties within established policy guidelines; responsible for a defined set of assignments (e.g. assigned customers, claims or other specified set of responsibilities); is expected to set priorities and meet specific goals and objectives of the function or unit. (Typically pertains to advanced/operational, senior professional, unit supervisor)

Marketing Description

The Product Analytics team partners with leaders within the Product Management department to help make business decisions faster, more consistently and with greater accuracy. The team is heavily involved in both the cost-benefit-analysis as well as the post-monitoring of business initiatives that support our auto, property, underwriting, and state management areas. With a blend of solid business knowledge, collaboration and communication skills, technical programming and analytical skills the team uses data and analysis to influence the business leaders. Our business area has numerous data sources, and to get the job done individuals on the team leverage different analytical tools including SQL, SAS, Hive, Excel, VBA, R, Python, etc.



Primary Job Duties & Responsibilities
Applies descriptive analytics to analyze data and validate assumptions, understands results. Selects appropriate relevant data and extracts from various internal and external sources. May identify sources. Manipulates raw data sets into information fit for analysis applying needed logic. Presents analysis and recommendations to team members and manager. Supports presentation to business partners. Supports developing reports to monitor business critical results and transitions to appropriate area for continuing production i.e. information development and or data management. Provides required analysis, partnering with team members as needed. Participates in the peer review process. Utilizes established best practices around Descriptive Analytics. May provide guidance to others on assignments. Manages assigned less complex projects under minimal guidance of manager and/or team members. May manage moderately complex projects under general guidance of a manager. Perform other duties as assigned.

Minimum Qualifications
Two years of analytics experience required.

Education, Work Experience & Knowledge
Bachelors degree in STEM (Science, Technology, Engineering, Mathematics) preferred. Three years of analytics or related experience preferred. Three years working successfully with Microsoft office products or similar products preferred. General knowledge of analytic concepts. Experience with Descriptive Analytic practices and processes. General business knowledge preferred. Developing knowledge of Insurance products/concepts preferred. Experience working on teams. General knowledge of the main features of the collection of data and the relationship of data elements to each other.

Job Specific & Technical Skills & Competencies
General understanding of the business functions of businesses supported. Demonstrated intermediate analytic and diagnostic skills. Demonstrated intermediate interpersonal skills. Demonstrated intermediate communication skills Ability to work independently and as part of a team. Intermediate project management skills General understanding of the business functions, processes, and overall business strategies Desire to see tasks to completion. Intermediate Computer Skills in Excel and basic skills in database programming language and/or related applications. Intermediate problem solving and decision making skills.

Preferred Qualifications
  • SQL
  • SAS
  • Python
  • R


Physical Requirements
Operates standard office equipment - Continuously Sitting (Can stand at will) - Continuously Use of Keyboards, Sporadic 10-Key - Continuously

Equal Employment Opportunity Statement
Travelers is an equal opportunity employer.
To apply for this position please CLICK HERE

About Travelers

The Travelers Companies, Inc. (NYSE: TRV) is a leading property casualty insurer selling primarily through independent agents and brokers. The company's diverse business lines offer its global customers a wide range of coverage in the auto, home and business settings. A component of the Dow Jones Industrial Average, Travelers has more than 30,000 employees and generated revenues of approximately $25 billion in 2010.