Position: Senior SQL BI Developer
Division: Fision Home / Hotwire Communications
Department: Information Systems / Information Technology
Location: Ft. Lauderdale, FL
Open Date: Tue Feb 14th, 2017

Purpose Statement:

  • Implement end to end Business intelligence solutions using Microsoft SQL 2012 and beyond

Qualifications/Requirements:

MCSA (Microsoft Certified Solution Associate SQL 2014) and at least 5 years of experience developing solutions using the BI stack of Microsoft and 5 years of experience in IT, which must include:

  • SSIS
  • Implementation end to end packages that must include variables, parameters, expressions, transactions, Script task, Script component using C#
  • Fact ETL, Dimension ETL and advanced including slow changing dimensions and late arrivals
  • SSAS Multidimensional
  • Dimension design
  • Using Properties to Customize Dimensions
  • Cube design
  • Adding Calculations, KPI, Drillthrough and Actions
  • Managing aggregation
  • Basic security techniques at the cube level
  • MDX
  • MDX Query Context and Execution
  • Cell Context and resolution order in queries
  • Modification of the cube context in actions and KPI
  • Visibility of Definitions between Global, Session, and Query-Specific Calculations
  • SSRS
  • Working with the Tablix
  • Developing expressions
  • Creating dynamic reports with parameters
  • Chart elements
  • Displaying performance with indicators
  • Reusing report parts
  • Securing report server content
  • Performing administrative tasks
  • TSQL
  • Stored procedures
  • User-Defined Functions and Types
  • Triggers
  • Error handling
  • Query Performance Tuning
  • XML
  • Files, File groups, and Integrity
If interested in this or any of the open positions, please email your resume
and cover letter to careers@hotwiremail.com