[Hiring] Sr Data Engineer @Versant

Role Description

This opportunity is within our Fandango group – a collection of trusted entertainment brands that guide over 50 million movie and TV fans throughout their viewing journey. Our team thrives on shaping how people discover and experience entertainment, one screen at a time.

• 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 T-SQL or PSQL 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 Airflow, AWS Glue, Azure Data Factory, Python, Golang.
• Hands-on experience with cloud environments: Azure, AWS, GCP.
• Troubleshoot and resolve data issues in production systems.
• Communicate with business users and project managers to resolve business problems and create solutions.
• Use 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 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.

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 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.

Requirements

• Cloud Data Warehouse operations experience.
• Tableau, SSRS, big data, and real-time BI experience.
• Experience with data streaming.

Benefits

• This position has been designated as fully remote, meaning that the position is expected to contribute from a non-Versant worksite, most commonly an employee’s residence.