Travelers Canada
Sr. System Engineer, DBA - Teradata and Snowflake
Travelers Canada, Snowflake, Arizona, United States, 85937
Sr. System Engineer, DBA - Teradata and SnowflakeApply remote type Hybrid locations CT - Hartford MN - St. Paul MD - Hunt Valley time type Full time posted on Posted 2 Days Ago job requisition id R-40357
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.
Job CategoryTechnology
Compensation OverviewThe 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 Openings1
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.
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 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.
Employment PracticesTravelers 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
our benefits page .
#J-18808-Ljbffr
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.
Job CategoryTechnology
Compensation OverviewThe 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 Openings1
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.
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 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.
Employment PracticesTravelers 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
our benefits page .
#J-18808-Ljbffr