Senior Data Engineer

Summary

Join NBC Sports Next's Golf team as a Senior Data Engineer! You will be responsible for the architecture, design, development, and maintenance of analytical data streams for new and existing projects. Collaborate with a team to manage data pipelines, data warehousing, and business intelligence environments. Work closely with users to define requirements and ensure the overall integrity of the application. This fully remote position requires extensive experience in data warehousing, database architecture, and various programming languages. Lead and mentor other data engineers while contributing to a dynamic and innovative team.

Requirements

• 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

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
• Work closely with users to define requirements for development
• Coordinate acceptance testing and training
• Identify enhancements to existing solutions
• Lead data engineer team members
• Work closely with other development leads to ensure overall integrity of the application
• Design and develop data pipelines, data marts, and schemas to support 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

Preferred Qualifications

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

Benefits

Fully remote position