Travelers Business Data Management / SQL Developer in Hartford, Connecticut



Business Data Management / SQL Developer

Target Openings:


Primary Job Duties & Responsibilities:

Develops and applies data derivations, rules; and data requirements that align with standards and regulatory compliance. Participates in the development of Data Management standards and best practices. Consults on projects, resolves moderate to complex data issues and provides training and mentoring to clients and peers. Participates in the data governance process, preparing artifacts for submission. Actively participates in the creation and implementation of business information models, and business intelligence and data roadmaps including attributes, structures and relationships. Actively participates in complex entity design, structure and population. Provides guidance to strategic projects around accuracy and availability of data. Monitors, identifies, investigates, prioritizes, remediates and communicates data quality issues. Performs data profiling, analyzes and communicates results in support of data quality processes. Assists in implementation of processes to certify data quality for business intelligence purposes. Provides day-to-day project leadership by setting priorities, assigning work and coaching/mentoring unit members to ensure standards regarding timeliness and quality are met. Demonstrates detailed understanding of overall data models, data relationships, mapping lineage and business rules. Data Governance: Designs and implements metadata repositories. Partners with projects to facilitate adherence and execution of data governance standards. Assists in designing and implementing metadata repositories. Actively participates in defining, loading and maintaining metadata. Seeks opportunities to enhance data management maturity. Assists with providing data governance oversight and setting of standards. Assists in implementation and execution of the data quality program to ensure data quality standards are being met. Adheres to the structure, best practices, storage needs of the data lineage. Data Analysis: Work with business areas and project team members to understand new business capabilities and perform impact analyses to determine additional data requirements, provide data expertise and data as needed. Conduct fact gathering sessions with customer to define and confirm requirements. Oversee deliverables for compliance (e.g. state/bureau requirements). Develops, maintains and prioritizes business data requirements and specifications; leveraging data standards, ensuring that solutions (structure, values, relationships, quality standards) meet operational and business need. Analyzes medium complexity customer requests (internal or external, e.g. data calls) for changes to production systems, determines impact on existing systems, processes and develops appropriate specifications, enhancements and or procedures to comply. Meet with customer to elicit requirements. May act as project lead for medium complexity items. Manage the testing and verification processes ensuring accurate. Handles moderate to complex root cause analysis of business data issues and provides technical data guidance on complex issues. Oversee specification or procedural changes to address issue. Provides input to end to end data flow and lineage from capture at source, to storage, to delivery and its business intent at each stage (i.e. capture, transformation, fragmentation, editing). Conduct thorough analysis of data in preparation for retiring old capabilities. Develop strategic solutions for architecture for managing of data including transformation logic, rules, tables as well as business requirements and specifications. Represents functional unit and/or departmental needs as part of Data Management committees with internal and external areas, including Product Underwriting, Statistical Bureaus, etc.

Job Opening ID:


Equal Employment Opportunity Statement:

Travelers is an equal opportunity employer.

Job Specific & Technical Skills & Competencies:

Strong knowledge of enterprise uses of data and total data flow within enterprise. Possesses strong knowledge of database software applications, financial modeling tools, and actuarial/statistical modeling tools. Demonstrated intermediate analytic and diagnostic skills. Demonstrated intermediate interpersonal skills. Demonstrated intermediate communication and presentation skills. Ability to work independently and as part of a team. Demonstrated ability to influence others. General understanding of the business functions, processes, and overall business strategies. Demonstrated ability to see results to completion. Intermediate business acumen. Seeks opportunities to learn and to influence others. Intermediate problem solving and decision making skills. Ability to interact effectively with others across functions. Ability to consider others' ideas seriously and accept feedback. Ability to think strategically. Build and maintain credibility with others. If incumbent leads others, intermediate leadership skills including ability to: Leverage Differences. Manage in participative manner. Develop employees. General understanding of the business functions, processes, and overall business strategies. Intermediate skill/competency level: demonstrates solid knowledge and ability; can apply the competency with minimal or no guidance, in the full range of typical situations. Requires guidance handling novel or more complex situations.

Job Category:

Management Information, Risk Control

Marketing Description:

Travelers Risk Control has an exciting opportunity for a SQL Developer in our Data Management area. Risk Control has a wide variety of data that spans our operational systems, customer portal and forensic laboratory. The right candidate will dive deep into these spaces to learn the data relationships and understand how to extract data, improve data quality and provide accurate data insight to leadership. This position requires a candidate with a strong analytical mindset, problem solving skills, technical acumen and the ability to communicate effectively with Risk Control leadership, IT and Business Intelligence & Analytics groups across the Enterprise.

Job Summary:

Positions within this family ensure data is properly managed and leveraged from Source to Storage to Delivery in the most efficient and effective way to benefit the organization. This position performs accountabilities under general supervision and: Leverages technology and analytics skills to apply intermediate data analysis practices that benefit business and IT strategic initiatives. Performs advanced data profiling, metadata capture, 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 to business and IT organizations. Performs intermediate data impact analyses in partnership with project teams. Participates in building strategic model solutions including transformation rules and attribute relationships. This job may 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.

Position Type:


Preferred Qualifications:

  • Ability to assess business needs and formulate feature requirements and test strategies for Agile IT teams and/or GSO report developers

  • Prior experience with Teradata and/or SQL Server

  • Prior experience with QlikView/Sense or similar reporting applications

  • Ability to guide data management conversations with Agile teams

  • Aptitude for data visualization and UX design principles

Education, Work Experience & Knowledge:

  • 4+ years of knowledge and experience using SQL against multiple data sources preferred

  • Firm understanding of relational database design

  • Ability to identify and propose cost effective solutions to enhance data quality

  • General knowledge of Data Management and Information Delivery practices and processes

Physical Requirements:

Operates standard office equipment. Requires extended periods of computer use. Requires extended periods of sitting.

Minimum Qualifications:

4 years analytics experience required.

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.

Licensing or Certificates:

IDMA, IQCP, or CPCU preferred.

Primary Location:

Hartford - Connecticut - United States

We are committed to valuing the diversity that exists among our workforce, our business partners, our customers and our communities. With respect to our workforce, we are committed to not only increasing diversity in our hiring at all levels but also fostering an inclusive environment where all employees, regardless of race, color, religion, gender, gender identity, age, national origin, disability, veteran status, marital status, sexual orientation, genetic information or any other status or condition protected by law, can develop and thrive.