Data Engineer

Company Description
We create world-class content, which we distribute across our portfolio of film, television, and streaming, and bring to life through our theme parks and consumer experiences. We own and operate leading entertainment and news brands, including NBC, NBC News, MSNBC, CNBC, NBC Sports, Telemundo, NBC Local Stations, Bravo, USA Network, and Peacock, our premium ad-supported streaming service. We produce and distribute premier filmed entertainment and programming through Universal Filmed Entertainment Group and Universal Studio Group, and have world-renowned theme parks and attractions through Universal Destinations & Experiences. NBCUniversal is a subsidiary of Comcast Corporation.
Here you can be your authentic self. As a company uniquely positioned to educate, entertain and empower through our platforms, Comcast NBCUniversal stands for including everyone. Our Diversity, Equity and Inclusion initiatives, coupled with our Corporate Social Responsibility work, is informed by our employees, audiences, park guests and the communities in which we live. We strive to foster a diverse, equitable and inclusive culture where our employees feel supported, embraced and heard. Together, we'll continue to create and deliver content that reflects the current and ever-changing face of the world.
NBC Sports Next is where sports and technology intersect. We're fueled by our mission to innovate, create larger-than-life events and connect with sports fans through technology. We're a subdivision of NBC Sports and home to leading technology platforms and digital applications for Youth & Recreational Sports; Golf; and Emerging Media.
At NBC Sports Next, we equip more than 30MM players, coaches, athletes, sports administrators and fans in 40 countries with more than 25 sports solution products, including SportsEngine , the largest youth sports club, league and team management platform; SportsEngine Play , the first ever streaming service for youth and amateur sports, GolfNow , the leading online tee time marketplace and provider of golf course operations technology; and GolfPass the ultimate golf membership that connects golfers to exclusive content, tee time credits, instructional content and more.
NBC Sports Next is where sports and technology intersect. We're fueled by our mission to innovate, create larger-than-life events and connect with sports fans through technology. We're a subdivision of NBC Sports and home to leading technology platforms and digital applications for Youth & Recreational Sports; Golf; and Emerging Media.
At NBC Sports Next, we equip more than 30MM players, coaches, athletes, sports administrators and fans in 40 countries with more than 25 sports solution products, including SportsEngine , the largest youth sports club, league and team management platform; SportsEngine Play , the first ever streaming service for youth and amateur sports, GolfNow , the leading online tee time marketplace and provider of golf course operations technology; and GolfPass the ultimate golf membership that connects golfers to exclusive content, tee time credits, instructional content and more.
Golf fuses the team behind products and services like GolfNow , TeeOff and GolfPass , which better connects golfers and golf facilities around the world through innovative solutions like cloud-based golf course management and SmartPlay contactless technology and services that create optimum golfing experiences.
Job Description
GolfNow has an exciting opportunity for an experienced Data Engineer. Working alongside the Data Engineering Team, you'll manage the full lifecycle of our data warehousing needs. You'll read and write complex queries, demonstrate the ability to create database objects (tables, views, stored procedures, user-defined functions), and create and maintain ELT pipelines. Our data warehouse and data operations are built on top of Microsoft and AWS technologies including Redshift, RDS, MSSQL and Python. To perform this job successfully, an individual would need to be able to understand complex business processes, gather requirements, work efficiently, and verify their results.
Responsibilities include but are not limited to:

• Work within a small team of passionate data engineers and data scientists.
• Compile user requirements and specifications for reports.
• Contribute to the management of the day-to-day operations of running our Data Warehouse.
• Build, analyze, and manage reports and dashboards for business stakeholders.
• Respond to users to troubleshoot and/or improve existing reports.
• Collaborate with internal QA on customer acceptance testing.
• Develop SQL scripts and objects to support reporting functionality and performance.
• Build data pipelines and ELTs for loading source system data into the data warehouse for further reporting and analysis.
• Assist in building scalable data models to support reporting and tracking of key business and product metrics.
• Help identify better practices, tools, and relevant trends that can positively influence the data operations across the business.
• Other duties may be assigned as needed by management.
• Strong ability to actively engage in a remote workspace - including, but not limited to, virtual team meetings, connection via team channels (Teams, Slack and Outlook) and ad hoc meetings as requested.
• Experience working through complex issues to completion
• Other duties may be assigned as needed by management.

Qualifications
All candidates must meet the qualifications below:

• A minimum of 2+ years of programming or data engineering experience is required
• Bachelor's Degree in Computer Science or related field/relevant industry experience in data engineering
• Working experience developing and refactoring SQL Stored Procedures
• A minimum of 1 years working experience with Python
• Good understanding and knowledge of T-SQL and Microsoft SQL Server Database Platforms
• 1+ years experience with AWS cloud environment
• Experience with AWS ETL tools such as Glue and Lambda
• Experience using source control with Github, Bitbucket, TFS
• Experience with modeling data structures in both transactional and analytical platforms.
• Experience with one of the following BI Tools. (SSRS, Tableau, Power BI)

Desired qualifications are as follows:

• Experience working in Agile environment
• Experience with Redshift
• Experience with PowerShell scripting is a plus
• Experience with SSIS is a plus
• Experience with Apache Airflow
• Experience managing SDLC process with Atlassian tools. (Jira, Confluence)
• Able and eager to learn new technologies.
• Able to easily transition between high-level strategy and day-to-day implementation.
• Excellent teamwork and collaboration skills.
• Results-oriented and self-motivated.

Fully Remote: This position has been designated as fully remote, meaning that the position is expected to contribute from a non-NBCUniversal worksite, most commonly an employee's residence.
Additional Information
NBCUniversal's policy is to provide equal employment opportunities to all applicants and employees without regard to 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 basis protected by applicable law. NBCUniversal will consider for employment qualified applicants with criminal histories in a manner consistent with 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 have the right to request a reasonable accommodation if you are unable or limited in your ability to use or access as a result of your disability. You can request reasonable accommodations by emailing