Senior Data Analyst

Open to NYC location as well as the Los Angeles location! Job Description: • A leading Direct-to-Consumer team oversees multiple streaming businesses within a major entertainment organization, helping bring best-in-class storytelling to fans and families everywhere. We are seeking a Senior Data Analyst focused on reporting, automation, and tooling within the broader entertainment portfolio. • This role’s primary responsibility is to support and build reporting automation for various business-critical initiatives. This may include custom pipeline building and integration with a suite of data and technology tools, scripting in Python for automated report distribution, quality testing, and visualization creation. Requirements: • 5+ years of analytical experience • 3+ years work experience developing in SQL, especially in an ETL processing pipeline • 3+ years of scripting experience (python/R) • Experience automating manual Excel-based workflows • Familiarity with Google App Scripts, Snowflake (or similar Analytical Warehousing products), Github • Data visualization experience with Looker, Tableau • Demonstrated experience with conveying technical and/or analytical concepts to broad set of audiences • Strong communication skills, as well as written and verbal presentation skills Nice to haves: • Advanced custom data visualization tool experience (D3, Streamlit) • Understanding of statistics concepts (e.g., hypothesis testing, regression analysis) • Advanced degree • Familiarity with Airflow • Experiencing building or prototyping tech from scratch Responsibilities: • Build end-to-end solutions for contained ongoing reporting automation • Respond to intake and document data requirements related to subscriber reporting automation (including complex dashboarding, automated email sends, continual deck creation) • Develop queries based on required business logic, sometimes legally obligating, to determine accurate outputs for each relevant business unit • Incorporate data quality testing into daily pipelines to ensure data integrity and accuracy of all automated reporting. • Create clean and understandable visualizations for broad business consumption • Develop strong knowledge of the technical infrastructure that underlies subscriber data • Contribute to the design of resilient reporting solutions that minimize data incidents