Previous Job
Previous
SSIS Developer - Limited company Columbus OH
Ref No.: 17-00148
Location: Columbus, Ohio
Position Type:Contract
Start Date: 05/22/2017
 Position Description: 
The position will review existing application and help in enhancing and optimizing the applications to ensure the highest levels of system availability are attained. Candidate will be responsible for Analysis, Design, Development, Documentation and Implementation. The position requires a team player who can work independently.
Application / Modules:
• SSIS
• SSAS
• SQL SERVER
 
Responsibilities:
This position will review existing application and help in enhancing and optimizing the applications to ensure the highest levels of system availability are attained. Candidate will be responsible for Analysis, Design, Development, Documentation and Implementation. The position requires a team player who can work independently.
• Design, build, modify and document data warehouse objects
• Design and develop ETL processes using SQL Server Integration Services (SSIS)
• Assist with performance tuning and enhancements
• Develop, test and deliver error free data
• Design, develop, and modify MS SSAS OLAP and tabular databases 
• Monitor and optimize ETLs and BI databases to ensure performance and data integrity.
• Perform technical analysis documentation
• Ability to work independently (as well as within a team environment) and unsupervised
 
 
Skill Level
• Minimum of 5 years of experience with advanced level of business analysis with emphasis on business intelligence, ETL development and data warehousing.
• Minimum of 5 years of experience with the full Microsoft BI Stack (SSRS, SSIS).
• Proven experience designing and developing multi-dimensional cubes and tabular databases such as Microsoft SQL Server Analysis Services is required.
• Minimum of 5 years of experience writing and tuning complex T-SQL at an advanced or expert level Demonstrated strong problem solving skills
• Working knowledge of modern programming language such as C#, VB.Net is a plus
• Excellent oral and written communication skills
• Must be able to perform all functions independently in a reasonable amount of time
• Demonstrated conceptual thinking and analytical skills.
• Must be capable of working multiple projects at one time and evaluate/prioritize as necessary
•  
 
 
In order to get the best candidates possible, we also ask that you answer the following questions: 
 
• What are the top 3 skills you are looking for?
SSIS
SSAS
SQL SERVER
 
 
• Is there a possibility for extension?
Yes
 
• What is the size of team, and who will this candidate be working with?
1
 
• What is the interview process, and timing behind it?
 
• What is an absolute must have for a candidate in this position?