Business Intelligence Analyst

Berkley Aspire (a Berkley Company); Olde West Chester (OH); Hybrid; USD 70,000 - 90,000; Full time

Job summary

Berkley Aspire (a Berkley Company) in Olde West Chester, Ohio, is seeking a Business Intelligence Analyst. The role involves performing routine business analysis using SQL, supporting business intelligence solutions, and collaborating with internal and external customers to identify analytical requirements. Ideal candidates will have a Bachelor's degree in Computer Science or related field, along with 2+ years of experience in business analysis, SQL proficiency, and data visualization skills. The position offers a dynamic work environment with opportunities for advancement.

Qualifications

• 2+ years of business analysis or related technical experience preferred.
• Working knowledge of data visualization and business intelligence tools.
• Experience with data transformation tools.

Responsibilities

• Perform routine business analysis using SQL.
• Identify analytical requirements based on business requests.
• Provide design support for the development of business intelligence solutions.

Skills

Business analysis

SQL

Data visualization

Database knowledge

Microsoft Excel

Power BI

Education

Bachelor’s degree in Computer Science, Data Science, or Information Systems

Tools

Power BI

SQL

Job description

Company Details

Company URL: www.berkleyaspire.com

Berkley Aspire is an excess & surplus lines insurer of commercial risks unable to find a home in the standard markets. We are an operating unit of WR Berkley, a publicly traded (NYSE “WRB”) global insurer founded in 1967.

We make excess & surplus lines easy – easy for our distribution partners, easy for the businesses they represent, and easy to navigate. The lines of coverage we underwrite include general liability, property, and excess liability. Our model is different than our competitors – we do the premium billing and do not add interest/ finance percentage, we offer enhanced commissions, and we handle the stamping, affidavit filings, and other behind‑the‑scenes paperwork.

Our company culture is entrepreneurial, employee centric, and focused on sustainable growth. Aspire teammates work either remotely or on a hybrid schedule from offices in Scottsdale, Cincinnati, and Richmond. If you are looking for a company that offers room for advancement, great benefits, and positive vibes, then Aspire may be the place for you!

Responsibilities

The Business Intelligence Analyst performs routine business analysis using various techniques including SQL. The analyst researches best practices and supports developing solution recommendations for the current business operations. They work with internal and external customers to identify analytical requirements based on business requests and needs, turning data into critical information and knowledge that can be used to make sound business decisions. They ensure data is accurate, consistent, and reliable for use in diverse systems.

Additional responsibilities:

• Provide design support for the development of business intelligence solutions.
• Work on multiple tasks projects as a team member.
• Participate in the work‑stream planning process including inception, technical design, development, testing and delivery of BI solutions.
• May participate in project management estimation.
• Work with customers and IT partners to develop and analyze business intelligence needs.
• Provide input to business requirements for solution design.
• Identify and provide input to new technology opportunities that impact enterprise‑wide BI systems.
• Design company‑wide “views” and custom reports.
• Perform analysis for a wide range of requests using data in different formats and from various platforms.
• Research business problems and create models that help analyze them.
• Provide input to the development of information quality metrics.Adhere to current standards.
• Design and deliver end‑user training and materials.
• Train users to transform data into action‑oriented information.

Qualifications

May perform other functions as assigned.

• 2+ years of business analysis or related technical experience preferred.
• Working knowledge and experience with data visualization, business intelligence tools, SQL, and databases.
• Experience with data transformation tools and BI tools.
• Experience with Microsoft SQL and Excel essential; experience with Power BI is a bonus.
• Understanding of relational database concepts and data warehousing concepts required.
• Excellent interpersonal skills.
• Bachelor’s degree in Computer Science, Data Science, Information Systems or equivalent work experience.
• Insurance industry knowledge and experience is a bonus.
• Demonstrated accountability for delivering high‑quality work and meeting deadlines.
• Sense of urgency and ability to prioritize tasks in a fast‑paced environment.
• Collaborative mindset; proven ability to work effectively within a team.
• Strong interpersonal communication skills for stakeholder engagement.
• Initiative and proactive approach to challenges and opportunities.

Ideal Candidate

• A proactive self‑starter comfortable working independently.
• Demonstrates strong problem‑solving abilities and a strategic mindset.
• Works effectively within a distributed team environment.

Berkley Core Competencies

• Accountability
• Communication
• Customer Focus and Teamwork
• Flexibility
• Innovation and Initiative

This company is an equal opportunity employer.