Senior Data Analyst - Music Insights
Location: Culver City or Santa ClaraPosted On: 12/19/2023
Requirement Code: 66485
Requirement Detail
Skills - Python, API Integration, SQL, Tableau, Tableau Prep, Data Engineering(mid level), Excel
Big Data, Snowflake (Nice to have)
Responsibilities
Key responsibilities of the contractor is to move the team in the direction of scale and optimization.
Build automated data pipelines and data solutions in Python using tools like Datalab and cron jobs.
Help the team with exploration of APIs and new data solutions.
Move the team in the direction of self serve analytics model for ongoing and repeated insights asks which can be served directly to the Music Editorial team.
Assist the team with basic data engineering tasks using python, Tableau Prep and excel.
Take over ad hoc insights solutions that have potential to scale and convert them into long term automated and scalable data solutions for optimization.
Heavily work with Tableau to design centralized data sources.
Work with both Content and Industry Insights teams.
Partner with DS&A and ADE teams to collaborate on centralized data aggregates and data solutions.
Potential opportunity to work with Big Data systems and Snowflake as we explore access to databases.
Key Qualifications
7~~@~~ years of experience as a data analyst, data engineer or data scientist
2~~@~~ years of experience with Hadoop Ecosystem e.g. Spark, Pyspark, Hive, Presto, HMS
5~~@~~ years of experience with a programming languages (Python and Scala)
6~~@~~ years of strong experience building data and analytics solutions using APIs
5~~@~~ years of experience in developing and optimizing Tableau data sources, dashboards and stories
Data exploration, Transformation and ETL experience and experience working with data from multiple datas sources is strongly preferred.
Ability to understand API Specs, identify relevant API calls, extract/transform data and implement SQL friendly data structures
Technical proficiency with SQL and relational databases
Excellent analytical and problem solving skills
Strong communication and presentation skills
Demonstrated ability working with multiple teams to complete critical achievements under pressure with tight deadlines
Experience with Jupyter Notebook preferred
Strong understanding of large-scale content management systems and data modeling strongly preferred
Description
Develop end to end reporting solutions for complex processes.
Gather business requirements, design and build automated reporting solutions in Tableau.
Create visually engaging reports and dashboards for effective communication of insights.
Analyze, inspect and create reports against various data sources including APIs
Enable data driven decision making by analyzing data from multiple source and present coherent insights.
Provide Tableau reporting expertise and knowledge to implement decision based reporting solutions.
Enhance and maintain existing production Tableau dashboards
Education
BS degree, preferably with a technical background