Job Seekers, Please send resumes to resumes@hireitpeople.com
Short Description:
This position will be a member of a team but will need to work independently. They will report to a Senior Architect/DBA but will require self-direction.
Complete Description:
ETL Development and Analysis
Job responsibilities will span ETL development/data transformation and database modeling with heavy data analysis skills. This candidate should be an expert in creating, modifying and maintaining SSIS packages which will be used to move data from source systems to the data warehouse back end. Advanced skills in writing complex Structured Query Language (SQL) queries are required.
BI DEVELOPER-Job responsibilities will span requirements gathering, dashboard and report development. This candidate should be experienced in creating, modifying and maintaining Performance Point dashboards as well as SSRS reports. Candidate will work with dedicated project DBA resource to deliver solution. This position includes enhancements and new development of an existing solution.
Skills:
|
Skill |
Required / Desired |
Amount |
of Experience |
|
Proficient in development of SQL Server Integration Services (SSIS) packages |
Required |
8 |
Years |
|
Proficient using MS SQL 2005 or later and writing relational database queries and stored procedures using SQL |
Required |
8 |
Years |
|
Experience building SSIS packages using built-in SSIS components |
Required |
8 |
Years |
|
Experience writing complex T-SQL |
Required |
8 |
Years |
|
Experience analyzing, profiling, manipulating data from a large variety of sources |
Required |
8 |
Years |
|
Experience loading data into a SQL Data Warehouse |
Required |
8 |
Years |
|
Troubleshoot abstract data, profile, analyze and optimize data |
Required |
8 |
Years |
|
Develop error checking and resolution routines |
Required |
8 |
Years |
|
Data modeling experience |
Required |
8 |
Years |
|
Analyze and optimize table design |
Required |
8 |
Years |
|
Evaluate and address data quality issues |
Required |
8 |
Years |
|
Experience in interacting with customers to gather and analyze application requirements |
Required |
8 |
Years |
|
Strong business writing and interpersonal skills necessary for customer contact |
Required |
8 |
Years |
|
Develop and modify Performance Point dashboards using 2010 or later |
Required |
8 |
Years |
|
Experience delivering SharePoint based BI solution, SharePoint 2010 or greater |
Required |
8 |
Years |
|
Experience writing custom MDX |
Required |
8 |
Years |
