Senior ETL Developer

Berkley MidAtlantic Group LLC   •  

Greensboro, NC

Industry: Accounting, Finance & Insurance

  •  

5 - 7 years

Posted 157 days ago

This job is no longer available.

Key Risk, a member of Berkley Insurance Company, is a leading provider of workers compensation insurance products and services for employers throughout the eastern United States. With a sole focus on workers compensation, Key Risk works with Key Alliance agents, insurance clients, self-insured employers, and the injured workers they support to create solutions specific to their needs. Enriching each client's risk management strategies, Key Risk creates and executes comprehensive solutions proven to protect people, support business, and exceed expectations.

Committed to delivering better outcomes and industry leading service, Key Risk operates from headquarters in Greensboro, NC and through regional offices and territory-dedicated staff in the states of Pennsylvania, Maryland, Virginia, North Carolina, South Carolina, Tennessee, Alabama and Georgia. This regional approach provides agents and clients with the benefit of working with experts who have first-hand knowledge of the local workers compensation market.

Key Risk is committed to fostering a professional work environment for all its employees. Through an ongoing commitment to innovation, continuous improvement and education, Key Risk attracts and retains associates with a unique blend of workers compensation expertise and a passion for excellence. We are proud to have been recognized among Business Insurance's Best Places to Work in 2009, 2011, 2015, and most recently in 2017.

Responsibilities

Key Risk is looking for a skilled candidate with deep experience on the Microsoft SSIS stack. This role requires hands on expertise designing high volume repeatable ETL processes for large enterprise software and solutions developing very complex data transformations.

Principle Responsibilities:

  • Responsible for the design, development and support of ETL (Extraction, Transformation and Loading) components, which will be used to move large amounts of data from source data and software application data stores into the optimized operational databases
  • Tuning the ETL processes
  • Creation of the technical and system specification documents necessary to support ETL processes
  • Participate in development and execution of unit and system test plans

Qualifications

Qualifications:

  • Bachelors Degree in Computer Science preferred or comparable work experience min of 5 years in an IT role.
  • Minimum 5 years full life cycle software development experience
  • Minimum 5 years of experience in SQL Server T-SQL database development (data modeling, stored procedures, functions and query optimization)
  • Minimum 3 years of experience in SSIS Packages and ETL development
  • Minimum 3 years of experienceworking with a data warehouse and understanding of data warehousing concepts
  • Excellent troubleshooting skills
  • Ability to translate complex business requirements into technical solutions
  • Desire and ability to clearly communicate with colleagues at all levels
  • Ability to create complex, high performance stored procedures in SQL Server 2012/2016
  • Ability to create complex SSIS Packages using SSIS 2012/2016
  • Experience in working in an Agile team
  • Experience in database-related performance tuning
  • Working knowledge in data modeling
  • Experience in DB2 databases
  • Experience with Pentaho Data Integration is a plus
  • Business Analystexperiencepreferred but not required
  • Able to successfully complete tasks with limited supervision

2019-2221