Senior Data Analyst - Music Insights Location: Cupertino, CA/Hybrid Duration: 5-6 months with possible extension Description: Skills Python, API Integration, SQL, Tableau, Tableau Prep, Data Engineering(mid level), Excel, Big Data, Snowflake (Nice to have) Looking for someone who has experience with data engineering as well as data analyst Data Analyst with good Data Engineering exp -understand API's Python exp is very important 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 As an equal opportunity employer, ICONMA pride itself on creating an employment environment that supports and encourages the abilities of all persons regardless of race, colour, gender, age, Sexual orientation, citizenship, or disability.