Cabrillo Coastal General Insurance Agency, LLC · 3 hours ago
Business Data Analyst I
Cabrillo Coastal General Insurance Agency, LLC is seeking a Business Data Analyst I to support cross-functional teams and manage backend data workflows. The role involves developing reporting tools, ensuring data quality, and participating in compliance reporting during major weather events.
FinanceInsurance
Responsibilities
Support cross-functional teams including Accounting, Underwriting, Compliance, Claims, and Catastrophe Modeling
Develop and maintain internal reporting tools (Excel with SQL/VBA) ensuring they remain functional and efficient
Manage backend data workflows using SQL and Python with an end-to-end understanding of systems and ensuring data quality and availability for analytics and regulatory reporting
Lead the monthly and quarterly data processing cycle into the data warehouse and coordinate with multiple teams to deliver accurate, timely data and provide training and guidance to junior team members
Support compliance reporting during major weather events, deliver under tight regulatory deadlines and participate in the CAT duty program to assist Claims operations during surge periods
Qualification
Required
Master's in Business Analytics and Information Systems or Equivalent
Strong SQL background, including, but not limited to: building tables, inserting data, multiple joins, subqueries, operators, math and string functions, and building procedures
proficiency in Microsoft Excel
high level of competency in data manipulation and analysis
demonstrated application of advanced problem analyses/solving skills to unique and interesting challenges
excellent analytical and quantitative skills
project management skills, including the ability to work independently, as required, and meet or exceed project quality and time frame goals
ability to handle multiple, competing priorities simultaneously
organization
time management/working under tight deadlines
active listening skills
highly effective oral and written communication skills, including the ability to effectively, cohesively, accurately and patiently communicate and interpret routine to complex data findings, both in writing and/or when speaking, to a variety of different audiences with a wide range of knowledge bases and experience backgrounds
Inquisitive and Innovative Problem Solver
Quality-Oriented
Detail-Oriented
Self-Starter
Team Player
Multi-Tasker
Adaptability
Strong Work Ethic
Positive “Can Do” Attitude
Collaborator
Service-Oriented
Goal-Oriented
Preferred
VBA experience preferred
columnar database structures beneficial
data visualization experience desired
GIS software experience a plus
professional environment experience preferred
Company
Cabrillo Coastal General Insurance Agency, LLC
Offering residential property insurance products in places exposed to hurricanes is one thing.
H1B Sponsorship
Cabrillo Coastal General Insurance Agency, LLC has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (3)
2021 (1)
Funding
Current Stage
Growth StageTotal Funding
$0.09M2019-07-31Seed· $0.09M
Company data provided by crunchbase