ABOUT THE NATIONAL HOCKEY LEAGUE
Founded in 1917, the National Hockey League (NHL®) is the premier professional ice hockey league in the world, and is one of the major professional sports leagues in the United States and Canada.
With more than 1500 employees across the US and Canada, the NHL is a global sports and entertainment organization committed to building healthy and vibrant communities using the sport of hockey to celebrate fans of every race, color, religion, national origin, gender identity, age, sexual orientation, and socio-economic status.
At the NHL, we are looking for dynamic, energetic and impactful individuals who are committed to doing the same by sharing in our philosophy that Hockey is for Everyone – and inclusion belongs on the ice, in the locker rooms, boardrooms and stands.
WHAT WE EXPECT OF YOU
SUMMARY
The ETL Developer will play a key role in designing, testing, implementing, and maintaining the ETL process within the NHL’s cloud data warehouse. This role will focus on development and transformation of data across multiple technologies and databases to help support marketing relations with customers.
ESSENTIAL DUTIES AND RESPONSIBILITIES
• Ability to create and manage sophisticated Talend workflows that import, validate, and cleanse data from various sources including databases, API, files (e.g. csv, Json, xml, excel)
• Test and troubleshoot packages by using the debugging functionality provided with Talend Open Studio/Talend Enterprise Edition/Talend Administration Center (TAC)
• Develop guidelines and standards for ETL usage, manageability, and maintainability
• Profile and understand the various source data, including structured and unstructured web/mobile activity data
• Work closely with business and technical teams to understand, document, design, develop, code, and test ETL processes
• Establish and maintain working relationships with technical and architectural team members across the technology organization
• Ownership and maintenance of all existing and future ETL jobs for external data sources
• Validate ETL jobs against business use cases
• Develop and deploy all post-production enhancements
QUALIFICATIONS
Knowledge Areas/Experience
Required
• 1 to 3 years of hands-on ETL development experience
• Experience implementing ETL best practices to provide strong end-to-end solutions
• Experience with data loads into relational databases using ETL a must
• Advanced SQL experience (Nested Queries, Complex Joins, Analytic Functions) a must
• Solid understanding of Data Modeling and Data Warehousing principles
• Experience in testing, debugging, and tuning of any ETL bottlenecks
Preferred
• Experience in Real Time processing and Big Data tools like Hive, Spark
• Experience with Talend MDM 6.X
• Experience with Python
Education/Certifications
• Bachelors Degree or equivalent
Required Skills
• Strong verbal and written communication skills
• Must be a self-starter and adaptable to changes in priorities
• Strong problem-solving skills
CORE COMPETENCIES
These core competencies reflect the underlying values that are necessary to represent the National Hockey League:
• Accountability
• Adaptability
• Communication
• Critical Thinking
• Inclusion
• Professionalism
• Teamwork & Collaboration
The NHL offers U.S. regular, full-time employees:
Time to Recharge: Utilize our generous Paid Time Off (PTO) to focus on your well-being and ensure a healthy work/life balance. PTO includes paid holidays, vacation, personal and sick days, plus an extra day off for your birthday.
Ability to Focus on your Health: Along with competitive salaries, the NHL offers comprehensive health benefits to employees and their eligible dependents effective on their first day with us – there is no waiting period. The NHL subsidizes a large portion of the health benefits costs, therefore your cost for medical, dental and vision coverage is minimal.
We also offer our employees and members of their household access to our Employee Assistance Program (EAP) to support mental, physical, and financial health. In addition, employees have access to a digital wellness resource designed to improve health and happiness through courses in sleep, movement, and focus. These services are confidential and at no-cost to our employees.
Childcare Leave: Because your family is the NHL family, employees are offered comprehensive Childcare Leave to welcome your new addition. The primary caregiver to the child is entitled to up to 12 weeks of paid Childcare Leave, at full pay, following the birth, adoption, or placement of a child.
Employees that are not the primary caregiver to the child are entitled to up to 6 weeks of paid Childcare Leave, at full pay, which must be taken within the first 6 months following the birth, adoption, or placement of a child.
Confidence in your Retirement Goals: Participate in the NHL’s Savings Plan which includes a 401K (pre-tax and Roth options) plus non-elective (employer) contributions to keep
Location: New York, NY
Posted: Oct. 2, 2024, 7:03 a.m.
Apply Now Company Website