Database Specialist Job in Hartford, Connecticut US

Database Specialist

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. Job description: Reinsurance IT has been implementing a series of projects based upon a Reinsurance business strategic roadmap. A majority of those strategic projects are data-driven, sharing common data repositories such as Operational Data Store (ODS)/Data Warehouse etc, which source data from numerous transactional application databases. Data from there flow to multiple destinations such as data marts/Management Information reporting environments etc. We are looking for a strategic data analyst/data strategist who will master the various data flows for all the data in and out of those operational data store/data warehouse/data marts/MI environments, understand data extract/transformation/load mechanisms, serve as a data SME for the projects. In addition, the incumbent for this position will adhere, advocate and contribute to a consistent data vision/plan in order to deliver data to customers in a timely and flexible manner with high data accuracy. PRIMARY DUTIES: Transforms business specifications into cost-effective information systems applications through resource plans and prioritizes work within established budget objectives Provides the project manager/supervisor with timely and accurate information regarding the performance of the assigned projects(s) Builds and leverages effective alliances across the technical and business community ensuring the best utilization of resources Responsibilities include: 1) Serve as a data SME for data projects in Reinsurance IT (ODS, in particular); 2) Assist in formulating/defining Reinsurance data strategy. Be an advocate for a consistent data planning; 3) Ensure that data manipulation for on-going projects adhere to consistent data strategies concerning the following: ¿ Data quality such as defining and eliminating dirty data; ¿ Data transformation; ¿ Target state of data model (such as Relational versus Dimensional); ¿ Performance; Etc. 4) Translate data elements in business requirements into an effective data design in ODS/data warehouse databases; 5) Be responsible for educating/assisting peer developers as well as business analysts and customers to resolve data issues; 6) Act as a data accuracy gatekeeper for all Cognos reports/MSAS cubes produced by Reinsurance IT; 7) Document the data extracting/loading mapping processes; document the data transforming processes; document the data relationships and maintaining the consistency of the data; OTHER: Technical Knowledge Has master level knowledge of multiple programming disciplines and a thorough understanding of the business that the assigned projects are supporting. Uses this understanding of the business and systems environment to develop appropriate and timely solutions to daily issues. Has conceptual knowledge of varying technologies and the ability to make decisions based on that knowledge 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 optimize the value of assigned projects. Communicates openly and effectively in a manner consistent with the audience. Recognizes the importance of superior quality in providing a competitive edge. Ensures that reports are precise, timely and accurate Problem Solving Decision Making Demonstrates sound analytic and diagnostic skills dealing with issues that are loosely defined and/or where information is available but must be further manipulated. Once decisions are made, is able to follow and direct action to implement intended results. Breaks a problem down to manageable pieces and implements effective, timely solutions. Openly and directly confronts conflict until resolved Team Orientation Builds relationships with peers and other departments to achieve objectives, to work as one team and to secure necessary resources not under his/her personal control. Balances team and individual responsibilities. Exhibits objectivity and openness to others views. Gives and welcomes feedback. Puts success of team above own interest Leadership Supports a distinct business unit or several smaller functions. Responsibilities are assigned with some latitude for setting priorities and decision-making using established policies and procedures. Results are reviewed with next level manager for clarification and direction before proceeding Planning and Project Management Works with the project manager/manager in identifying those project tasks that are most important, establishes clear priorities and understands the larger picture. Anticipates and effectively responds to changes in workload and resources Financial Awareness Understands, has input to the budget process, and shares responsibility for cost-effective expense control of assigned projects. Is responsible for important and confidential information Job Requirements include: 1) A college degree in management information, computer science, or mathematics is preferred; 2) 2+ years of recent working experiences in data analysis is required; 3) Must be expert in writing SQL queries for analyzing data. Familiarity with Oracle database is preferred; 4) Must be expert in analyzing data relationship and resolving data issues; 5) Familiarity with dimensional data modeling (star schema) is preferred; 6) Data warehousing experience is preferred; 7) Some exposure to data integration tools (such as Ab Initio, Informatica or DataStage etc) and business intelligence tools (such as Cognos, Business Objects, Microstrategy and MSAS etc.) are strongly preferred. 8) Working knowledge in Reinsurance industry is a strong plus; A working experience as business analyst is a strong plus; 9) Must be a good team player, excellent in communication, and able to work in a fast-paced environment. Must have a sense of urgency and be able to deliver results based upon an agreed timeline. Travelers is an equal opportunity employer. We actively promote a drug-free workplace. Apply Apply Add to Favorites