Senior Data Engineer

Berkley•Urbandale, IA

About The Position

This Sr. Data Engineer will be providing data development at an advanced complexity level such as ETL, cube creation, adhoc and management reporting, dashboard and data extract creation. This individual will work within a team environment that provides data resource development and support for several companies. They will be responsible for analyzing, designing and coding solutions for rapidly growing companies supporting the property & casualty insurance industry. Requires an in depth understanding of insurance related reporting and insurance company operations Demonstrates a robust understanding of all the business data processes/processing, system interfaces, and where/how that data is used, and the related data structures Design and implementation of ETL process, data structure and the analytical/operational reporting environment Can design significant new system functionality with a consideration of performance, stability, and supportability Thorough understanding of industry best practices. Includes but not limited to modeling, workflow and presentation Design and implement data extracts both inbound and outbound for internal and external sources Requires strong organizational and communication skills Demonstrates problem-solving skills that span the application, middleware, and infrastructure levels - thorough upstream/downstream impact analysis Assists in defining standards and design patterns/paradigms for data processes and/or structures for development within a team Provides guidance on BTS development standards and quality expectations to BTS or company resources entering the job family Demonstrates understanding of data processes and/or structures Will be required to communicate directly with employees at all levels up to the senior level, within company and client companies Will provide mentorship to others Will develop sphere of influence with other teams Will be required to communicate and coordinate within the team May be responsible for on-call rotation Some travel required up to 20%

Requirements

Requires an in depth understanding of insurance related reporting and insurance company operations
Demonstrates a robust understanding of all the business data processes/processing, system interfaces, and where/how that data is used, and the related data structures
Can design significant new system functionality with a consideration of performance, stability, and supportability
Thorough understanding of industry best practices. Includes but not limited to modeling, workflow and presentation
Requires strong organizational and communication skills
Demonstrates understanding of data processes and/or structures
Will be required to communicate directly with employees at all levels up to the senior level, within company and client companies
10 + years - reasonable single system / single technology knowledge
10 + years SQL experience. (queries, stored procedures, functions)
Must have demonstrated the capability of meeting the key accountabilities, or have the ability to learn/perform them
A self-motivated individual with a passion for success
Needs to be able to determine how changes impact customer and other systems
Excellent communication and organizational skills
Ability to work in a fast-paced team environment
Ability to quickly adapt and learn new technologies
Ability to work independently
Strong customer and business focus
Behavioral Core Competencies Technically Astute Managing Information Customer Service Oriented Business Knowledge Influential Conceptual Thinking
Bachelor’s degree with emphasis in related field or equivalent experience.

Responsibilities

Providing data development at an advanced complexity level such as ETL, cube creation, adhoc and management reporting, dashboard and data extract creation.
Work within a team environment that provides data resource development and support for several companies.
Responsible for analyzing, designing and coding solutions for rapidly growing companies supporting the property & casualty insurance industry.
Design and implementation of ETL process, data structure and the analytical/operational reporting environment
Design and implement data extracts both inbound and outbound for internal and external sources
Demonstrates problem-solving skills that span the application, middleware, and infrastructure levels - thorough upstream/downstream impact analysis
Assists in defining standards and design patterns/paradigms for data processes and/or structures for development within a team
Provides guidance on BTS development standards and quality expectations to BTS or company resources entering the job family
Will provide mentorship to others
Will develop sphere of influence with other teams
May be responsible for on-call rotation