Sr Data Engineer

The candidate will 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

• 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

Desired Qualifications:

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

Fully Remote: 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.

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., As part of our selection process, external candidates may be required to attend an in-person interview with a VERSANT Media employee at one of our locations prior to a hiring decision. VERSANT Media's policy is to provide equal employment opportunities to all applicants and employees without regard to race, color, religion, creed, gender, gender identity or expression, age, national origin or ancestry, citizenship, disability, sexual orientation, marital status, pregnancy, veteran status, membership in the uniformed services, genetic information, or any other basis protected by applicable law. For LA County and City Residents Only: VERSANT Media will consider for employment qualified applicants with criminal histories, or arrest or conviction records, in a manner consistent with relevant legal requirements, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, the Los Angeles County Fair Chance Ordinance for Employers, and the California Fair Chance Act, where applicable.