Sr. Data Engineer - NBC Sports Next

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.
Job Description
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.
The Sr. Data Engineer will be responsible for architecture, design, development, and maintenance of analytical data streams for new and existing projects. This position will join a team of data engineers that manage and administer data pipelines, data warehousing, data marts, and business intelligence environments within our NBC SportsNext - Golf team. This individual will work closely with users to define requirements for development, coordinate acceptance testing, training, and to identify enhancements to existing solutions. Also, they'll help lead our data engineer team members and work closely with other development leads to ensure overall integrity of the application.
The candidate will design and develop data pipelines, data marts, and schemas to support our data warehousing environments and analytical requirements

• Database architecture and design of data warehouses & data marts to support presentation layers elastic cubes, reporting and analytics.
• Hands on experience with tsql development, query tuning, table development, stored procedures, functions
• Hands on experience with creating indexes to enhance performance of workloads
• Hands on experience with development of ETL/ELT processes, share responsibilities for monitoring the data warehouse and data marts
• Hands on development and support of data pipelines in MS SSIS, Azure Data factory, PowerShell, Python, Golang
• Hands on experience with cloud environments Azure, AWS, GCP
• Troubleshoot and resolve data issues in production system
• Communicate with business users and project managers to resolve business problems and create solutions
• Use of technical experience to suggest better solutions to new and existing problems
• Involvement with other IT departments providing systems communication processes
• Meet with various IT groups (other departments and computer operations' staff) to address issues/concerns. This includes other business unit IT groups, as well as the technical operations group (Server Group and other Infrastructure groups)
• Mentor other Data Engineers
• Identify software solutions needed for new projects
• Weekly reporting to management on project status and issues
• On call production support

Qualifications
Minimum Qualifications:

• 7+ years of data warehousing / OLAP experience
• 7+ years multidimensional database architecture and design experience
• 5+ years of SQL Experience
• 3+ years of Python Experience
• 2+ years of PowerShell Experience
• 2+ years of Redshift Experience
• 2+ years of NoSQL Experience
• Team and vendor partner management
• Clear understanding of principles and techniques of Web development
• Experience with AWS Glue and Airflow
• Experience with API
• Dimensional database architecture experience
• Formal systems life cycle methodology experience

Desired Qualifications:

• Cloud Data Warehouse operations experience
• Tableau, SSRS, big data and Realtime BI experience
• Experience with data streaming

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
As part of our selection process, external candidates may be required to attend an in-person interview with an NBCUniversal employee at one of our locations prior to a hiring decision.
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.
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 nbcunicareers.com as a result of your disability. You can request reasonable accommodations by emailing [email protected].
For LA County and City Residents Only: NBCUniversal will consider for employment
\nqualified applicants with criminal histories, or arrest or conviction records, in a manner
\nconsistent with relevant legal requirements, including the City of Los Angeles' Fair Chance
\nInitiative For Hiring Ordinance, the Los Angeles' County Fair Chance Ordinance for Employers, and the California Fair Chance Act, where applicable.