Remote Sr. Data Engineer - NBC Sports Next

Description:

• The Sr. Data Engineer will be responsible for the 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 the NBC SportsNext – Golf team.
• The individual will work closely with users to define requirements for development, coordinate acceptance testing, training, and identify enhancements to existing solutions.
• They will help lead the data engineer team members and work closely with other development leads to ensure the overall integrity of the application.
• The candidate will design and develop data pipelines, data marts, and schemas to support data warehousing environments and analytical requirements.
• Responsibilities include database architecture and design of data warehouses and data marts to support presentation layers, elastic cubes, reporting, and analytics.
• The role requires hands-on experience with T-SQL development, query tuning, table development, stored procedures, and functions.
• The candidate must have hands-on experience with creating indexes to enhance performance of workloads and developing ETL/ELT processes.
• They will share responsibilities for monitoring the data warehouse and data marts and support data pipelines in MS SSIS, Azure Data Factory, PowerShell, Python, and Golang.
• The position requires hands-on experience with cloud environments such as Azure, AWS, and GCP.
• The candidate will troubleshoot and resolve data issues in production systems and communicate with business users and project managers to resolve business problems and create solutions.
• They will use technical experience to suggest better solutions to new and existing problems and be involved with other IT departments providing systems communication processes.
• The role includes meeting with various IT groups to address issues/concerns and mentoring other Data Engineers.
• The candidate will identify software solutions needed for new projects and provide weekly reporting to management on project status and issues.
• The position requires on-call production support.

Requirements:

• A minimum of 7 years of data warehousing/OLAP experience is required.
• A minimum of 7 years of multidimensional database architecture and design experience is necessary.
• At least 5 years of SQL experience is required.
• A minimum of 3 years of Python experience is needed.
• At least 2 years of PowerShell experience is required.
• A minimum of 2 years of Redshift experience is necessary.
• At least 2 years of NoSQL experience is required.
• The candidate must have experience in team and vendor partner management.
• A clear understanding of principles and techniques of web development is necessary.
• Experience with AWS Glue and Airflow is required.
• The candidate must have experience with APIs and dimensional database architecture.
• Formal systems life cycle methodology experience is necessary.

Benefits:

• This position is designated as fully remote, allowing employees to work from a non-NBCUniversal worksite, most commonly their residence.
• NBCUniversal provides equal employment opportunities to all applicants and employees without regard to various protected characteristics.
• The company offers reasonable accommodations for qualified individuals with disabilities or disabled veterans.