Technicolor

Returning Candidate?

Sr. Data Analyst

Sr. Data Analyst

Job Location / Endroit 
US-CA-Camarillo
Type / Type d’emploi 
Regular Full-Time
Category / Catégorie 
Business Development
Job ID / Numéro d'identification d'emploi 
1017-4697

More information about this job / Obtenir plus de renseignements à propos de cet emploi

Summary / Emploi Aperçu

Technicolor is the world’s largest manufacturer of Blu-ray and DVD products, offering end-to-end supply chain management services to Hollywood studios, independent content owners, game and software publishers. Our services include content preparation, disc replication, finished goods distribution and transportation/freight optimization solutions. We deliver Blu-ray discs, DVDs, Xbox 360 and Xbox One discs based on the highest possible quality standards, supported by leading technology and operational efficiency. We put our clients and their content at the heart of our work; we have invested in the latest Blu-ray manufacturing equipment, in people and systems to deliver the best possible customer service experience. As a service provider, our mission is to contribute to the efficiency of our client’s supply chain and their success at retail. 

Responsibilities /Responsabilités

Position Summary:

This position is responsible for preparing and developing a variety of Supply Chain reports for customer accounts internal and external. Manipulate large volumes of data, financial model development and create new and improved techniques/solutions for data collection, management and usage. Provide extensive support to various lines of business, points of sale and internal stakeholders by reporting on and analyzing key business metrics.

 

Key Responsibilities:

  • Develop/execute and manage reporting needs for Technicolor as a whole utilizing varies system tools, including Business Objects for internal and external customers with complex requirements.
  • Analyze data for trends, patterns, accuracy and use data to draw conclusions/produce key take-aways and executive summaries and dashboard style reports.
  • Communicate and work with customers to clarify discrepancies and resolve issues.
  • Prepare a variety of reports daily, weekly, bi-weekly, monthly and quarterly that reflects the business process in Manufacturing, Distribution and Transportation for major customers.
  • Develop complex reporting processes and databases used for forecasting and analyzing operational and financial data.
  • Develop, manipulate and integrate data from multiple sources to produce reports for supply chain organization.
  • Produce quarterly business review presentations- data gathering, data mining, creating graphs, and trend analysis.
  • Manage/maintain financial and order data in Access and SQL Databases.
  • Develop/maintain business intelligence reporting for internal/external clients.
  • Create, design, program and maintain databases and write complex SQL codes for automation of reporting.
  • Update and test databases, including revamping, reprogram and fine-tune as needed.
  • Scripting: write advanced SQL codes, extract data for advanced analysis in Excel to discover meaningful analytical findings, and ad-hoc scripting as needed for increased automation.
  • Document processes and provide training to Analysts as needed.

Qualifications / Qualifications

Qualifications: 

  • Bachelor's degree in business or logistics preferred.
  • 2 + years of work experience in a similar reporting and data analysis role, with prior responsibility for generating and managing executive level reports.
  • Experience with using statistical modeling for decision support purposes is preferred.
  • Media/entertainment, logistics or supply chain environment preferred.
  • High degree of software knowledge (i.e. Microsoft Word, Excel, PowerPoint, Access, Outlook, and SQL).
  • Advanced Excel
  • Ability to create macros
  • Automate data updates
  • SQL
  • Scripting, data manipulation
  • Database design
  • ETL – Extract, transform, load – migrate data from one database to another.
  • Ability to integrate data from different systems and various sources.
  • Must work independently and in groups with minimal guidance.
  • Ability to meet constantly changing deadlines and prioritize work.
  • Strong quantitative and analytical skills and the ability to handle details and resolve problems.
  • Must have excellent written and verbal communication skills.
  • Exposure to supply chain price structure, contracts, and performance metrics a plus.

 

Technicolor is an equal opportunity employer. Applicants are considered for employment without regard to race, religion, creed, color, national origin, ancestry, medical condition (including genetic characteristics), mental and/or physical disability or handicap, marital status, sex, age, veteran status, citizenship status, sexual orientation, gender identity, political party preference, political belief, socioeconomic status, familial status, registered domestic partner status, military service, pregnancy, childbirth and related medical conditions and any other characteristic or activity protected by federal, state or local law.

Apply for this job / Posez votre candidature pour cet emploi

Share on your newsfeed