Developer, Data Warehouse

Essendant   •  

Deerfield, IL

Industry: Wholesale


5 - 7 years

Posted 253 days ago

This job is no longer available.

Job Details


Major Responsibilities

  • Design, develop and implement data collection processes in conjunction with the data warehouse. Source data from ERP and legacy application systems supporting a centralized data warehouse and reporting platform.
  • Design and develop Extract Transform and Load (ETL) processes using Informatica to support various business unit specific and enterprise data marts, staging areas and data warehouse structures.
  • Perform data modeling, data profiling, database design and metadata management.
  • Interact with internal business users to gather, define and document requirements.
  • Design technical solutions to meet the requirements for Business Intelligence and Data Warehouse solutions.
  • Translate business requirements into technical solutions.
  • Produce clear, concise detailed technical specifications and other necessary supporting documentation.  
  • Perform and manage tuning activities throughout all aspects of the data warehouse function. Produce efficient solutions.
  • Build, support and maintain data warehouse processes to ensure reliable and efficient application performance of reporting and end user ad hoc solutions.
  • Collaborate and engage with the project team to design, develop and implement Data Warehouse solutions across all functional business areas.
  • Manage projects and coordinate the efforts of both internal and external resources. Plan and manage project schedules and communicate project issues and assumptions appropriately.A successful candidate will be someone who has strong technical knowledge coupled with solid follow through and problem solving skills. Must be detail oriented and have a capacity and passion for learning business data. Skills/Knowledge Required
  • Thorough understanding of Business Intelligence and Data Warehousing concepts
  • Excellent interpersonal and communication skills (verbal/written) and ability to interface effectively throughout the organization.
  • Ability to multi-task across multiple projects, prioritize, meet deadlines and maintain flexibility in a fast-paced, service oriented environment
  • Strong understanding and a successful track record of delivering data warehouse solutions.
  • Detail oriented with strong analytical skills
  • Ability to work with and meet deadlines
  • Results oriented with an ability to think creatively and be able to implement creative ideas 
  • Education and Experience
  • Bachelor’s degree in Computer Science, or related discipline required
  • 5-7years experience building Business Intelligence and Data Warehousing solutions
  • 5-7years experience using Informatica, Oracle and SQL
  • 3-5years experience using MS SQL Server Analysis Services
  • 2-3years experience in Project Management
  • Please include salary history/expectations in your response