Experience:
5+ years of experience
Concerned about your lack of experience? Learn More...
Employment Type:
Full time
Posted:
2/5/2018
Job Category:
Information Services
Industry:
Other
BI/ETL Developer - MK-11078
(This job is no longer available)
GTN Technical Staffing | Irving, TX
loading
loading
School
Major
Grad Date
 
 

Not sure what types of jobs you are interested in?


Explore Jobs
Based on Your Education

Follow This Company
Share

Job Description

BI/ETL Developer

DETAILS

Location: Irving, TX

Position Type: Direct-Hire

Hourly: BOE!

ABOUT THE POSITION

GTN Technical Staffing is currently seeking a BI/ETL Developer for a Direct-Hire opening in Irving, TX. Our client is currently building out an EDW and is looking to add a key resource to their team. We're looking for an individual who understands OLAP/OLTP data architectures and has experience integrating database solutions with source control. This is more than just a worker-bee role - you will also work with key stakeholders providing guidance and creating/presenting documentation for the project. Also, we are really looking for someone to come in and be the right-hand person to help lead the day-to-day grind of technical solutions that require data integration from system to system. The DW stuff is needed, but this role will also push the envelope of using ETL techniques to integrate data from system to system across the enterprise.

Currently, our client is taking a blended-model approach to build a faster, more business-centric EDW to increase efficiency with the Agile approach of the Dev teams. They would like to start taking more of a data mart-ish approach and add reporting techniques into the ODS (operational data store) currently in production. Their ETL framework (SSIS) has already been established, and they currently have a data modelling tool already in use. This is a very MS-centric environment, but they do have 3rd party tools for performance enhancements.

This role calls for somebody understands data as a whole and is able to communicate technical concepts to business teams. Documentation is also key - there is very little documentation in place and there is a need to expand onto those to get more features/data models documented.

TECHNICAL REQUIREMENTS

7+ years of experience in the following skill sets

  • Real Time Data Integration/Analysis/Design/Implementation
    • OLTP - Online Transaction Processing/Real Time Data Integration
    • OLAP - Online Analytical Processing/Real Time Data Integration
  • SQL Server 2005/2008 R2/2012 - BI (Business Intelligence) Development/Architecture
    • T-SQL Development (Advanced)/Stored Procedures
    • Query Optimization/Performance Tuning/Storage Allocation
  • SSIS 2005/2008 R2/2012 - Integration Services
    • Troubleshooting/Monitor Performance Bottlenecks
    • Review/Reengineer Packages for Maximum Efficiency/Consistency
  • Scalable/Reusable ETL Components
  • Complex Business Logic
  • SSRS 2005/2008 R2/2012 - Reporting Services
    • Adding Reporting Techniques to ODS
    • Design/Development Reports/Reporting Portals
  • Excellent English - Written/Verbal

PREFERRED

  • Enterprise Data Warehouse (Big Data) Architecture
    • EDW Design/Architect/Develop/Administration/Integration
    • Deep understanding of Ralph Kimball's approach to data warehousing
    • Data Models - Physical Data Modeling
    • Documentation, Documentation, Documentation
    • Business Intelligence/Data Warehouse Project Management
  • SSAS 2005/2008 R2/2012 - Analysis Services
    • Enterprise OLAP Cube Design/Development from Scratch
    • HANDS-ON MDX Querying from Scratch
  • Disaster Recovery Development/Testing
  • Consulting Experience

Qualifications

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.