BI Specialist - Microsoft SQL Server. T-SQL, SSIS

Little Ferry, NJ 07643

Posted: 03/01/2016 Employment Type: Direct Hire Industry: Other Area(s) Job Number: 78

Job Summary

The role of the BI Specialist is to implement and support business intelligence solutions, maximize information worker productivity through information availability and provide support and the information needed for optimizing business processes.  This individual must have a successful track record of developing robust BI solutions, primarily using Microsoft SQL Server.


  • Complete project responsibilities including design, coding, unit testing and documentation in a timely manner and at required level of quality
  • Produce technical documentation that accurately and thoroughly depicts the software design and code base that supports QA testing, deployment and production support activities
  • Provide development estimates and timelines for scheduling and planning
  • Brainstorm technical solutions with development team
  • Identify root cause of production issues, assess the situation and provide the best outcome for our customers
  • Define and implement data quality processes, monitor and detect data quality issues
  • Gather business requirements and translate them into effective BI solutions that make business decisions efficient, actionable, trustworthy, and timely.
  • Design, build and implement ETL scripts using Microsoft SQL Server Integration Services
  • Design, build and implement BI reports using SQL Server Reporting Services
  • Design, build and implement QlikSense applications/visualizations
  • Optimize complex stored procedures, scripts, functions and other BI components for best performance
  • Setup and manage user security profiles and access methods
  • Participate in the design and development of B2B and A2A data interfaces
  • Thrive in a team environment and able to work independently as well
  • Other duties assigned by management, as needed

  • Minimum of a Bachelor’ s degree in Computer Science, Engineering or Information Technology
  • 5+ years of experience in T-SQL SQL Server 2008/2012 (complex Store Procedures, scripts and Functions)
  • 3+ years of experience building Data Warehouses using SSIS for SQL Server 2008/2012
  • Candidate must demonstrate strong software development skills and be able to communicate well with our team and external consultants
  • Ability to analyze and resolve technical issues and problems and to identify different design alternatives.
  • Excellent data profiling experience
  • Ability to communicate complex technical details to team, management and non-technical people
  • Experience building QlikSense applications/visualizations is desired
  • Experience with MDM is desired
  • Experience with Oracle environments including PL/SQL development is a plus
  • Experience working with WhereScape RED data warehouse automation tool is a plus
  • Experience with NoSQL databases is a plus
  • Experience building BI solutions for finance, manufacturing and distribution industry


Jason Destro

Over 20 years’ of recruiting experience with hands-on recruiting and placement of I.T. professionals (Full Time, Temp 2 Perm, & Contingent) in the NJ/NY/CT/PA marketplace for a wide variety of today's demanding IT skill sets. Focused on delivering exceptional service by understanding client’s objectives and goals.

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

Textbox Section