Sr. Data Engineer - NBC Sports Next

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