IEOR - Designing a More Efficient World

Data Analysis Intern at Integrate Autism Employment Advisors

View job on Handshake

Employer: Integrate Autism Employment Advisors

Expires: 07/11/2020

Data Analyst InternThe Data Analyst will work in the Sales Integration Group of a Major Motion Picture Company on reporting and analysis required to support the Home Entertainment Digital Business. This position will be part of the team responsible for analyzing and reviewing Digital POS (point of sale) vs. Royalty data to ensure our Retail Planning and Reporting teams have all the tools they need for meaningful sales analysis and reporting.JOB RESPONSIBILITIES (include, but may not be limited to):1.    Download customer digital royalty remittances and create a data repository for daily sales transactions.2.    Analyze and report variance between digital royalty remittances and daily “Point of Sale” transactions.3.    Build and execute system SAS and SQL programs to centralize daily Broadband Royalty transactions, and segment using pre-defined business segmentation rules4.    Assist in furthering the development of revenue pacing, sales reporting and Net Revenue Scorecard dashboards5.    Assist in streamlining various retail forecast models6.    Document SAS and SQL queries and develop/improve training materials7.    May perform other duties as assigned and explained by manager. JOB QUALIFICATION STANDARDS:Work or Comparable Experience·      1 + years of experience reviewing, analyzing and providing input on data quality either through work or school experience.·      Experience with creating Excel workbooks, filtering, pivot tables, macros and other functions·      Strong knowledge and practical application SAS and SQL Programs.·      Basic Tableau knowledge preferred·      Experience with data modeling preferred.Technical Knowledge / Skills:·      Ability to learn how to use reporting tools after training received from Manager·      Experience managing data extracts preferred·      Working knowledge of Tableau preferred·      SAS/SQL experience preferred·      Experience with Excel requiredFunctional Knowledge / Skills in the following areas:·      Data analysis practices.·      Test Data Management Practices.·      Strong knowledge of Excel and Excel query functions.·      Demonstrated analytical, verbal, and written communication skills Other RequirementsMust be detail oriented.Must be capable of working with some level of autonomy after receiving instructions from managerMust have aptitude for working in large data sets and data mining at a detailed levelFor an application and more information, please email