Full-Time 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 are a subdivision of NBC Sports and home to leading technology platforms and digital applications for Youth & Recreational Sports; Golf; and Emerging Media.

We equip more than 30MM players, coaches, athletes, sports administrators and fans in 40 countries with more than 25 sports solution products.

Responsibilities:

• Architecture, design, development, and maintenance of analytical data streams for new and existing projects.
• Manage and administer data pipelines, data warehousing, data marts, and business intelligence environments.
• Define requirements for development, coordinate acceptance testing, training, and identify enhancements.
• Lead data engineer team members and work closely with other development leads.
• Design and develop data pipelines, data marts, and schemas.
• Database architecture and design of data warehouses & data marts.
• Hands-on experience with T-SQL development, query tuning, table development, stored procedures, functions.
• Create indexes to enhance performance of workloads.
• Development of ETL/ELT processes.
• Monitor the data warehouse and data marts.
• Development and support of data pipelines in MS SSIS, Azure Data factory, PowerShell, Python, Golang.
• Experience with cloud environments Azure, AWS, GCP.
• Troubleshoot and resolve data issues in production systems.
• Communicate with business users and project managers.
• Suggest better solutions to new and existing problems.
• Involvement with other IT departments.
• Meet with various IT groups to address issues/concerns.
• Mentor other Data Engineers.
• Identify software solutions needed for new projects.
• Weekly reporting to management on project status and issues.
• On-call production support.

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

What is the last date for applying to the job?

Which countries are accepted for this remote job?