Solutions & Data Engineer - Team Lead

Company Details

Berkley Oil & Gas, (a W.R. Berkley Company) is an insurance underwriting manager providing unique property and casualty products and risk services to customers engaged in the energy sector.

Our customers recognize the importance of the expertise we provide and appreciate the opportunity to work with professionals who understand their business.

We are in turn committed to delivering innovative products and exceptional service to them, our valued agents and brokers, Berkley Oil & Gas is dedicated in its efforts to be well-informed of the changing dynamics of the industry;

support industry efforts to minimize and mitigate risks and hazards in the 'oil patch', and to constantly seek ways to improve our products and services to meet customer needs.

Company URL : https : / / berkleyoil-gas.com /

The company is an equal opportunity employer.

Responsibilities

This is an exempt staff position involved in data and application development on the IT team. This position will report to and work closely with the AVP of IT and the business to support the strategic vision for bringing together application solutions for underwriting and workflow and data analysis.

Critical thinking and analytical mindset are central for this role.

• Architect and lead the design process related to functions and applications that support workflow in the underwriting department.
• Directly work with IT teams and underwriters to develop, support, and maintain application tools that leverage data structures in the data warehouse.
• Work regularly with underwriting leadership to enhance and fine tune existing applications that are used in rating, quoting, and reporting process.
• Translating business requirement to technical solutions.
• Work with innovation team at BOG to provide guidance and advise on underwriting processes and automation related to application development.
• Work closely with IT data team members to enhance and develop any ETL related to applications that support underwriter tools.
• Manage and lead application projects with underwriting department.
• Answer and support ad-hoc queries by underwriting to facilitate reporting and data analysis.
• Develop and support complex Macro and VBA based Excel tools.
• Develop SQL Server queries.
• Design and develop data structures (i.e. tables, views, procedures) in database related to support and future underwriter tools

Qualifications

• 4 to 8 years Experience in application development and solutions engineering
• 2 to 5 years experience in Insurance Property & Casualty
• 3 to 4 years experience working with Excel Macros
• 3 to 5 years experience developing Visual Basic for Applications
• 2 to 4 years experience in SQL programming (Microsoft SQL Server tools)
• Knowledge and ability to work in JIRA tools.
• Working knowledge of Python, XML parsing and API's
• Working knowledge of enterprise reporting tools like Tableau.
• Technical ability to learn new systems quickly.
• Excellent communication skills (written and oral).
• Detail oriented with good follow-through skills.
• Must be self started and able to collaborate to implement robust business solutions
• Must have ability to lead a project and manage expectations.
• Well versed in phases of software development lifecycle.
• Well versed in Agile or similar methodologies.
• Knowledge of Guidewire suite highly desired.

Education Requirement

Bachelor's degree in Computer Science or related field of study, or equivalent work experience.

Additional Company Details We do not accept any unsolicited resumes from external recruiting agencies or firms.

The company offers a competitive compensation plan and robust benefits package for full time regular employees.

The actual salary for this position will be determined by a number of factors, including the scope, complexity and location of the role;

the skills, education, training, credentials and experience of the candidate; and other conditions of employment. Sponsorship Details Sponsorship not Offered for this Role