Business Intelligence Developer III

This job is no longer active. View similar jobs.

POST DATE 9/13/2016
END DATE 10/13/2016

Sears Longwood, FL

Company
Sears
Job Classification
Full Time
Company Ref #
50659571
AJE Ref #
576160247
Location
Longwood, FL
Experience
Mid-Career (2 - 15 years)
Job Type
Regular
Education
Bachelors Degree

JOB DESCRIPTION

APPLY
The Business Intelligence Developer is responsible for the full lifecycle of Business Intelligence application development.

Responsible for gathering requirements, ensuring data is available in the data warehouse, generating Structured Query Language (SQL) stored procedures, validating data, delivering data and analyses to end-users, providing end-user training and documentation; handling Business Intelligence requests by utilizing SQL Server Reporting Services (SSRS) reports or report models, Online Analytical Processing (OLAP) cubes, data mining models or ad hoc queries; designing and implementing the underlying dimensional data warehouse, including extracting data from the Online Transaction Processing (OLTP) system through SQL Server Integration Services (SSIS); providing solutions for the most complex applications and/or projects; and serving as a resource for I and II level developers.JOB DUTIES/RESPONSIBILITIES:

* Creates and updates Structured Query Language (SQL) stored procedures used to drive data integration and reporting
* Creates, updates and documents reports using SQL Server Reporting Server (SSRS)
* Creates, updates and documents reporting models to be used with SSRS Report Builder
* Creates, updates and documents Online Analytical Processing (OLAP) cubes using SQL Server Analysis Services (SSAS)
* Creates, updates and documents data mining models using SSAS
* Creates, updates and documents Extract Transform & Load (ETL) packages using SQL Server Integration Services (SSIS)
* Produces accurate technical documentation of all projects, including project specifications and testing documentation
* Provides data validation of new and existing queries, cubes and reports as needed
* Provides end-user training on cubes and models
* Provides end-user support as assigned thru the Track-It! Work Order system
* Analyzes and develops short- and long-term solutions to Information Technology (IT) needs through developing new and modifying or adapting existing applications
* Coordinates with users to determine IT requirements. Reviews system requirements and business processes
* Directs work of other staff members on a project or application basis when needed
* Leads functional teams at the project level
* Communicates effectively and professionally, in both oral and written communications, with all levels of personnel
* Delivers Business Intelligence (BI) throughout the enterprise using a variety of BI platforms
* Organizes workflow, prioritization, and tracking of multiple projects
* Sets an example of professional performance

JOB REQUIREMENTS:

* Bachelors Degree
* 5-10 years of related experience
* 18 years of age or older

REQUIRED SKILLS:

* Knowledge of Microsoft Reporting Services
* Knowledge of Microsoft Report Models and Report Builder
* Knowledge of creating and supporting Online Analytical Processing (OLAP) cubes, especially with Microsoft Analysis Services
* Knowledge of Multidimensional Expression (MDX) language for cube queries
* Knowledge of data integration techniques, especially with Microsoft Integration Services
* Knowledge of Microsoft Excel, especially pivot tables
* Knowledge of Data Mining algorithms and techniques
* Knowledge of Microsoft SharePoint
* Good organizational skills
* Ability to work extended hours on occasion

PREFERRED SKILLS:
* Strong interpersonal and communication skills (both oral and written)Equal Opportunity Employer / Disability / Vet.