Skip navigation
Senior Data Warehouse Specialist

Senior Data Warehouse Specialist

Job Description

Technical guru. Problem solver. Team oriented. Is this you? Then look no further, your career in Information Systems awaits at Manitowoc Foodservice.

Bring your technical skills to Manitowoc as our new Senior Data Warehouse Specialist and you will be responsible for the definition, development, and testing of the processes and programs necessary to extract data from the OC operational databases and deliver it to the Manitowoc Foodservice Data Warehouse. The scope of responsibility covers ETL design and development, data modeling, data analysis and database design of central/common data necessary to support full integration of our key business systems. This position will be part of the Data Warehouse Team that supports enterprise data, including Master Data Management (MDM), and reporting needs.

Reporting directly to the Data Warehouse Manager, this position is based in New Port Richey, Florida.

If you’re up to the challenge, the reward is satisfaction . . . and knowing you helped build something real. Join our passionate team and help build something you can be proud of – a future filled with passion, pride and satisfaction.

Essential Job Functions:

  • Design, develop, test, debug, implement and maintain ETL workflows, mappings, scripts, and stored procedures, via Oracle's Data Integrator (ODI)ETL tool, to support the data warehouse and reporting requirements.
  • Develops SQL queries/scripts to validate the completeness, integrity and accuracy of data within the ETL process testing cycle.
  • Work closely with local IT contacts to define and develop the program specifications for the data migration processes, as well as the necessary test plans used to ensure successful execution.
  • Reviews and analyzes source data, analyzes and documents data flows, and validates mapping specifications and business rules from data source to target.
  • Troubleshoot DW and data quality problems. Identify, coordinate and help resolve the root cause of day to day production issues.
  • Design and develop DW data model in support of Cognos BI reporting and analysis requirements. Perform analysis of data requirements and development of logical and physical data models.
  • Assists with Cognos Relational & Dimensional data modeling and data loads to support reporting and analysis requirements.
  • Act as a back-up resource to BI Specialist for Cognos reporting and analysis requirements where necessary
  • Create system documentation including, but not limited to, source to target data mapping, database design diagrams, programming specifications, etc.

Job Requirements

Job Requirements/Working Conditions:

  • Bachelor's Degree with a minimum of 5 years’ experience in Data Warehouse (DW) and ETL tools required (i.e. preferably ODI, but will consider other ETL experiences such as Informatic, SSIS)
  • Strong dimensional data modeling skills (i.e. conceptual, logical and physical model design)
  • Experience with data modeling tools (i.e. Erwin, ER Studio)
  • Strong SQL and store procedure programming skills
  • Strong knowledge of performance tuning techniques appropriate at each layer within a DW environment (Oracle related experience is preferred)
  • Experience with data profiling technologies, techniques and approaches for upfront analysis and production control operations.
  • Helpful but not required experience with business intelligence or reporting tools (preferably Cognos 8 BI tools: Transformer, Framework Manager, Analysis Studio and Report Analysis)
  • Progress Programming Language experience a plus
  • Strong documentation skills and attention to detail
  • Ability to learn quickly in a dynamic environment and deliver on commitments in a timely manner.
  • Ability to juggle multiple projects & tasks.
  • Good verbal and written communication skills.
  • Ability to work and communicate effectively with IT personnel and Business users
  • Strong problem solving skills

Manitowoc Foodservice, a division of The Manitowoc Company, Inc., designs, manufactures and supplies best-in-class food and beverage equipment for the global foodservice market. Manitowoc Foodservice offers customers unparalleled operator and patron insights, collaborative kitchen solutions, culinary expertise and world-class implementation support and service, whether locations are around the corner or across the globe. With operations in the Americas, Europe and Asia, the company has a portfolio of best-in-class brands including Cleveland, Convotherm®, Delfield®, Frymaster®, Garland®, Kolpak®, Kysor Panel Systems®, Lincoln, Manitowoc® Ice, Merco®, Multiplex®, Merrychef®, Servend® and Manitowoc® Beverage Systems.


Job Snapshot

Employment Type Full-Time
Job Type Information Technology
Education 4 Year Degree
Experience Not Specified
Manages Others Not Specified
Industry Manufacturing, Industrial
Required Travel Not Specified
Job ID 14000178
CareerBuilder Tip:
For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using you are agreeing to comply with and be subject to the Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.

Senior Data Warehouse Specialist

Enter notes about this job: