Cabrillo Coastal General Insurance Agency, LLC · 4 hours ago
Business Data Analyst I
Jonesville, FL
Full-time
Onsite
New Grad, Entry LevelCabrillo Coastal General Insurance Agency, LLC is seeking a Business Data Analyst I to support various cross-functional teams. The role involves developing internal reporting tools, managing data workflows, and ensuring data quality for analytics and compliance reporting.
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
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
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
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
Strong knowledge of: SQL; Microsoft Excel; VBA; GIS software; Data Visualization; and other database tools
Education: Master's in Business Analytics and Information Systems or Equivalent. Any suitable combination of education, training or experience accepted
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
Preferred
VBA experience preferred
Columnar database structures beneficial
Data visualization experience desired
GIS software experience a plus
Professional environment experience preferred
References and work sample/s required
Company
Cabrillo Coastal General Insurance Agency, LLC
Offering residential property insurance products in places exposed to hurricanes is one thing.
Founded in 2013
51-200 employees
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
Leadership Team
M
Manohar Pradhan
Chief Product and Technology Officer
Company data provided by crunchbase