Data Engineer III - NBC Sports Next

Company Description

NBC Sports Next is the meeting point of sports and technology. We are a branch of NBC Sports and the home for all NBCUniversal's digital solutions in the sphere of sport and technology within our three divisions: Youth & Recreational Sports; Golf; and Betting, Gaming & Emerging Media.

At NBC Sports Next, we aim to enhance sports engagement through cutting-edge technology and engaging experiences for athletes, coaches, players, and fans. We provide over 30 million players, coaches, athletes, sports administrators, and fans in 40 countries with more than 25 sports solution products, including SportsEngine, the leading platform for youth sports club, league, and team management; GolfNow, the foremost online tee time marketplace and provider of golf course operations technology; GolfPass, the ultimate golf membership that links golfers to exclusive content, tee time credits, and coaching advice; TeamUnify, a provider of swim team management services; GoMotion, a provider of sports and fitness business software solutions; and NBC Sports Edge, a leading platform for fantasy sports information and betting-focused tools.

At NBC Sports Next, our mission to innovate, create larger-than-life events and connect with sports enthusiasts through technology that provides the ultimate immersive experiences fuels us.

We unify the efforts behind products and services such as GolfNow, TeeOff, and GolfPass, to build a closer connection between golf players and golf facilities across the globe using innovative solutions like cloud-based golf course management and SmartPlay contactless technology and services that craft optimum golfing experiences.

Join us as we collaborate and innovate to deliver what's Next.

Job Description

An exciting opportunity awaits an experienced Data Engineer III at GolfNow. As part of the Data Engineering Team, your role will involve managing the full lifecycle of our data warehousing requirements. You will develop and execute complex queries, create database objects (tables, views, stored procedures, user-defined functions), and develop and maintain ETL pipelines. Our data warehouse and data operations leverage Microsoft and AWS technologies including MS SQL Server, SSIS, PowerShell, among other AWS cloud technologies. Successful performance in this role entails understanding complex business processes, gathering requirements, efficient work, and verifying results.

Your responsibilities will include but are not limited to:

• Collaborating with a passionate team of data engineers and data scientists.
• Compiling user requirements and report specifications.
• Contributing to the daily operation of our Data Warehouse.
• Building, analyzing, and managing reporting and dashboards for business stakeholders.
• Responding to users to troubleshoot and/or optimize existing reports.
• Collaborating with internal QA on customer acceptance testing.
• Developing SQL scripts and objects to support reporting functionality and performance.
• Building data pipelines and ETLs for loading source system data into the data warehouse for further reporting and analysis.
• Helping to build scalable data models to support tracking and reporting key business and product metrics.
• Helping to spot better practices, tools, and trends that can positively influence data operations across the business.
• Other duties as per management requirements.

Qualifications

All candidates must satisfy the following qualifications:

• At least 5 years of data engineering experience.
• A Bachelor’s Degree in Computer Science or a related field/relevant industry experience in data engineering.
• A strong understanding of AWS architecture and ETL processing.
• An advanced knowledge of TSQL tuning.
• 5+ years of experience working with Python.
• Advanced experience and understanding of T-SQL for Microsoft SQL Server Database Platforms.
• Experience in working with, assessing, and enhancing cloud frameworks.
• Experience in understanding and enhancing cloud-based data engineering and analytics data strategies.
• Experience with the AWS cloud environment.
• Experience with AWS ETL tools including Glue, Lambda, and step functions.
• Experience with Apache Airflow.
• Experience working with Terraform.
• Working experience in developing and refactoring SQL Stored Procedures.
• Experience in source control with Git or Team Foundation Server.
• Experience in modeling data structures in both transactional and analytical platforms.
• Experience with a BI Tool, such as Tableau or Power BI.

The following qualifications are desirable:

• Experience with SSIS is a plus.
• Experience with PowerShell scripting is advantageous.
• Strong mentorship experience for junior data engineers.
• Experience working in an Agile environment.
• Experience working with SSRS reports.
• Experience managing SDLC processes with Atlassian tools. (Jira, Confluence)
• Willing and eager to learn new technologies.
• Able to transition smoothly between high-level strategy and day-to-day implementation.
• Excellent teamwork and collaboration skills.
• Results-driven and self-motivated.

Fully Remote: This role has been designated as fully remote, suggesting that employees are required to operate from a non-NBCUniversal worksite, most commonly the employee's home.

Additional Information

NBCUniversal is committed to providing equal employment opportunities to all applicants and employees, independent of their race, color, religion, creed, gender, gender identity or expression, age, national origin or ancestry, citizenship, disability, sexual orientation, marital status, pregnancy, veteran status, membership in the uniformed services, genetic information, or any other legally protected factor. NBCUniversal will consider for employment qualified applicants with criminal histories in compliance with the relevant legal requirements, including the City of Los Angeles Fair Chance Initiative For Hiring Ordinance, where applicable.

If you are a qualified individual with a disability or a disabled veteran, you can request reasonable accommodations if you are unable or limited in your ability to use or access nbcunicareers.com as a result of your disability. You can request reasonable accommodations in the US by calling 1-818-777-4107 and in the UK by calling +44 2036185726.