Contact Us
Home | Overview | Open Positions | Benefits | EEO Policy | Our Mission

ETL Developer Position at Meadowbrook:

 

Click to send your Resume for the position: ETL Developer

Post Date  6/7/2013
City  Westerville
State  OH
Work Location  
Department  
Reports To  As assigned by Branch
Summary  

CENTURY INSURANCE GROUP, Inc. (a division of Meadowbrook Insurance Group, Inc. ) (NYSE:MIG) is a publicly traded company that employs approximately 1100 associates in 26 offices throughout the United States and Bermuda.  Meadowbrook operates insurance agencies, a risk management company that provides services to self-insured groups, funds and pools, and operates 4 domestic and 1 foreign insurance company.  We are currently looking for a full time ETL Developer to join our Westerville, OH branch office.

The ETL Developer will be responsible for the scripts required to extract, transform and move data and metadata so they can be loaded into a data warehouse or operational data store.  This position is requires experience in the full systems development lifecycle including, analyzing business requirements, designing technical specifications, development, testing and implementing solutions using ETL tools and techniques.

Essential Functions  

KEY RESPONSIBILITIES 

  • Performs independently under general supervision using established software tools
  • Work with business requirements analyst to identify and understand source data systems
  • Map source system data to data warehouse models
  • Develop and test extraction, transformation, and loading (ETL) processes
  • Define and capture metadata and rules associated with ETL processes
  • Adapt ETL processes to accommodate changes in source systems and new business user requirements
Requirements  

KEY SKILLS 

  • Understand source and target data structures, ETL processes, and products
  • Strong problem-solving and metadata skills
  • Experience with SQL Server Integration Services (SSIS) or Data Transformation Services (DTS)
  • Insurance and/or accounting experience preferred

 

 

KEY DELIVERABLES 

  • Complete mapping and transformation programs
  • Schedules extraction and load processes
  • ETL metadata documented and maintained in metadata repository
  • Database loadable files
Submit Your Resume
Contact: Human Resources
26255 American Drive
Southfield, MI 48034-6112
Fax: (248) 281-5309