Senior Data Analyst, Analytics Services

The Orchard New York , NY 10007

Posted 7 months ago

Overview

The Orchard is a leading music distribution company distributing music from artists such as Ozuna, Jorja Smith, Run The Jewels and Kelsea Ballerini. With cutting edge operations and an unparalleled global team, The Orchard partners with companies of all sizes to make their music available across hundreds of digital outlets and physical retailers around the world. At The Orchard, the focus is to provide a comfortable, social and engaging environment to encourage productivity and creativity.

The Orchard is hiring a Senior Data Analyst, Advanced Analytics to join our New York team.

Responsibilities

Reporting to the Associate Director, Analytics Strategy based in New York, NY, The Orchard has an immediate opening for a full-time Senior Data Analyst, working on Advanced Analytics. The NYC-based position will contribute to and help organize the technical systems that support the availability of data and analytics solutions built and maintained for all business verticals at The Orchard. This person will be responsible for understanding business requirements as communicated by internal stakeholders, translating them into technical solutions, and executing on the work required to accomplish those solutions. Success in this position requires a strong ability to communicate and collaborate within the team and with internal stakeholders across The Orchard.

Qualifications

  • Bachelor's degree required in Music, Business, Statistics, Technology, or related field

  • 2-4 years prior experience working as an Analyst, or in a similar technical role

  • Ability to gather business requirements mapping those to advanced analytics projects, products and solutions

  • Prior experience facilitating technical solutions to business problems

  • Intermediate level of SQL (demonstrate aggregation, join, union, subquery)

  • Strong understanding of database design and query optimization (entity-relationships, database exploration, normalization, keys, indexes)

  • Prior experience working with Looker, or similar BI Tools (Tableau, Mode, Alteryx)

  • Familiarity with Javascript, JSON, React, D3 and other front end data visualization packages

  • Strong passion for and deep knowledge of music

The ideal candidate has:

  • Experience with PL/SQL, or equivalent (demonstrate procedures, functions, triggers)

  • Prior experience working with tools that support technical collaboration (GitHub)

  • Introductory or intermediate experience with Liquid, or similar templating languages

  • Prior experience working with music or entertainment metadata

  • Some experience working with statistical computer languages (Python, SQL, R, etc.) to manipulate data and draw insights from large data sets

  • Some knowledge of advanced statistical techniques and concepts (regression, properties of distributions, statistical tests, and proper usage, etc.) and experience with applications of these

  • Strong communication skills

  • Team player, capable of working effectively within an analytics team, across various engineering teams, and with business stakeholders enterprise-wide

About The Orchard

The Orchard is a leading music distribution company operating in over 40 markets worldwide. With a comprehensive artist & label services offering including full-service marketing, sync licensing, comprehensive video services, transparent data analysis, advertising, rights management, digital and physical distribution and more, The Orchard empowers creators and businesses to grow and adapt in the dynamic global industry. For further information, visit www.theorchard.com.

The Orchard is committed to providing equal employment opportunity for all persons regardless of age, disability, national origin, race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, veteran or military status, genetic information or any other status protected by applicable federal, state, or local law.


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Analyst Customer Analytics (Ltv Usage Cohorts)

Quadpay

Posted Yesterday

VIEW JOBS 10/15/2019 12:00:00 AM 2020-01-13T00:00 <p>QuadPay is an alternative payment provider that allows brands to give their customers the opportunity to split their purchases into 4 automatic installments. The customer gets the product straight away and we pay the merchant upfront. QuadPay is like lay-away for the online generation. We're one of the fastest-growing payments startups in New York City and we are looking for an experienced Data Analyst to help us with Customer Analytics.</p> <p></p> <p><strong>What We’re Looking For</strong></p> <p></p> <p>The Data Analyst – Customer Analytics role is responsible for analysis, reporting and business recommendations in order to better understand QuadPay customer behavior and ultimately grow customer revenue on the QuadPay platform. The Data Analyst is accountable for writing complex SQL queries and using advanced excel techniques to manipulate raw data for recurring and ad hoc reports and analyses. The successful candidate must be comfortable translating business requirements and utilizing a variety of raw e-commerce data from multiple sources (mobile, digital and transactional interactions). You will directly interact with multiple departments across the organization.</p> <p><strong>What You’ll Do</strong></p> <ul> <li>Use SQL and Excel to gather and organize raw data, conduct analysis, and prepare recurring and ad hoc reports – results will inform decision making and program / product improvements</li> </ul> <ul> <li>Set-up and analyze A/B tests using statistical best practices </li> <li>Work with and manipulate large data sets</li> <li>Develop LTV modeling, conduct user cohort analysis plus analyze product usage patterns and marketing campaigns</li> <li>Perform data validation and document discrepancies. Make recommendations to improve data integrity and partner with Engineering to make appropriate changes to the database and/or metrics.</li> <li>Identify areas of opportunity to improve current key metrics and make recommendations for new metrics</li> <li>Leverage customer behavior data to develop integrated excel financial models to forecast future business growth</li> </ul> <ul> <li>Work independently and with team members to understand database structure and business processes</li> <li>Assist in the development of robust analytics dashboards in conjunction with the Product, Engineering and Client Success Teams.</li> </ul> <p><strong>Who You Are</strong></p> <ul> <li>4-year college degree </li> <li>3 - 4 years full time work experience in data analysis</li> <li>High proficiency in Excel</li> <li>Very strong SQL knowledge</li> <li>Experience with statistical programming tools like R</li> <li>Experience working in a start-up</li> <li>Highly inquisitive, strong problem solver, possesses a “detective” mindset</li> <li>Quick learner, with an interest in understanding the payments industry</li> <li>Self-motivated and have the ability to work with limited supervision in a fast-paced, small-team start-up environment </li> </ul> <ul><li>Able to effectively communicate analytical findings to a non-technical audience</li></ul> <ul> <li>Experience building relationships across the organization</li> <li>Highly collaborative, organized and strong attention to detail</li> <li>Strong understanding of statistical fundamentals</li> <li>Able to work on multiple projects simultaneously with ability to effectively prioritize and execute tasks in a fast-paced environment</li> </ul> <p><strong>What We Offer</strong></p> <ul> <li>Excellent medical insurance for you and your dependents</li> <li>Competitive salary and employee equity plan</li> <li>Generous staff referral program</li> <li>Collaborative, transparent, collegial and fun loving office culture</li> </ul><p> <br></p> Quadpay New York NY

Senior Data Analyst, Analytics Services

The Orchard