5+ years of experience
Concerned about your lack of experience? Learn More...
Employment Type:
Full time
Job Category:
Information Services
MK-10493 Lead DW/BI Senior Consultant/Hands-On Architect
(This job is no longer available)
GTN Technical Staffing | Irving, TX
Grad Date

Not sure what types of jobs you are interested in?

Explore Jobs
Based on Your Education

Follow This Company

Job Description

Lead DW/BI Senior Consultant/Hands-On Architect


Location: Irving, TX

Position Type: Contract (Long Term)

Pay Rate: BOE!


GTN Technical Staffing is searching for a Lead DW/BI Senior Consultant for an opportunity in DFW! This role will get to define how our client's Data Warehouse consumes and processes their corporate data. Our client is doing a complete NextGen revamp, everything on the OSI model from Physical to Application layers and you will own your piece from conception to post-production support. This is great opportunity to join a well-funded and connected consulting firm and work alongside brilliant minds. You will have full ownership on your project and will be the SME for Data Warehouse architecture, design, build, and implementation.


7+ years of experience in the following skill sets

  • Data Warehouse/Business Intelligence (DW/BI) Enterprise-Level Projects
    • Proven experience leading Data Warehouse/Business Intelligence (DW/BI) Initiatives
    • DW Architecture/Design
    • Requirement Gathering/Creating Specifications/Documentation
    • Full Scope Project Analysis/Management/Delivery
    • Design/Architect/Develop/Administration/Integration
    • Data Models - Creation/Application at Physical Level
  • SQL Server 2005/2008 R2/2012/2014 - BI (Business Intelligence) Development/Architecture
    • T-SQL Development (Advanced)/Stored Procedures
    • Query Optimization/Performance Tuning/Storage Allocation
    • Data Warehouse Imports/Updates
    • File Sharing
  • Excellent English - Written/Verbal/Interface Directly with Customers and Stakeholders.


  • SSIS 2008 R2/2012/2014- Integration Services
    • Design/Develop Packages
    • XML Parsing/File Transfers
    • Developing Scalable/Reusable ETL Components
  • SSAS 2005/2008 R2/2012/2014 - Analysis Services
    • Enterprise OLAP Cube Design/Development from Scratch
    • HANDS-ON MDX Querying from Scratch
  • SSRS 2005/2008 R2/2012/2014 - Reporting Services
    • Design/Development Reports/Reporting Portals
    • Manage Subscriptions/Delivery Methods


Applicants must be eligible to work in the specified location

About GTN Technical Staffing

GTN Technical Staffing maintains a core team of project and technical leaders that oversee the delivery of high quality solutions. Our consultants include PMI certified project managers, legacy and web application developers, database architects, business analysts, technical architects, security specialists, systems administrators, training and documentation specialists, and more. GTN Technical Staffing has a global presence, with a proven ability to source and hire consultants for IT jobs internationally in such diverse countries as Canada, United Kingdom, Australia, Singapore, Germany, and more. Are you interested in a recruiting career? If so take a look at some of the characteristics of a successful recruiter, and contact us if you think you are a fit.