Business Intelligence Designer Job

Job Title: Business Intelligence Designer
Job ID: 791611
Location: CT-Hartford

Available Openings: 1

Committed. Competitive. Constructing our Future.

That's Travelers. We are one of the leading insurance companies in the United States. 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.

Job Summary:

The primary function of the business intelligence designer is to provide overall business intelligence design direction that supports the development and implementation of the enterprise data warehouse and associated data marts within the Management Information area of Personal Lines. These initiatives target improved business value through data acquisition and data presentation to the business community via business intelligence tools which support business analytics and decision making functions. These initiatives include highly complex concurrent projects. This position is responsible end to end business intelligence design from data acquisition through data presentation. This position requires direct and active involvement in ETL design, business intelligence application design, and code level development processes. The business intelligence designer will be required, based on the assignment, to write and test code to support prototypes, code reviews, and performance efforts within the MI arena. The business intelligence designer will deliver design documents which can be shared across the business, application development and quality assurance organizations. The individual must be able to effectively communicate with business representatives, in their terminology, using both verbal and written skill sets. This position requires a 'hands on' approach which will utilize both a detailed code level expertise and a broad perspective on application solutions in the MI space in order to provide business intelligence functionality to the business.

Primary Duties:

Provide designs and code, as needed, to meet specific to data warehouse application requirements.
Ensure that designs are consistent with Personal Insurance architecture guidelines through blueprint and design reviews
Assist in the assessment of application stability and performance through code level reviews
Adopt and communicate new concepts, ideas, techniques, and best practices specific to the MI tool portfolio
Perform project level design, data analysis and application performance analysis
Responsible for the design of enterprise data warehouse application utilities including best practices and guidelines for supported technologies

Provide technical expertise in the following areas (dependent on knowledge and expertise):

Primary Skills:

Excellence in verbal, written communications, presentations and technical documentation
Data analysis and interpretation
Business intelligence tools (Cognos, MicroStrategy, SAS)
Data warehouse concepts and design including active data warehousing techniques
ETL tools including Ab Initio ( preferred ), Informatica and Data Stage
RDBMS including TeraData ( preferred), UDB DB2, Oracle, SQL Server with a heavy emphasis on SQL coding expertise
Unix/Linux shell scripting (k-shell)
ETL design
Data modeling
Database design covering both star schema and third normal form implementations
Meta data, including data types, XML, fixed and variable record layouts

Secondary Skills:

Coding Languages: Java, C#, C++, COBOL
WEB Technologies
Development platforms (.NET, J2EE, COM)
Application Integration
Middleware technologies
Component Based Design
Operating Systems
Performance Engineering
Networks

Competencies:

Technical Knowledge
Demonstrated coding expertise in SQL, detailed ETL tool coding experience, and significant first hand BI tool development experience. Demonstrates a broad conceptual understanding of the capabilities business intelligence technologies. Specific technical knowledge and experience with ETL tools and ETL design in a multi-terabyte data environment. Fundamental understanding of performance issues in both ETL tools, databases and business intelligence tools. Ability to provide integrated, end to end business intelligence designs. Demonstrated ability to clearly articulate technical designs, issues and resolutions in verbal and written communications.

Problem Solving & Decision Making
Demonstrates advanced analytical and diagnostic skills dealing with issues that are often novel and not readily defined, lack known precedent or appear contradictory. Able to develop solutions by applying accepted processes or creating new approaches to leverage technology from abstract information. Sees the big picture, and is fully aware of technology and business directions. Has department, corporate and group objectives in focus while identifying and removing barriers. Optimizes the use of all available resources. Bases decisions on an accurate understanding of the situation, is able to infer future needs of known and unprecedented situations based on an advanced understanding of technology and business objectives. Effectively assesses the long-term and short-term implications of decisions on the department, corporation and group

Team Orientation
Maintains partnerships across multiple organizations, and is able to influence senior management, peers and staff through an inclusive style and recognition of their abilities to achieve results. The success of the team is above own interest.

Self-Management
Manages cross-functional objectives and/or priorities supporting assigned business area(s). Responsibilities are assigned with latitude for decision making. Results reviewed periodically according to predefined objectives. Sets level of risk taking, and gathers/synthesizes information to all appropriate levels of the organization.

Commitment to Quality Results
Provides direction and effectively leads by example to ensure that all services are meeting the stated business objectives on a timely basis with excellent quality, at a reasonable cost. Keep all areas informed of developments affecting their functions. Demonstrates flexibility, anticipates customer needs, and effectively communicates in a manner consistent with the audience. Educates and influences customers on the most effective use of technology, from both a short-term and long-term perspective.

Planning and Project Management
Ensures all planning done on a project level is supportive of the business strategic plans. Completes tasks accurately and on time. Critical planning is required as modifications are difficult and costly and may impair achieving of departmental and corporate objectives. Reassesses and adjusts tactical and/or operational direction as business requirements change and evolve.

Financial Awareness
Understands fiscal budgeting and expense control for area of responsibility. Demonstrates sound, cost-effective design decisions.

Experience:
5+ years in business intelligence design focused on enterprise data warehouse solutions
10+ years of hands on data warehouse development
Experience managing the application delivery process.
Minimum of 3 years experience in project management.
Experience working in a matrixed organization.

Travelers is an equal opportunity employer. We actively promote a drug-free workplace.

Nearest Major Market: Hartford
Job Segments: Business Intelligence, Defense, Government, Technology