Returning Candidate?

ETL/SSIS Data Integration Developer

ETL/SSIS Data Integration Developer

Job ID 
22084
# Positions 
1
Location 
US-OH-Cincinnati
Posted Date 
11/20/2017
Category 
Technology
Position Type 
Full Time
Travel Percentage 
..

Job Information

Overview

Be Here. Be Great.  Working for a leader in the insurance industry means opportunity for you. Great American Insurance Group, a member of American Financial Group, is a Fortune 500 company consistently recognized as a top place to work.  We combine a "small company" culture where your ideas will be heard with "big company" expertise to help you succeed. With over 30 specialty property and casualty operations and a variety of financial services, there are always opportunities here to learn and grow.

Responsibilities

  • Expand the company’s use of data as a strategic enabler of corporate goals and objectives.
  • Facilitate information gathering sessions and provides data analysis and data mapping. 
  • Work with various customers, prospects and stakeholders, understands and translates business use cases and/or requirements into data models, data integration routines and analytics reports.
  • Identifies data sources, develop and maintain data architectures, constructs data catalog and data decomposition diagrams, provide data flow diagrams and documents the process.
  • Have the ability to facilitate the development of data integration efforts with the development team in addition to hands on design and development of large complex ETL jobs.
  • Develop, manage and maintain data models, including physical and logical models of the data warehouse, data marts, development and staging areas and source systems as necessary to meet new and changing business requirements.
  • Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.
  • Establish methods and procedures for tracking data quality, completeness, redundancy and improvement; and processes for governing the identification, collection and use of corporate metadata to assure metadata is accurate and valid in the business intelligence environments.

Qualifications

  • Hands on ETL development in tools such as SSIS and/or Informatica.
  • Working experiences in design and modeling normalized and dimensional (e.g. star schema) data warehouses.
  • Self-motivated team player who excels in a collaborative environment.
  • Strong sense of accountability, adaptability, flexibility and a sense of urgency.
  • They should have a bias for action and achieving results for themselves as well as their team.
  • Excellent analytic and problem solving skills.
  • Ability to work effectively with associates at all levels within the organization.
  • Demonstrated ability to establish priorities, organize and plan work to satisfy established timeframes.
  • Proven ability to handle multiple tasks and projects simultaneously.
  • Familiar with the Agile Methodology.
  • Excellent analytical skills, attention to detail, and problem-solving skills.
  • Self-motivated team player who excels in a collaborative environment.
  • Strong sense of accountability, adaptability, flexibility and a sense of urgency.
  • They should have a bias for action and achieving results for themselves as well as their team.
  • Passionate about continuously improving organizational practices. Ability to learn and apply new technologies quickly and self-directed.
  • Familiarity and working knowledge of SQL Server Database, SSIS, SSAS, Kalido DIW and Kalido MDM is a plus.

*The job level for this position will depend on the candidate’s experience and skill set. 

Connect With Us!

Not ready to apply? Build your career profile here to connect with us!