Sr. System Engineer DBA - Teradata and Snowflake Job at Travelers Insurance, Hartford, CT

Tk85TWlmbmx3L3BKYzByYWdJOCs4a0JQanc9PQ==
  • Travelers Insurance
  • Hartford, CT

Job Description

Hartford, Connecticut

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

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

$111,600.00 - $184,200.00

Target Openings

1

What Is the Opportunity?

Travelers is seeking a Sr Systems Engineer, DBA to join our Infrastructure & Cloud Services - Performance & Data Engineering organization. Under general supervision, plans at an operational level designing and developing databases interfacing with appropriate customers, management and technical resources. Facilitates and/or participates in the design, development, and implementation of large, complex database systems supporting one or more business and/or technology areas. Develops, manages and implements appropriate solutions that may involve multiple platforms, databases, software/hardware, technologies and tools. Strong ability to multi-task in an environment of changing priorities. May direct project staff in the development and implementation of database systems in support of business requirements.

The work arrangement for this position is based on location.

What Will You Do?

  • Provide technical leadership and operational support for our Teradata and Snowflake environments.
  • Collaborate with end users to resolve issues.
  • Complete user requests and ServiceNow tasks in a timely manner.
  • Participate in on-call rotation and provide off-hour support.
  • Prioritize work and manage projects within established budget objectives and customer priorities.
  • Perform other duties as assigned.

What Will Our Ideal Candidate Have?

  • Education, Work Experience, & Knowledge
  • Bachelors degree preferred in in Technology or a similar field (or equivalent experience)
  • Snowflake certification preferred

Technical Knowledge:

  • Teradata Specific:
    • In-depth knowledge of Teradata architecture and operation.
    • Proficient in Teradata SQL, BTEQ scripting, and Teradata utilities (FastLoad, MultiLoad, TPT, FastExport).
    • Experience with Teradata performance tuning and optimization techniques.
    • Familiarity with Teradata tools such as Teradata Studio and Viewpoint
    • Familiar with Teradata Backup and Restore processes
    • Knowledge of Teradata security features and user management.
    • Experience in data migration and ETL processes involving Teradata.
  • Snowflake Specific:
    • Strong understanding of Snowflake architecture and operation.
    • Proficient in Snowflake SQL and understanding of its unique features.
    • Solid understanding of Snowflake features: Cloning, Data Sharing, Secure Views, caching, Warehouse sizes, and scaling.
    • Experience with Snowflake data loading and unloading processes.
    • Familiarity with Snowflake's security features and role-based access control.
    • Knowledge of integrating Snowflake with various data sources and BI tools.
  • General:
    • Strong relational database and SQL skills.
    • Thorough working knowledge of all tools and techniques required for area(s) of responsibility.
    • Understanding of the business that the assigned projects are supporting.

Business Knowledge & Partnership:

  • Addresses business partner issues professionally and promptly.
  • Proposes solutions that optimize project value.
  • Communicates effectively with diverse audiences.

Problem Solving & Decision Making:

  • Demonstrates strong analytical and diagnostic skills.
  • Follows through on decisions to achieve intended results.
  • Executes tasks to completion and optimizes resource use.

Leadership:

  • Maintains effective partnerships within the department and with business customers.
  • Provides valuable input to management and influences peers and project staff inclusively.

Planning and Project Management:

  • Prioritizes key project tasks and maintains a clear sense of priorities.
  • Anticipates and responds effectively to workload and resource changes.
  • Collaborates with management in the planning process.

Environmental / Work Schedules / Other

  • Operates standard office equipment (Continuously)
  • Sitting (can stand at will) (Continuously)
  • Use of Keyboards, Sporadic 10-Key (Continuously)

What is a Must Have?

  • 5 years experience in technology.

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.
  • Paid Time Off: Start your career at Travelers with a minimum of 20 days Paid Time Off annually, plus nine paid company Holidays.
  • Wellness Program: The Travelers wellness program is comprised of tools and resources that empower you to achieve your wellness goals. In addition, our Life Balance program provides access to professional counseling services, life coaching and other resources to support your daily life needs. Through Life Balance, you're eligible for five free counseling sessions with a licensed therapist.
  • Volunteer Encouragement: We have a deep commitment to the communities we serve and encourage our employees to get involved. Travelers has a Matching Gift and Volunteer Rewards program that enables you to give back to the charity of your choice.

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.
  • Paid Time Off:  Start your career at Travelers with a minimum of 20 days Paid Time Off annually, plus nine paid company Holidays.
  • Wellness Program:  The Travelers wellness program is comprised of tools, discounts and resources that empower you to achieve your wellness goals and caregiving needs. In addition, our mental health program provides access to free professional counseling services, health coaching and other resources to support your daily life needs.
  • Volunteer Encouragement:  We have a deep commitment to the communities we serve and encourage our employees to get involved. Travelers has a Matching Gift and Volunteer Rewards program that enables you to give back to the charity of your choice.

Employment Practices

Travelers is an equal opportunity employer. We believe that we can deliver the very best products and services when our workforce reflects the diverse customers and communities we serve. We are committed to recruiting, retaining and developing the diverse talent of all of our employees and fostering an inclusive workplace, where we celebrate differences, promote belonging, and work together to deliver extraordinary results. 

In accordance with local law, candidates seeking employment in Colorado are not required to disclose dates of attendance at or graduation from educational institutions.


If you are a candidate and have specific questions regarding the physical requirements of this role, please send us an email so we may assist you.


Travelers reserves the right to fill this position at a level above or below the level included in this posting.

To learn more about our comprehensive benefit programs please visit .

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.

Job Tags

Holiday work, Work experience placement, Local area,

Similar Jobs

Skyworks

Principal Electrical Engineer Job at Skyworks

 ...changing the way the world communicates. Requisition ID:76169 Description Skyworks Solutions is seeking an experienced RF Engineer who will play a key role in the development of Skyworks silicon IPs and acoustic SAW/BAW technologies. The candidate will be... 

Carlton Electric, Inc.

Electrical Estimator 3 Job at Carlton Electric, Inc.

 ...fill out the application at carltonelectric.com. About Carlton Electric: At Carlton Electric, were passionate about creating a...  ...motivated to develop as a leader within the department. The Estimator 3 serves as a senior member of the preconstruction teamresponsible... 

Arnot Health System

Registered Nurse - OB/Maternity - Per Diem Job at Arnot Health System

 ...accountability for a group of patients for a designated timeframe and provides care to these patients via therapeutic use of self, the nursing process, the environment/instrumentation, and other health care team members. The RN is expected to perform their duties according... 

Universtiy of Illinois UrbanaChampaign

Teaching Assistant Professor - Law Job at Universtiy of Illinois UrbanaChampaign

 ...Teaching Assistant Professor - Law College of Law Job Summary The University of Illinois College of Law in Urbana Champaign is one of the oldest law schools in the country, with an accomplished and influential faculty, a smart and collegial student body... 

Morning Pointe Senior Living

LPN Travel Nurse Job at Morning Pointe Senior Living

 ...Primary Purpose: The LPN Travel Nurse (LPN/or RN) is under the supervision and guidance of the Regional Director of Nursing, Director of Nursing (DON) and the Executive Director (ED) of the Community in which they are assigned.The Travel Nurse will assist the DON and...