Sr Data Engineer

Versant•Orlando, FL

4d•Remote

About The Position

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. Whether it’s purchasing tickets to their favorite blockbusters through Fandango, reading trusted reviews on Rotten Tomatoes, or streaming the latest releases at home via Fandango at Home, our platforms help audiences find, watch, and enjoy content with ease. Our team thrives on shaping how people discover and experience entertainment, one screen at a time.

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

Nice To Haves

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

Responsibilities

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