Data Engineer

Berkley•Urbandale, IA

16h

About The Position

W.R. Berkley Corporation is comprised of 60+ businesses alongside Berkley Technology Services (BTS) and other shared services groups. Here at Berkley Technology Services, the core of our success is our people . Our teams bring their own unique perspective and experiences which enables us to translate the needs of our business to deliver adaptable, secure solutions while providing an unmatched user-focused experience. Our tagline “ Thoughtful Minds | Empowering Possibilities ” was crafted with our own teams in mind. At BTS, our teams thrive in Berkley’s decentralized model - leveraging the power of being part of a long standing, heritage brand with extensive expertise while innovation and being entrepreneurial is encouraged. Internally, we operate as a relatively flat organization valuing communication and feedback. We pride ourselves in an open-door policy where no one is treated differently based on title, fostering a culture of trust, transparency, and engagement. Mission (what we stand for): We B elieve in the value of every voice, T ranslate needs into capabilities , & S ecure the future of Berkley. Vision (where we’re going): Be the foundation of Berkley through adaptable solutions, resilient environments, and an unmatched experience. Come join us as we push forward into the future of industry leading technological solutions

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

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%.