Data Engineer

Berkley•Urbandale, IA

About The Position

The Data Engineer will be providing data development at a moderately complex level such as ETL, SSIS jobs, 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. Demonstrates a robust understanding of all business data processes/processing for a system, and the related data structures. Can produce significant new system functionality or defect resolution with minimal direction. Creates design specifications that demonstrate an understanding of most interfacing systems and supported business processes. Routinely proposes improvements to a data process and/or structure to improve supportability or usability. Can perform adequate peer review on any changes in the system. Can be consulted to provide recommendations to solve business issues based on experience and knowledge of current technology. Demonstrates understanding of data processes and/or structures. Will be required to communicate with employees primarily up to the mid-level within both company and client companies. May provide mentorship to others. May begin to 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

5 – 10 yrs SQL experience creating complex queries, stored procedures, and functions
5 + yrs experience with ETL technologies such as Visual Studio, SSMS, or others
Experience building data pipelines and improving efficiencies in data quality and reliability
Experience writing data for, building, and maintaining reports using PowerBI, OBIEE (Oracle BI tools), or other reporting tools
Experience testing ETL solutions from end-to-end and implementing error handling solutions
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.
Excellent problem-solving skills and critical thinking
Ability to quickly adapt and learn new technologies.
Ability to work independently.
Strong customer and business focus.
Bachelors Degree in Computer Science, Information Technology, Information Systems, or a related discipline. Equivalent experience and/or alternative qualifications will be considered.

Responsibilities

ETL
SSIS jobs
Adhoc and management reporting
Dashboard and data extract creation
Analyzing, designing and coding solutions for rapidly growing companies supporting the property & casualty insurance industry.
Demonstrates a robust understanding of all business data processes/processing for a system, and the related data structures.
Can produce significant new system functionality or defect resolution with minimal direction.
Creates design specifications that demonstrate an understanding of most interfacing systems and supported business processes.
Routinely proposes improvements to a data process and/or structure to improve supportability or usability.
Can perform adequate peer review on any changes in the system.
Can be consulted to provide recommendations to solve business issues based on experience and knowledge of current technology.
Demonstrates understanding of data processes and/or structures.
Will be required to communicate with employees primarily up to the mid-level within both company and client companies.
May provide mentorship to others.
May begin to develop sphere of influence with other teams.
Will be required to communicate and coordinate within the team.
May be responsible for on-call rotation.