VBA Developer - VC5 Consulting

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

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