Berkley
Senior Data Engineer
Berkley, Urbandale, Iowa, United States, 50322
Company Details
Company URL: https://www.berkleytechnologyservices.com/
Berkley Technology Services (BTS) is the dynamic technology solution for W. R. Berkley Corporation, a Fortune 500 Commercial Lines Insurance Company. With key locations in Urbandale, IA and Wilmington, DE, BTS provides innovative and customer-focused IT solutions to the majority of WRBC’s 60+ operating units across the globe. BTS’s wide reach ensures that ideas and opinions are considered at every level of the organization to guarantee we find the best solutions possible.
Driven by a commitment to collaboration, BTS acts as consultants to our customers and Operating Units by providing comprehensive solutions that not only address the challenge at hand, but proactively plan for the “ What’s Next ” in our industry and beyond.
With a culture centered on innovation and entrepreneurial spirit, BTS stands as a community of technology leaders with eyes toward the future -- leaders who truly care about growing not only their team members, but themselves, and take pride in their employees who shine. BTS offers endless ways to get involved and have the chance to grow your career into a wide range of roles you'd never known existed. Come join us as we push forward into the future of industry leading technological solutions.
Berkley Technology Services: Right Team, Right Technology, Simple and Secure.
Responsibilities Join Our Innovative Insurance Data Team!
We’re looking for a
Senior Data Engineer
with a deep understanding of insurance reporting and company operations. If you have a knack for mastering business data processes, system interfaces, and data structures, this is the role for you!
In this position, you’ll be tackling advanced tasks like ETL, cube creation, ad-hoc and management reporting, and crafting eye-catching dashboards and data extracts. You’ll be part of a vibrant team that supports multiple companies, providing top-notch data resources and development.
Your mission includes analyzing, designing, and coding innovative solutions for fast-growing companies in the Property & Casualty insurance industry. Get ready to make a big impact and have some fun along the way!
Design & Implement:
Create and manage ETL processes, data structures, and both analytical and operational reporting environments.
Innovate:
Develop new system functionalities with a focus on performance, stability, and supportability.
Lead by Example:
Apply industry best practices in modeling, workflow, and presentation.
Extract & Integrate:
Design and implement data extracts for both internal and external sources.
Organize & Communicate:
Utilize your strong organizational and communication skills to keep everything running smoothly.
Solve Problems:
Tackle challenges across application, middleware, and infrastructure levels with thorough impact analysis.
Set Standards:
Help define standards and design patterns for data processes and structures within the team.
Guide & Mentor:
Provide guidance on development standards and quality expectations, and mentor new team members.
Collaborate:
Communicate effectively with employees at all levels, both within the company and with clients.
Influence:
Develop a sphere of influence with other teams and foster a collaborative environment.
Be On Call:
Participate in on-call rotations to ensure smooth operations.
Travel:
Enjoy occasional travel, up to 20%.
Qualifications
SQL Maestro
:
7+ years of experience with SQL and ETL processes, including crafting queries, stored procedures, jobs, functions, synonyms, and aliases.
Experience with SQL Environments and variables, version control, and execution plans. Extensive experience with ETL tools (SSIS or similar) and optimizing performance.
Proven Performer:
Demonstrated ability to meet key accountabilities or the drive to learn and excel in them.
Passionate Go-Getter:
A self-motivated individual with an unyielding passion for success.
Impact Analyst:
Skilled at understanding how changes affect customers and other systems.
Communication Pro:
Excellent communication and organizational skills to keep everything on track.
Team Player and Mentor:
Thrives in a fast-paced team environment and loves to train and mentor junior staff on best practices and enhancing solution designs.
Tech Enthusiast:
Quick to adapt and eager to learn new technologies.
Independent Worker:
Capable of working independently with minimal supervision.
Customer Champion:
Strong focus on customer and business needs.
Behavioral Core Competencies
Technically Astute
Managing Information
Customer Service Oriented
Business Knowledge
Influential
Conceptual Thinking
The Company is an equal employment opportunity employer.
Company URL: https://www.berkleytechnologyservices.com/
Berkley Technology Services (BTS) is the dynamic technology solution for W. R. Berkley Corporation, a Fortune 500 Commercial Lines Insurance Company. With key locations in Urbandale, IA and Wilmington, DE, BTS provides innovative and customer-focused IT solutions to the majority of WRBC’s 60+ operating units across the globe. BTS’s wide reach ensures that ideas and opinions are considered at every level of the organization to guarantee we find the best solutions possible.
Driven by a commitment to collaboration, BTS acts as consultants to our customers and Operating Units by providing comprehensive solutions that not only address the challenge at hand, but proactively plan for the “ What’s Next ” in our industry and beyond.
With a culture centered on innovation and entrepreneurial spirit, BTS stands as a community of technology leaders with eyes toward the future -- leaders who truly care about growing not only their team members, but themselves, and take pride in their employees who shine. BTS offers endless ways to get involved and have the chance to grow your career into a wide range of roles you'd never known existed. Come join us as we push forward into the future of industry leading technological solutions.
Berkley Technology Services: Right Team, Right Technology, Simple and Secure.
Responsibilities Join Our Innovative Insurance Data Team!
We’re looking for a
Senior Data Engineer
with a deep understanding of insurance reporting and company operations. If you have a knack for mastering business data processes, system interfaces, and data structures, this is the role for you!
In this position, you’ll be tackling advanced tasks like ETL, cube creation, ad-hoc and management reporting, and crafting eye-catching dashboards and data extracts. You’ll be part of a vibrant team that supports multiple companies, providing top-notch data resources and development.
Your mission includes analyzing, designing, and coding innovative solutions for fast-growing companies in the Property & Casualty insurance industry. Get ready to make a big impact and have some fun along the way!
Design & Implement:
Create and manage ETL processes, data structures, and both analytical and operational reporting environments.
Innovate:
Develop new system functionalities with a focus on performance, stability, and supportability.
Lead by Example:
Apply industry best practices in modeling, workflow, and presentation.
Extract & Integrate:
Design and implement data extracts for both internal and external sources.
Organize & Communicate:
Utilize your strong organizational and communication skills to keep everything running smoothly.
Solve Problems:
Tackle challenges across application, middleware, and infrastructure levels with thorough impact analysis.
Set Standards:
Help define standards and design patterns for data processes and structures within the team.
Guide & Mentor:
Provide guidance on development standards and quality expectations, and mentor new team members.
Collaborate:
Communicate effectively with employees at all levels, both within the company and with clients.
Influence:
Develop a sphere of influence with other teams and foster a collaborative environment.
Be On Call:
Participate in on-call rotations to ensure smooth operations.
Travel:
Enjoy occasional travel, up to 20%.
Qualifications
SQL Maestro
:
7+ years of experience with SQL and ETL processes, including crafting queries, stored procedures, jobs, functions, synonyms, and aliases.
Experience with SQL Environments and variables, version control, and execution plans. Extensive experience with ETL tools (SSIS or similar) and optimizing performance.
Proven Performer:
Demonstrated ability to meet key accountabilities or the drive to learn and excel in them.
Passionate Go-Getter:
A self-motivated individual with an unyielding passion for success.
Impact Analyst:
Skilled at understanding how changes affect customers and other systems.
Communication Pro:
Excellent communication and organizational skills to keep everything on track.
Team Player and Mentor:
Thrives in a fast-paced team environment and loves to train and mentor junior staff on best practices and enhancing solution designs.
Tech Enthusiast:
Quick to adapt and eager to learn new technologies.
Independent Worker:
Capable of working independently with minimal supervision.
Customer Champion:
Strong focus on customer and business needs.
Behavioral Core Competencies
Technically Astute
Managing Information
Customer Service Oriented
Business Knowledge
Influential
Conceptual Thinking
The Company is an equal employment opportunity employer.