Internal Pages Banner

ETL Developer in Dallas, TX at Tuesday Morning

Date Posted: 5/10/2018

Job Snapshot

Job Description

ETL Developer

Primary focus of this position is to provide ETL development and support for the Business Intelligence team.  Day to day activities will include, but not be limited to…designing and deploying optimized ETL and database designs to support the data warehouse reporting platform, maintaining and contributing to enterprise data warehouse data model, creating batch process automation, and ensuring implementation of sound data integrity processes.  Prefer knowledge of or ability to learn Netezza.

This position will be responsible for the operational tracking of automated batch processes and will be responsible for after-hours support. 

 

Job Duties & Responsibilities

  • Design and develop enterprise and departmental data warehousing and ETL solutions.
  • Create robust and high-performing ETL mappings using Microsoft SSIS.
  • Coordinate activities with data source application owners to ensure integration, data integrity, and data quality.
  • Translate business requirements into ETL designs and mapping specifications.
  • Understand and contribute to enterprise data warehouse data model.
  • Perform unit testing of ETL components and document test results.
  • Provide technical and business knowledge support to the team.
  • Provide after-hours, holiday, and weekend support.

Required Education and Experience

  • 5-7 years of experience developing ETL processes with SSIS in a data warehouse environment.  Requires experience in Visual Studio, 2008, 2010, and 2012. 
  • Strong knowledge of data quality, data profiling, and data cleansing techniques.
  • 5+ years of experience developing reporting and analytics solutions with Microsoft SQL Server 2012 or higher version.
  • Expert-level SQL required; 5-7 years coding and debugging experience.
  • 5+ years of experience building stored procedures, views, functions.
  • 5+ years of experience in relational and data warehouse database design, optimization and performance with MS SQL and Netezza.
  • 3+ years of experience building reports with SSRS.
  • 1+ years of .Net development experience (for scripting purposes with SSIS).
  • Excellent listening skills, interpersonal skills, ability to analyze data and test data against business rules.
  • Ability to work effectively under pressure.
  • Bachelor’s degree in Computer Science/Information Technology or equivalent
  • Experience in developing, publishing, and maintaining all documentation for data models a plus.
  • Microstrategy BI experience a plus.
  • SQL Server database administration knowledge a plus.
  • Experience migrating SSIS from legacy deployment (package base) to Project base deployment a plus.
  • Experience working in the Retail industry a plus.

We offer competitive compensation, excellent benefits to include 401(k), best-in-class products, and more! Both innovative and high-performing, our stores provide you with unlimited possibilities to start your career. Be a part of the Tuesday Morning growth! 


*CB*