Previous Job
Previous
Senior BI Developer / Consultant
Ref No.: 16-14692
Location: Plano, Texas
Requirements:
  • 8+ years of BI & DW experience with 2+ years of hands-on experience designing and delivering high performing Dashboards and Reporting solutions using SSRS / Tableau (will be plus)
  • Experience developing and implementing data collection tools using SSIS on SQL Server 2016
  • Experience deploying reports using SSRS Web Portal on 2016.
  • Exposure to Power BI may be preferable

Current Environment
  • Tableau Reports Hosted thru Drupal Web Services & Data provided from Data warehouse in SQL Server
  • Performance Issues with 2 Dimensional reports & more so due to the design of the existing warehouse
  • Reports Bursting is outsourced through Metrics Insights which adds additional annual cost of maintenance

Scope for New Platform
  • Redesign of underlying Data warehouse to improve performance already undertaken on SQL Server 2016. Aggregate data needed for reports have been already built (Not in Scope)
  • 65 odd visual themes built on Tableau need to be migrated into SSRS & Hosted on SSRS Reporting Portal feature available on 2016
  • Power BI could be a recommended option for some of the visual themes if required
  • Security needs to be provisioned at 4 different levels
  • Explore using existing Views to inherit database level security or Single Sign on capabilities
  • Subscription Feature to be enabled to eliminate Report Bursting
  • Testing to include comparing existing Tableau reports to new SSRS converted reports