NBC Sports Group
Job type: fulltime
Job industry: Community & Sport
Responsibilities At least 5 years of experience in data design modeling, ETL, Microsoft/TSQL and Microsoft Sql Server Integration experience
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.
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)