Consultant, Data Management

Travelers; Hartford (CT); On-site; USD 64,000 - 105,000; Full time

Benefits offered by this job

Health Insurance

401(k) match

Pension Plan

Job summary

Travelers is seeking a Data Analytics professional to leverage ETL, data profiling, and governance capabilities for business and IT initiatives. You will partner with clients to ensure data quality, implement transformation rules, and document data lineage.

The role emphasizes collaborating with stakeholders, supporting data models, and ensuring privacy and security of information across enterprise systems.

Qualifications

• Bachelor's degree or one year of equivalent data and analytics experience.
• Knowledge of ETL/Data Integration tools, one or more Data platforms, and Cloud Computing Technologies.
• Experience with SQL, Teradata, Python, Hive, MicroStrategy, Ab Initio, Messaging, NoSQL.
• Written and verbal communication skills with the ability to collaborate with business partners.
• Ability to foresee challenges and proactively look for ways to create more efficient processes.

Responsibilities

• Participate in managing the availability, usability, integrity, security and privacy of data.
• Assist in implementing processes to assure data quality for business purposes.
• Perform data profiling and analysis and communicate results for data quality processes.
• Meet with business customers to understand and apply data quality requirements and specifications.
• Define data, catalog data, policies, metadata documentation, and data lineage.

Skills

Communication skills

Time management

Relationship building

Collaboration

Problem solving

Education

Bachelor's degree or equivalent data/analytics experience

Tools

SQL

Teradata

Python

Hive

MicroStrategy

Ab Initio

Messaging

NoSQL

Job description

Who Are We? Taking care of our customers, our communities and each other. That's the Travelers Promise. By honoring this commitment, we have maintained our reputation as one of the best property casualty insurers in the industry for over 170 years. Join us to discover a culture that is rooted in innovation and thrives on collaboration. Imagine loving what you do and where you do it.

Job Category

Data Analytics

Compensation Overview

The annual base salary range provided for this position is a nationwide market range and represents a broad range of salaries for this role across the country. The actual salary for this position will be determined by a number of factors, including the scope, complexity and location of the role; the skills, education, training, credentials and experience of the candidate; and other conditions of employment. As part of our comprehensive compensation and benefits program, employees are also eligible for performance-based cash incentive awards.

Salary Range $63,800.00 - $105,400.00

Target Openings

1

What Is the Opportunity?

• Leverages technology and analytics skills to apply basic data analysis practices that benefit business and IT strategic initiatives.
• Performs intermediate data profiling, metadata documentation, data lineage, data transformation rules in support of key program deliverables.
• Meets data management needs of internal and external clients according to established standards, including problem research/resolution and customer education.
• Provides data subject matter expertise within areas of knowledge to business and IT organizations.
• Perform data impact analyses in partnership with project teams.

This job does not lead others. General supervision: the employee is told what to do but not how to do it. The how to is left up to the employee. These jobs have some discretion on accountabilities.

What Will You Do?

• Participate in the process of managing the availability, usability, integrity, security and privacy of the data.
• Assist in implementation of processes to assure data quality for business purposes.
• Perform data profiling and analysis and communicate results in support of data quality processes.
• Meet with business customers to understand and apply business data quality requirements and specifications.
• Define data, catalog data, policies, metadata documentation, data lineage, data transformation rules in support of key program deliverables.
• Work with business customers to ensure appropriate naming definitions and standards are being followed.
• Participate in the creation of data models (e.g., entity design and population).
• Perform testing and validation of requirements and/or data management capabilities when/where applicable.
• Apply basic understanding of overall data models, data relationships, mapping lineage and business rules.
• Create detailed test strategies and test plans.
• Perform intermediate root cause analysis and resolution of business data issues.
• Gather information across the enterprise and use tools, processes, and workflows to capture knowledge and maintain its relevance.
• Participate in the maintenance and governance of taxonomies and ensures its applicability to content and/or data.
• Perform other duties as assigned.

What Will Our Ideal Candidate Have?

• Knowledge of ETL / Data Integration tools, one or more Data platforms, and Cloud Computing Technologies and related emerging technology.
• Experience with one or more of the following tools and languages -SQL, Teradata, Python, Hive, MicroStrategy, Ab Initio, Messaging, NoSQL.
• Written and verbal communication skills with the ability to collaborate effectively with business partners.
• Ability to foresee challenges and proactively look for ways to create more efficient processes for the business.
• Ability to foster relationships with peers to achieve objectives.
• Strong organization skills with the ability to manage time and competing priorities.
• Basic understanding of overall data models, data relationships, mapping lineage and business rules.

What is a Must Have?

Bachelor's degree or one year of equivalent data and analytics experience.

What Is in It for You?

• Health Insurance : Employees and their eligible family members - including spouses, domestic partners, and children - are eligible for coverage from the first day of employment.
• Retirement: Travelers matches your 401(k) contributions dollar-for-dollar up to your first 5% of eligible pay, subject to an annual maximum. If you have student loan debt, you can enroll in the Paying it Forward Savings Program. When you make a payment toward your student loan, Travelers will make an annual contribution into your 401(k) account.
• You are also eligible for a Pension Plan that is 100% funded by Travelers.