DW (Big Data)/BI (SSAS/SSIS/SSRS) - Developer/Hands-on Architect

DW (BIG DATA)/BI (SSAS/SSIS/SSRS) - DEVELOPER/HANDS-ON ARCHITECT

DETAILS

LOCATION: Denton, TX

POSITION TYPE: 6M Contract (with possible extensions)

HOURLY/SALARY: BOE!

ABOUT THE POSITION

GTN Technical Staffing is currently seeking (2) Data Warehouse (Big Data)/BI - Developer/Hands-on Architect for a 6M Contract (with possible extensions) opportunity in Denton, TX.  The Data Warehouse (Big Data)/BI - Developer/Hands-on Architect must be at an architect-level for designing and developing SQL Packages, Access Methods, and Advanced T-SQL Coding. The Data Warehouse (Big Data)/BI - Developer/Hands-on Architect will resolve Data Integrity and Access Issues within SQL Server 2008 R2 Database.  The Data Warehouse (Big Data)/BI - Developer/Hands-on Architect will focus on optimizing the database for data access efficiency and accuracy. 

- Review/Make Improvement Suggestion in Regards to Hardcoded Values/Standards
-Get Down in the Trenches /HEAVY HANDS-ON BI Development
- Technologies - SSAS (Analysis Services)/SSIS (Integrated Services)/SSRS (Reporting Services)

TECHNICAL REQUIREMENTS

5+ years of experience in the following skill sets

- Data Warehouse (Big Data) Developer/Hands-On Architect
- Design/Architect/Develop/Administration/Integration
- OLAP Cubes - Design/Develop Cubes from Scratch
- Data Models - Creation/Application at Physical Level
- SQL Server 2005/2008 R2/2012 - BI (Business Intelligence) Development/Architecture
- T-SQL Development (Advanced)/Stored Procedures
- Query Optimization/Performance Tuning/Storage Allocation
- SSAS 2005/2008 R2/2012 - Analysis Services
- Enterprise OLAP Cube Design/Development from Scratch
- HANDS-ON MDX Querying from Scratch
- SSRS 2005/2008 R2/2012 - Reporting Services
- Design/Development Reports/Reporting Portals
- Manage Subscriptions/Delivery Methods
- File Sharing
- SSIS 2005/2008 R2/2012 - Integrated Services
- Design/Develop Packages
- Troubleshooting/Monitor Performance Bottlenecks
- Review/Reengineer Packages for Maximum Efficiency/Consistency
- Scalable/Reusable ETL Components
- Complex Business Logic
- Disaster Recovery Development/Testing

PREFFERED

- Business Intelligence/Data Warehouse Project Management