BI (Business Intelligence) Developer

Shelton, Connecticut, United States · IT

Description

This position is responsible for developing and supporting Business Intelligence systems for all application software, and to provide support for the end-users.

Essential Functions:

  1. Design SSIS Packages to transfer data from flat files, ftp, or other means to SQL Server using Business Intelligence tools.
  2. Extensively using SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
  3. Writing T-SQL queries, Store Procedures and using them to build packages.
  4. Cube creation using MS SQL Server Analysis Services (SSAS).
  5. Responsible for developing Business Objects Universe Designs, Database Design and Administration functions for Business Intelligence.
  6. Coordinates the testing and implementation of business Intelligence systems.
  7. Work closely with end users to identify requirements for new systems and customizations.
  8. Initiates the change control process for any and all changes to Production systems.
  9. Develops and implements end-user tools for accessing Data Warehouse.
  10. Develop, implement and maintain documentation.
  11. Recommends new information systems solutions to management.
  12. Provides end-user training.
  13. Performs additional duties or assignments as required by management.


Requirements

Qualifications:

  1. Bachelor’s degree in Computer Science, MIS or equivalent.
  2. 2+ years of Data Warehousing and SQL development with SQL Server 2008/2012/2014.
  3. Working knowledge utilizing Microsoft ETL/data integration tools (SSIS and T-SQL scripts).
  4. Demonstrated SQL skills with extensive experience in developing stored procedures, views, functions, triggers, and advanced logical methods.
  5. Working knowledge of Microsoft BI Suite includes SSAS, SSIS & MDX.
  6. Working knowledge of Microsoft suite of products, including Word, Outlook, and Excel.
  7. Knowledge of SAP Business Objects, Design Studio, Mobile, and Analysis products a plus.

Benefits

Salary

Bonus

Pension

401K

Healthcare

Apply for this job