BI and Reporting Developer

San Diego, California
Oct 14, 2016
Dec 13, 2016
Job Type
Full Time

Job Description:

  • The BI and Report Developer will be the subject matter expert for a company-wide BI system, working end-to-end performing database management, ETL development, and report/dashboard generation.
  • Maintain the current data warehouse and automated processes to load data and send daily/monthly/quarterly reports
  • Work closely with all levels of management and departments to gather requirements for new reports and/or dashboards to fill business needs
  • Respond to ad-hoc reporting needs as necessary
  • Responsible for growing and expanding the current BI system by incorporating new data from different sources and adding new functionality to existing processes
  • Develop predictive analytics to help forecast and perform what-if analysis on current data

Duties and Responsibilities:

  • Very strong SQL knowledge and experience including writing stored procedures, views, and nested queries, multi-table joins, etc. SQL Server preferred and/or other relational databases
  • Experience with Star Schema data warehouses and concepts. Dimension and Fact tables
  • Working knowledge of a commercial BI and/or Reporting software. Pentaho preferred
  • Working knowledge of HTML, CSS, JavaScript, jQuery, charting libraries, etc.
  • Experience with ETL tools or processes and working with data from different data sources
  • Strong knowledge of Excel including VLOOKUP’s, pulling data from external sources, pivot tables, etc.
  • Strong business analysis skills with the ability to relate business requirements to a data model and provide comprehensive solutions

Knowledge and Experience (a plus):

  • Familiar with Pentaho BI suite
  • Familiar with Vertica database
  • Knowledge of the insurance industry and key performance indicators related to the industry
  • Familiar with MDX query language and generating reports from data cubes
  • PHP, C# experience is a plus
  • Experience with SSRS and SSIS
  • Knowledge of Salesforce
  • Knowledge of MS Access