Business Data Analyst I
About The Position
Job 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. Requirements Skills and Expertise Qualities: 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. Skill Sets: 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 (see “experience” below for further details). Licenses, Certification, Education and/or Experience Licenses/Certification: None required. Education: Master’s in Business Analytics and Information Systems or Equivalent. Any suitable combination of education, training or experience accepted. Experience: 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; 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.
Requirements
- 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
- 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
- References and work sample/s required
Nice To Haves
- VBA experience preferred
- Columnar database structures beneficial
- Data visualization experience desired
- GIS software experience a plus
- Professional environment experience preferred
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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
Number of Employees
51-100 employees
