Data Warehouse Engineer


NBC Sports Group

2019-06-21 17:31:32

Job location Orlando, Florida, United States

Job type: fulltime

Job industry: Community & Sport

Job description

Responsibilities

Database Engineer will be working with the Data Warehouse Architect and OLAP Transactional Engineer on designing and delivering solutions that would enhance the Golf Channel Data Service's needs. The ideal candidate will be experienced Microsoft/TSQL, SSIS and Oracle/PLSQL with the ability to demonstrate in-depth knowledge and understanding of transactional systems, data warehouse systems and ETL processes. Open-minded and flexible and prepared to work in a very dynamic, online ecommerce environment, supporting multiple business departments with operational reporting requests in a timely manner.

He/she will develop and maintain a thorough understanding of the needs of the business group from the business and technical perspective, and work closely with Business Users to capture business requirements and implement them using various data tier solutions.

Qualifications/Requirements

  • At least 5 years of experience in data design modeling, ETL, Microsoft/TSQL and Microsoft Sql Server Integration experience
  • Experienced in development of T-SQL and PL-SQL scripts
  • Well versed in normalization/de-normalization techniques for optimum performance in relational and dimensional database environments
  • Strong analytical skills
  • Skills in OLTP/OLAP design and development
  • Understanding of multi-dimensional cubes and reports
  • Skills in performance tuning and query optimization
  • Experienced in ETL processes leveraging CDC/CT technologies
  • Ability to design and develop reports using SSRS/Crystal Report/Jasper/Microstrategy
  • Excellent analytical, interpersonal and communication skills with clear understanding of business process flow
  • Ideal candidate will have a minimum of 5 year ETL tool (SSIS, Informatica, Datastage, Talend) experience
  • Knowledge and experiences in developing and deploying ETL processes to transfer data from various sources and combine them into a unified data store.
  • AWS/Rackspace cloud based data solutions a plus
  • UNIX/Linux command knowledge a plus
  • Ability to learn new technologies and apply them to production solutions
  • Ability to provide timely and accurate data solutions for the business.

    Additional Job Requirements
  • Interested candidate must submit a resume/CV through to be considered (note job #: )
  • Must be willing to work in Location Name
  • Willingness to travel and work overtime, and on weekends with short notice (if applicable)
  • Must have a valid driver's license (if applicable)
  • Must be "on call" 24 hours a day / 7 days a week (if applicable)
  • Must be fluent in Spanish (speak, read & write) (if applicable)
  • Must be able to provide a reel/portfolio of work examples -- if available, include a web address when you submit your resume (if applicable)

    Inform a friend!

  • location

    Top