Job Description
Responsibilities
Database Engineer will be working with the Data Warehouse Architect and OLTP Transactional Engineers on designing and delivering solutions that would enhance the Golf Channel Data Service's needs. The ideal candidate will be experienced Microsoft/TSQL, SSIS 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 scripts, Other variants of SQL languages a plus.
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 Change Tracking or Change Data Capture technologies
Ability to design and develop reports using SSRS/Tableau/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.
Must be willing to participate in an ''on call'' rotation.
Experience with Windows PowerShell, .Net Core, Python, Go a plus
AWS/Azure 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 www.nbcunicareers.com 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 willing to participate in an ''on call'' rotation (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)
#LI-Remote
Jobcode: Reference SBJ-d22q67-204-236-220-47-42 in your application.