Senior Business Intelligence Specialist (Power BI)

92128, San Diego



The purpose of this job is to work closely with business leaders and provide quantitative and qualitative data analysis and reporting of patterns, insights, and business trends to improve outcomes. This position will complete analysis of various complex data sources and structures in support of Business and IT teams to meet the business and financial goals of the Company. This position exists to drive solutions which require bringing together enterprise-wide data from multiple data sources, creating visualizations, and using analytics techniques to solve and support complex business problems.


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 and dashboards.
  • 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, identify areas of improvement into current operations, and display root cause analysis of problems.
  • Designs, builds, tests, and maintains reports and dashboards and identifies potential improvements to existing business intelligence, reporting and data analysis.

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.
  • Validates data delivered to user community. Ensures compliance with Company data and software policies and procedures.

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.
  • Defines and develops new business intelligence capabilities that provide business with new insights for their external clients and internal operations.
  • Engages with key stakeholders to define and adopt data analytics methodologies and standards.

Serves as the 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.
  • Provide 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.
  • Mentors team members in the use of Business Intelligence tools and applications.
  • Manages initiatives in data management, business intelligence and analytics, supporting existing and planned activities within its business unit as well as the broader organization.


This role does not have supervisory responsibilities.


Bachelor's degree in a quantitative field such as Statistics, Math, Economics, or Computer Science required and Minimum of 7 years of technical experience in analytics, data science, actuarial or equivalent quantitative field required. Minimum 5 years of experience with SQL, Power BI and SAP Business Objects BI required. 5+ years' experience with Alteryx or other ETL tools preferred.


None required.


Demonstrated experience with data visualization tools, such as Power BI, is required. Strong focus on delivering insights and recommendations, creating data visualizations, and building analytics capabilities to support business needs. 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. Ability to establish trusted relationships with key internal customers is required. Ability to thrive in a fast paced and changing work environment. Training and mentoring of junior staff is required. Familiarity with business operations in the property casualty insurance industry is preferred.


Office environment – no specific or unusual physical or environmental demands and employees are regularly required to sit, walk, stand, talk, and hear.


This position operates in an office environment and requires the frequent use of a computer, telephone, copier, and other standard office equipment.