About the Role
Company DescriptionVERSANT (Nasdaq: VSNT) is an industry-changing media and entertainment business and home to trusted brands that shape culture, inform audiences, and build lasting connections. It operates across four core markets: political news and opinion, business news and personal finance, golf, and sports and genre entertainment. These markets are served through a powerful portfolio of iconic and innovative brands, including CNBC, MS NOW, USA Network, Golf Channel, Oxygen, E!, SYFY, and Versant’s sports division USA Sports, along with complementary digital assets including Fandango, Rotten Tomatoes, GolfNow and GolfPass.Job DescriptionThis 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.Job DescriptionThe candidate will design and develop data pipelines, data marts, and schemas to support our data warehousing environments and analytical requirementsDatabase 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, functionsHands on experience with creating indexes to enhance performance of workloadsHands on experience with development of ETL/ELT processes, share responsibilities for monitoring the data warehouse and data martsHands on development and support of data pipelines in Airflow, AWS Glue, Azure Data factory, Python, GolangHands on experience with cloud environments Azure, AWS, GCPTroubleshoot and resolve data issues in production systemCommunicate with business users and project managers to resolve business problems and create solutionsUse of technical experience to suggest better solutions to new and existing problemsInvolvement with other IT departments providing systems communication processesMeet 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 EngineersIdentify software solutions needed for new projectsWeekly reporting to management on project status and issuesOn call production support QualificationsMinimum Qualifications:7+ years of data warehousing / OLAP experience7+ years multidimensional database architecture and design experience5+ years of SQL Experience3+ years of Python Experience2+ years of Redshift Experience2+ years of NoSQL ExperienceTeam and vendor partner managementClear understanding of principles and techniques of Web developmentExperience with AWS Glue and AirflowExperience with API Dimensional database architecture experienceFormal systems life cycle methodology experienceDesired Qualifications:Cloud Data Warehouse operations experienceTableau, SSRS, big data and Realtime BI experience Experience with data streamingFully 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.Additional InformationAs 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.If you are a qualified individual with a disability or a disabled veteran and require support throughout the application and/or recruitment process as a result of your disability, you have the right to request a reasonable accommodation. You can submit your request to candidateaccessibility@versantmedia.com.VERSANT Media is committed to fair and equitable compensation practices. We include a good faith pay range for each position to comply with applicable state and local pay transparency laws and to promote equity across our organization. Actual compensation will be based on factors such as the candidate's skills, qualifications, experience, and location and may include additional forms of compensation and benefits such as health insurance, retirement plans, paid time off, etc.VERSANT Media is not accepting unsolicited assistance from search firms for this employment opportunity. All resumes submitted by search firms to any employee at VERSANT via-email, the Internet, or in any form and/or method without a valid written Statement of Work in place for this position from VERSANT's Talent Acquisition team will be deemed the sole property of VERSANT. No fee will be paid in the event the candidate is hired by VERSANT as a result of the referral or through other means.