This site uses cookies. To find out more, see our Cookies Policy

Data Warehouse Developer in Des Plaines, IL at DSC Logistics

Date Posted: 1/8/2019

Job Snapshot

Job Description

Position Overview :The Data Warehouse Developer delivers performance oriented ETL and Data Warehousing technology solutions as part of our growing Business Intelligence organization. This position will be an integral part of DSC’s Data Warehousing and ETL platforms and have a broad set of database and data warehouse development skills coupled with extensive hands-on expertise using Microsoft SSIS and SQL Server. This position will also play an important role in the architecture, delivery and long-term growth of an emerging and innovative analytics capability. This position will report to the Data Warehouse and Business Intelligence Manager

Position Responsibilities

  • Develop and Manage the technical design, development, and on-going support of DSC’s Enterprise Data Warehouse and associated ETL processes.
  • Analyze, tune and optimize ETL packages, Stored Procedures & SQL scripts to ensure peak performance.
  • Support the ongoing data quality and data integrity initiatives through the creation and expansion of audit, balance, and control procedures, alerts and reports.
  • Occasional and limited off-hours support as required to maintain data availability
  • Serve as the team’s application DBA as required to support database deployments and performance tuning
  • Stays ahead of new and emerging technologies on Data Warehousing and Business Intelligence
  • Provides 24 x 5 support of existing and new DSC customers systems

Job Qualifications

Required

  • 3-5 years of Data Warehouse ETL Development using commercial ETL tools, preferably SSIS 2010/2012/2014
  • Expert level SQL Scripting and Stored Procedure development skills
  • Experience with end-to-end efforts to design, develop, and implement data warehousing and business intelligence solutions
  • Experience in troubleshooting and resolving database problems using native & third party monitoring and troubleshooting tools
  • Demonstrated hands-on experience leading the architecture, construction, and deployment of an end-to-end ETL platform
  • Comfortable working as both a collaborative team member and as a technical platform expert & owner
  • Application and/or Production DBA skills, particularly with MS SQL Server, are strongly preferred
  • Strong analytical and verbal communication skills are required
  • Prior experience working within an Agile environment is desired

Preferred

  • Knowledge of ETL process, especially using Microsoft BI stack, SQL Server
  • Working knowledge of Warehouse Management Systems and Transportation Management Systems
  • Understanding of system architecture and application integration (front-end and back-end technologies, how they fit together)
  • Provides 24 x 5 support of existing and new DSC customers systems

Education

  • Bachelor’s degree required, preferably in Computer Science, Math, Engineering or MIS
  • At least 5+ years of recent experience on SSIS 2012 or higher

Work Environment

This job operates in a professional office environment. This role routinely uses standard office and computer equipment.