Data Integration Director

The Travelers Companies Hartford, CT
Primary Job Duties & Responsibilities

Directs assigned staff to implement and/or maintain systems of medium to high complexity and/or assigned project(s). Manages to the tactical and operational plan and budget for assigned information systems and/or projects of business unit significance. Provides input to the Senior management team on the development of the operational plan. Advocates the use of technology to develop and/or redesign the organization's processes. Understands cost benefit analysis as the key driver for enhancement and/or project prioritization. Has awareness of Enterprise strategies and impact on the line of business or functional area of responsibility. Provides key project stakeholders and IT leadership with timely status updates and/or system performance updates. Applies knowledge of current industry trends and techniques to formulate solutions within the context of assigned projects and/or enhancements. Accountable for directing team to achieve deliverables.

Job Specific & Technical Skills & Competencies

Technical Knowledge

Has a solid working knowledge of capabilities and direction of technology, coupled with an in-depth knowledge of the technology required and the needs of business environment necessary to support assigned systems and/or projects. Develops solutions to meet business needs that reflect a clear understanding of the objectives, practices and procedures of the corporation, department and business unit. Has thorough understanding of staff responsibilities, abilities and development needs.

Business Knowledge & Partnership

Creates an atmosphere where business partner's issues are dealt with professionally and in a timely manner. Suggests solutions that make sense and are in line with future technology direction. Communicates openly and effectively in a manner consistent with the audience. Demonstrates an adaptive style that is flexible and effective in gaining cooperation of others.

Problem Solving & Decision Making

Demonstrates sound analytical and diagnostic skills dealing with issues that are not readily defined and/or conflict with available information. Knows where to obtain information needed to make the appropriate decisions. Breaks a problem down to manageable pieces and implements effective, timely solutions. Is very good at identifying the problem versus the symptom. Deals increasingly with problems that require involvement of others to solve. Has the ability to reach sound decisions quickly. Carefully evaluates alternative risks and solutions before taking action. Optimizes the use of all available resource.

Team Orientation

Maintains effective partnerships across the organization and is able to influence senior management, peers and subordinates through an inclusive style and recognition of their abilities and knowledge. Balances team and individual responsibilities. Exhibits objectivity and openness to others' views. Gives and welcomes feedback. Puts success of team above own interest.


Manages functional objectives and priorities supporting multiple assigned business units. Responsibilities are assigned with latitude for setting priorities and decision-making using generally accepted guidelines. Results are reviewed with next level manager for clarification according to predefined objectives.

Planning and Project Management

Develops operational plans and provide task resource estimation planning. Proposes action plans that are timely, realistic and positive. Sets appropriate goals for the area and monitors progress against the plan. Delegates to maximize organizational effectiveness.

Financial Awareness

Has budget responsibility for an organizational unit of 5 to 25 employees and/or a budget of between $1M and $10M. Develops a portion of an overall divisional budget subject to review and is responsible for expense control for the units assigned. Demonstrates sound cost-effectiveness. Failure to achieve objectives can result in delays or inefficiencies resulting in readjustment of resources and/or staff. Responsible for important and confidential information.

Human Resource Management

Demonstrates good interpersonal skills by displaying an understanding of the needs and perspective of others. Able to balance the workload of team members and supervise individuals of varying abilities. Able to identify the talents of others and match them to the tasks that will best suit the area goals and/or provide growth for the individual. Able to assess and identify employee skill development needs and put together a training program for the individual. Responsible for the accurate and timely completion of staff performance evaluations and development planning. Recruits and retains effective staff members. Demonstrates a capacity to recognize, value and respect differences across a diverse work force.

Job Summary

This is an opportunity to join the Personal Insurance Business Technology – Business Intelligence & Analytics Team (PIBT BI&A). The person hired will perform as a manager and lead of Data Integration and software development teams and will lead teams in various technologies and platforms including Ab Initio, .Net, Teradata, and Hadoop.

Individual will need to participate in project planning and initiation, architectural decisions, technical design, and implementation of Business Intelligence systems. Direct, mentor, and lead the work of Developers with a strong focus on delivery and execution on a daily basis.

Education, Work Experience & Knowledge

* Minimum 5 years of experience managing and delivering Data warehouse/Data Integration/Business Intelligence projects.

* Hands on Software development experience in Data Warehouse/Data Integration/Business Intelligence domain.

* Experience managing technical teams

* Experience and in-depth knowledge of the full suite of Ab Initio tools including GDE, EME, BRE, Express>It, Conduct>It, Data Profiler, and Metadata Hub

* Experience in one or more ETL/Data Integration platforms

* Hands on experience with .Net, Pivotal Cloud Foundry (PCF), and deploying applications to the cloud

* Hands on experience in one or more Database platforms (Teradata experience a plus)

* Hands on experience and proficiency with Unix/Linux and Korn shell scripting

* Hands on experience with Big Data/Hadoop. Working knowledge of HIVE, Java, Python, and/or MapReduce

* Strong knowledge, use, and implementation of BI/DW development methodologies, standards and best practices.

* Extensive experience with Agile practices (Kanban, Scrum, or Extreme Programing)

* Willingness to be a coach and mentor to more junior staff members

* Planning at an operational level and managing the effective use of resources. Solid project management skills and leadership of assigned staff

* Strong financial awareness making sure our department, software, hardware, and projects are within budgets

* Demonstrate strong people, communication and relationship management skills

* Experience in working with external IT vendors in a staff augmentation and/or project collaboration models with large offshore teams

* Coordination of large deliverables across various supporting IT areas including SA, QA, Project Management, and Architecture

* Working with other BI&A leaders across the enterprise to share and leverage Business Intelligence knowledge

* Experience in developing and leveraging metrics to track and report progress of ongoing support and project initiatives

Minimum Qualifications

High School diploma or equivalent required. 5 years of technology or business related experience required.