ETL Developer
: Job Details :

ABOUT THE NATIONAL HOCKEY LEAGUEFounded 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 YOUSUMMARYThe 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

QUALIFICATIONSKnowledge Areas/ExperienceRequired

• 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 COMPETENCIESThese 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 your retirement goals on track.A Hybrid Work Schedule: The NHL recognizes the value of flexibility in work locations/schedules to help our employees balance work/life priorities. Hybrid work schedules are available for a majority of our roles.Our New Headquarters: Our new, state of the art, offices are located at One Manhattan West in Hudson Yards. When you're in the office, you can conduct meetings in one of our high-tech conference rooms, have lunch with a view or play in the game room. Employees can also enjoy New York's newest neighborhood that is home to more than 100 shops, culinary experiences, and public artwork.A Savings for Commuting: Participate in the NHL's pre-tax commuter benefit plan whichhelps offset the financial cost of traveling to and from our office.NHL Partner Rates: Unlock exclusive pricing from our Partners that include savings on travel, consumer goods and services, plus the NHL Store.Life at the NHL: In your first few days, you meet with your new teammates and the HR Team. You have the opportunity to learn more about the NHL and our workplace culture. Employees are invited to play hockey during our Tuesday Night Skate at Chelsea Piers, join our Employee Resource Groups and more. You are a part of our team and we encourage you to be your authentic self, adding to our dynamic workplace culture.SALARY RANGE: $100-120KActual base pay for a successful candidate will be determined based on a variety of job-related factors, including but not limited to: experience/training, market demands, and geographic location.When applying, please be sure to include a cover letter with your salary expectations for this role. We thank all applicants for their interest in this opportunity, however only qualified candidates selected for an interview will be contacted. NO EMAILS OR PHONE CALLS PLEASE.We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, sex, sexual orientation, age, disability, gender identity, marital or veteran status, or any other protected class.Job Questions:

This position will be based in our New York City Office. Are you willing and able to commute to our office for this position?

If you are not currently living in the tri-state area, are you willing and able to relocate at your own expense for this position?

Do you have the legal right to work in the United States?

Will you now or in the future require visa sponsorship to continue work in the United States?

What are your salary expectations for this role? (NOTE: We are NOT asking for your current salary or salary history)

How did you hear about this position? Where did you first see this role posted?

Do you have at least 1 to 3 years of advanced SQL experience? If so, please rate your skill level on a scale of 1 to 10 (10 being an expert).

Do you have solid experience using any ETL tools? If so, What tools? Please rate your skill level on a scale of 1 to 10 (10 being an expert).

Do you have experience with any analytics or BI tool? If so, what tools? Please rate your skill level on a scale of 1 to 10 (10 being an expert).

Do you have solid understanding of relational and dimensional models and ETL methodologies? If so, please rate your skill level on a scale of 1 to 10 (10 being an expert).

Do you have experience with shell scripting, PERL or Python? If so, what language? please rate your skill level on a scale of 1 to 10 (10 being an expert).

Do you have experience with cloud computing platform? If so, what platform have you used? Please rate your skill level on a scale of 1 to 10 (10 being an expert).

Do you have experience in data modeling and data warehousing? If so, Please rate your skill level on a scale of 1 to 10 (10 being an expert).

Please list the cloud Solutions you have experience with.