Business Intelligence Specialist

Are you looking to make an impactful difference in your work, yourself, and your community? Why settle for just a job when you can land a career? At ICW Group, we are hiring team members who are ready to use their skills, curiosity, and drive to be part of our journey as we strive to transform the insurance carrier space. We're proud to be in business for over 50 years, and its change agents like yourself that will help us continue to deliver our mission to create the best insurance experience possible. Headquartered in San Diego with regional offices located throughout the United States, ICW Group has been named for ten consecutive years as a Top 50 performing P&C organization offering the stability of a large, profitable and growing company combined with a focus on all things people. It's our team members who make us an employer of choice and the vibrant company we are today. We strive to make both our internal and external communities better everyday! Learn more about why you want to be here! PURPOSE OF THE JOB The purpose of the Business Intelligence Specialist is to work closely with business leaders and provide quantitative and qualitative data analysis and reporting of patterns, insights, and business trends. This position will complete analysis of various data sources and structures in support of Business and IT teams to meet the business and financial goals of the Company. ESSENTIAL DUTIES AND RESPONSIBILITIES Collects and aggregates data from multiple internal and external sources for analyses to drive insights into business performance. Aggregates large, complex data sets from multiple databases and creates reports, dashboards and semantic models. Collaborates with appropriate parties within the organization to integrate new data sources into our existing data infrastructure. Delivers complex and actionable reports that show key performance indicators, identifies areas of improvement into current operations, and displays root cause analysis of problems. Provides quantitative and qualitative data analysis of patterns, insights, and trends to decision-makers Collaborates in cross-functional teams to implement analytical solutions. Ensures data quality, adherence to departmental guidelines, profitability, business impact, and other risk-related metrics for self and members of the team. Analyzes current business processes; makes recommendations to management for new, more efficient, workflows, and processes. Uses and presents analytics and metrics to improve processes and provide data-driven forecasts of potential costs, risks, and profits of new business initiatives. Provides reporting solutions and responds to report requests across multiple business areas and for complex enterprise-wide projects. Collaborates with team members across the organization to identify and understand business problems and processes. Enhances and develops analytical and reporting solutions to solve business problems and extract insights. Enhances and supports enterprise-wide strategies, processes, and standards for business intelligence and reporting. Delivers complex functional specifications and system design specifications for assigned projects. Performs as a subject matter expert for the department. Trains staff on project deliverables and acts as a resource for colleagues in the department to answer questions and solve complex problems. Conceptualizes and proposes reporting solutions to business leaders throughout the organization. Provides training materials, documentation, and suggestions to Enterprise Data Analytics leadership staff concerning data analysis and reporting. Ensures data quality, adherence to departmental guidelines, profitability, business impact, and other risk-related metrics for self and members of the team. Develops functional specifications and reporting design specifications for assigned projects. Uses and presents analytics and metrics to improve processes and provides data-driven forecasts of potential costs, risks, and profits of business initiatives. SUPERVISORY RESPONSIBILITIES This role does not have supervisory responsibilities. EDUCATION AND EXPERIENCE Bachelor's degree required in a quantitative field such as Statistics, Math, Economics, or Computer Science. Minimum 5 years of technical experience in analytics, data science, actuarial or equivalent quantitative field required. Minimum 3 years of experience with SQL, Power BI, and cloud platforms such as Snowflake is required. Minimum 3 years of experience with Alteryx or other ETL tools preferred. CERTIFICATES, LICENSES, REGISTRATIONS None required. KNOWLEDGE AND SKILLS Demonstrated experience with data visualization tools, such as Power BI, Tableau, or DOMO is required. Working knowledge of analytics, data science and/or actuarial, required. Experience with SQL and BI tools (Semantic Models, Dashboards, Drag and Drop self-help models etc.), required. Strong understanding of cloud platforms specially Snowflake is required. Strong analytical and problem-solving skills. Ability and willingness to continuously acquire new knowledge (business domain knowledge, expertise with software, etc.). Ability to communicate effectively, especially in a cross-functional team setting. Ability to effectively present analysis to ICW staff and external audiences. Familiarity with business operations in the property casualty insurance industry is preferred. PHYSICAL REQUIREMENTS Office environment no specific or unusual physical or environmental demands and employees are regularly required to sit, walk, stand, talk, and hear. WORK ENVIRONMENT This position operates in an office environment and requires the frequent use of a computer, telephone, copier, and other standard office equipment. We are currently not offering employment sponsorship for this opportunity. #LI-TP1 #LI-HYBRID The current range for this position is $95,378.98 - $160,850.17 This range is exclusive of fringe benefits and potential bonuses. If hired at ICW Group, your final base salary compensation will be determined by factors unique to each candidate, including experience, education and the location of the role and considers employees performing substantially similar work. WHY JOIN ICW GROUP? Challenging work and the ability to make a difference You will have a voice and feel a sense of belonging We offer a competitive benefits package, with generous medical, dental, and vision plans as well as 401K retirement plans and company match Bonus potential for all positions Paid Time Off Paid holidays throughout the calendar year Want to continue learning? Well support you 100% ICW Group is committed to creating a diverse environment and is proud to be an Equal Opportunity Employer. ICW Group will not discriminate against an applicant or employee on the basis of race, color, religion, national origin, ancestry, sex/gender, age, physical or mental disability, military or veteran status, genetic information, sexual orientation, gender identity, gender expression, marital status, or any other characteristic protected by applicable federal, state or local law. ___________________ Job Category IT At ICW Group we offer a work environment that encourages entrepreneurialism and celebrates success. Our team members are hands-on contributors who are given the opportunity to make an impact. It's our people who make us an employer of choice and the vibrant company we are today.