Data Support Specialist (SQL Dashboard Innovation)

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
The Information Delivery Consultant is a development resource that analyzes data across multiple sources, assembles data for delivery and develops components of Business Intelligence applications. This position works within a project team to deliver innovative solutions and will have intermediate technical skills and working knowledge of data concepts.

Primary Job Duties & Responsibilities
Develops analytic and reporting solutions aligned to defined business requirements. Completes root cause analysis of production defects. Analyzes 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 reporting solutions. 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 several Business Intelligence products and tools. Performs other duties as assigned. Perform other duties as assigned.

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

Education, Work Experience & Knowledge
  • 4 years of general business experience.
  • 2 years' experience working with MS Office with advanced knowledge of Excel.
  • 2 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 intermediate 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.


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., Intermediate analytics and diagnostic skills, Intermediate project management skills. Lead Solution Design and Development: Demonstrated ability to see results to completion. Listening/Influencing: Intermediate interpersonal, communications and presentation skills. Critical Thinking/Problem Solving: Intermediate problem solving and decision making skills. Creativity/Innovation: Seeks opportunities to learn. Teams: Ability to work independently and as part of a team.

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.
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.