Data Analyst I

Verus Specialty Insurance (a Berkley Company); Englewood (CO); On-site; USD 65,000 - 75,000; Full time

Benefits offered by this job

Health plan

Dental plan

Vision plan

Life insurance

Disability insurance

Wellness program

Paid Time Off

401(k) with Profit Sharing

Job summary

Verus Specialty Insurance, a Berkley company, is seeking a data-focused analyst to support underwriting through fast data extraction and robust reporting. You will develop and maintain dashboards and reports using Excel and Power BI, collaborating with actuarial and underwriting teams to drive profitability.

The role requires 2+ years in a data-related position, strong Excel/VBA/SQL skills, and a willingness to travel occasionally.

Qualifications

• 2+ years of experience in a data-related role with working knowledge of information systems.
• Bachelor’s degree in mathematics, business, finance, or technical field.
• Strong knowledge of MS Office tools (Excel, Outlook, Word, PowerPoint).
• Strong knowledge of VBA, SQL; Power BI experience preferred.
• Ability to adapt and communicate effectively.
• Willingness to travel occasionally.

Responsibilities

• Develop queries and reports for actuarial department and executive team as requested.
• Work with internal data systems to support data-driven changes or problem solving across the organization.
• Help manage transition from legacy systems to more efficient systems and solutions.
• Identify and analyze information needs and flow for design, development, and maintenance.
• Construct reports in Excel and Power BI that aid Underwriting in profitability and growth decisions.
• Develop and maintain Financial Planning, Budgeting, and Forecasting visuals.

Skills

SQL

VBA

Excel

Power BI

Education

Bachelor's degree in related field

Tools

MS Office

Job description

Company Details

At Verus Specialty Insurance, a proud member of the esteemed W.R. Berkley Corporation (NYSE: WRB), we stand as a leading Excess and Surplus Lines provider delivering comprehensive solutions across the United States. Backed by the formidable strength of a Fortune 500 titan and operating with the agility of a nimble startup, we blend the best of both worlds to foster innovation and excellence in everything we do.

At Verus Specialty Insurance, a proud member of the esteemed W.R. Berkley Corporation (NYSE: WRB), we stand as a leading Excess and Surplus Lines provider delivering comprehensive solutions across the United States. Backed by the formidable strength of a Fortune 500 titan and operating with the agility of a nimble startup, we blend the best of both worlds to foster innovation and excellence in everything we do.

Our nationwide operations are supported by a robust network of select wholesale producers, ensuring that our reach and capabilities are always close at hand. We are driven by a forward-thinking leadership that champions a dynamic culture where questioning the norm is not just welcomed but expected. This ethos empowers our team to consistently surpass customer expectations and drive the industry forward.

At Verus, we are more than just a company; we are a community that thrives on collaboration, growth, and taking ownership of our actions. We are constantly on the lookout for exceptional talent who are eager to contribute, innovate, and grow with us. If you are passionate about making a mark in the insurance industry and align with our vision, we eagerly await your application. Join us and be a part of a team where your contributions are valued, and your potential fully realized!

The Company is an equal employment opportunity employer.

https://www.verusins.com/

Responsibilities

To support the underwriting function by inputting information quickly and accurately from a variety of sources including incoming applications into Verus core systems and setting them up in the workflow, providing excellent customer service.

Key Functions/Duties Of Position

• Develop queries and reports for actuarial department and executive team as requested.
• Strong knowledge of internal data systems in order to be a relied upon resource for data-driven changes or problems across the organization.
• Help manage transition from legacy systems into more efficient systems and solutions.
• Identify and analyze information needs and flow for design, development, and maintenance.
• Construct reports within Microsoft Excel and Power BI that aid Underwriting in making correct strategic decisions in reaching profitability and growth goals.
• Develop and maintain Financial Planning, Budgeting, and Forecasting visuals.
• Analyzes complex business problems and issues using data from internal and external sources to provide insight to analysts and decision makers.

Qualifications

• 2+ years of experience in a data-related role with working knowledge of information systems.
• Bachelor’s degree in a related field (mathematics, business, finance, technical).
• Required: Strong knowledge of MS Office tools (Excel, Outlook, Word, PowerPoint).
• Required: Strong knowledge of VBA.
• Required: Strong knowledge of SQL.
• Preferred: Intermediate knowledge of Power BI.
• Preferred: Knowledge of the insurance industry and IT systems.
• Preferred: Intermediate knowledge of R and Python.
• Ability to adapt.
• Strong problem solving and communication skills.
• Strong organization skills and ability to multitask and prioritize multiple tasks at once.
• Ability to work outside normal work schedule to fulfill responsibilities.
• Ability to travel on an occasional basis.
• Reasonable, regular, and predictable attendance.

Additional Company Details

We do not accept any unsolicited resumes from external recruiting firms.

The company offers a competitive compensation plan and robust benefits package for full-time regular employees which for this role includes:

Base Salary Range: $65,000 - $75,000

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.

Eligible to participate in the annual discretionary bonus program

• Benefits: Health, Dental, Vision, Life, Disability, Wellness, Paid Time Off, 401(k) and Profit-Sharing plans.

Additional Requirements

The application window for this role is estimated to be open through August 31, 2026, but may be extended, if necessary.

Sponsorship Details

Sponsorship not Offered for this Role