SQL Business Intelligence Developer /East Syracuse NY

  • United Business Solutions Inc
  • Feb 06, 2020
Full time Information Technology

Job Description

Role : SQL Business Intelligence Developer Level III.

Duration : Full Time

Location: East Syracuse NY

 The potential candidate is responsible for the development and maintenance of Data Warehouse and all the processes supporting the acquisition of data. The candidate will also be responsible for design and architecture of new Data Warehouse Components/ Data Marts and adhering to corporate standards for all data integration processes.

Responsibilities :

  • Design and develop complex ETL data loading packages.
  • Drive for and create ETL architectural and development standards.
  • Assist in design, architecture and development of Data Warehouse/Datamart.
  • Adhere to ETL/DataWarehouse/Datamart development best practices Identify and resolve any performance and/or data related issues Provide documentation (Data Mapping, Technical Specifications, Production Support, data dictionaries, test cases, etc.)
  • Provide Production Support of Data Warehouse as well as ETL jobs used to support the Data Warehouse.
  • Ability to lead team and development efforts - capturing knowledge capital.
  • Perform duties & responsibilities specific to department functions & activities.

Minimum Education and Experience :

  • 8+ Years of MS SSIS Experience
  • 8+ Years of MS SSRS Experience
  • 2+ Years of MS SSAS Experience
  • 5+ Years of MS SQL Server Database Design/Development
  • 5+ Years of Data Warehousing Experience
  • Advanced SQL Server database knowledge
  • Expert Microsoft SQL Development (T-SQL)
  • Expert Microsoft SSIS Development (2008, 2012, 2014)
  • Experience Implementing Enterprise Level Data Warehouses
  • Experience in Data Modeling
  • Strong Understanding of Agile Data Warehouse Development
  • Advance knowledge of performance tuning related to ETL Development
  • Strong experience with Source Control (TFS, RedGate, etc.)
  • Strong experience with SQL Server Management Studio & BIDS
  • Strong Leadership, communication (verbal & written) and problem solving skills
  • Project team leadership experience
  • Results/Goal oriented
  • Ability to handle multiple projects and manage time efficiently.

 

Occupations

General-Other: IT-Software Development

Salary

Best Rate