Skip to main content

This job has expired

Data Analytics Analyst with SQL

Employer
Travelers Insurance
Location
Hartford, Connecticut
Salary
Not Specified
Closing date
Mar 15, 2019

View more

Category
Actuary, IT
Job Type
Not Specified
Career Level
Not Specified

Job Details

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
Facilitate sourcing data from a variety of different sources (internal and external), preparing it at the 'right speed' for analytic consumption. Incumbents use advanced analytical tools to perform exploratory analysis of data to determine business viability. JOB SUMMARY Performs data acquisition, preparation and performs basic analysis leveraging a variety of data programming techniques. This job does not manage others This job works under Moderate Supervision: Incumbent performs standard and routine assignments independently to conclusion; unusual problems which may require exceptions to procedures or processes are referred to the supervisor.

Marketing Description
Bond & Specialty Insurance Business Intelligence and Analytics unit is looking for a new member to join our organization focusing on business performance metrics, drawing business inferences and clearly articulating findings and recommendations that identify impactful business opportunities. The ideal candidate will have prior working experience in Business Intelligence (BI)/Management Information (MI)/ or Data Management/Analytics areas, with a strong technical skillset in data acquisition, integration, processing and reporting.


Primary Job Duties & Responsibilities
Data Acquisition, Prep and Exploration: Independently acquire simple data, make recommendations for more complex acquisitions. Assists with unfamiliar data. Independently reviews, prepares, basic design, and integrates data, correcting minor problems and implements data cleansing/quality solutions. Understands Travelers standards, processes, and protocols. Applies moderate and develops basic data derivations, business transformation rules, and data requirements. Works as member of teams. Able to identify task lists of projects and manage with assistance of others. Performs analysis of sources to determine value and use. Build simple data visualizations techniques to help support data exploration. Continues to develop business knowledge while learning how work assignments address business issues. Seeks opportunities to expand technical knowledge and capabilities. Typically Interacts with customers at same level. Analytic Data Discovery: Operationalize and automates well defined simple data products independently. Incorporate core data management competencies - data governance, data security, data quality. Builds, tests, and implements simple analytic business products, including pilots and proof of concept. Applies knowledge of current industry trends and techniques to formulate solutions within the context of assigned projects. Analytic Support: Assist in training business users on data products/analytic environment. Delivers basic training. Ensures customer satisfaction through professional communication, follow-up, and responsiveness to issues. Consultation: Shares knowledge with peer users on data or analytic products. May provide guidance to lower level technical employees. Perform other duties as assigned.

Minimum Qualifications
1 year of relevant experience with data tools, techniques, and manipulation required.

Education, Work Experience & Knowledge
Bachelor's Degree - STEM (Science, Technology, Engineering, Math) or Business preferred. 3 years of relevant experience with data tools, techniques, and manipulation preferred.

Job Specific & Technical Skills & Competencies
Advanced experience with MS SQL Server & Integration/Reporting Services(SSIS/SSRS). Ability to develop and understand complex SQL queries (MS SQL, T-SQL, PL/SQL). Strong understanding of relational databases. Strong understanding of working with unstructured data sets.

Communication Skills: Ability to communicate thoughts/designs/ideas in an unambiguous manner and adjusts communication based on audience. Exhibits active and effective communication skills with team members - including active listening and effective written and verbal communication skills. Effectively contributes and communicates with the immediate team. Ability to foster relationships with peers to achieve objectives. Practices objectivity and openness to others' views. Able to recognize and support team priorities.

Problem Solving & Decision Making: Able to recognize and analyze business and data issues of intermediate complexity with minimal supervision. Recognize when escalation is necessary. Able to leverage previous experience to consider a variety of alternatives to arrive at a timely, practical, and cost-effective solution to resolve defects or incidents.


Preferred Qualifications
Prefer experience with data analysis tools & stats packages (Excel, R, Python).
Prefer experience with data visualization tools (Qlikview, MicroStrategy, Tableau).

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

Company

Trav Banner

WHO WE ARE

Imagine a Career With Purpose.

For more than 160 years Travelers has earned a reputation as a leader in personal, business and specialty insurance because we take care of our customers. When you work at Travelers, life’s most important moments become your life’s work. That means helping families feel secure, businesses to prosper, knowing that you’ve made a difference, and feeling like you belong to something bigger.


LIFE AT TRAVELERS

Imagine Playing a Role in Something Bigger.

A career at Travelers means being part of a team comprised of 30,000 + talented and passionate people that’s evolving to meet changing needs – from customer service to data science and beyond. If that’s more than you imagined in an insurance career, it’s time to join us at Travelers.


JOIN OUR TALENT COMMUNITY
As a part of our Talent Community, you will receive customized job alerts, be the first to know about opportunities to work at Travelers, and stay connected with our recruiters!

 

 

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert