Experience:
5+ years of experience
Concerned about your lack of experience? Learn More...
Employment Type:
Full time
Posted:
1/22/2018
Job Category:
Information Services
Industry:
Other
See more jobs for students and recent grads who studied:
BI/ETL Developer - MK-11078
GTN Technical Staffing | Irving, Texas
Tell Us More About Your Job Preferences
By telling us what you think of this job, we can help find jobs that match your interests. If you want to see more jobs like this, click on the smiley face. Or if this job isn't what you are looking for, click the frowny face. Learn More...

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.

This company profile was created by AfterCollege and is about GTN Technical Staffing. This page is not endorsed by or affiliated with GTN Technical Staffing. For questions regarding company profiles, please email: care@aftercollege.com.