Sr. Data Analyst

Technicolor Inc Camarillo , CA 93012

Posted 2 months ago

Work Location: Camarillo, CA (Greater Ventura Area)


Home Entertainment Services

Overview:

Technicolor is home to industry-leading creative and technology professionals committed to the creation, management and delivery of entertainment content to consumers around the world. Propelled by a culture of innovation and underpinned by a dedicated research organization, the company's thriving licensing business possesses an extensive intellectual property portfolio focused on imaging and sound technologies. Serving motion picture, television, and other media clients, the company is a leading provider of high-end visual effects, animation, and post-production services. In support of network service providers and broadcasters globally, Technicolor ranks among the world leading suppliers of digital content delivery services and home access devices, including set-top-boxes and gateways. The company also remains a large physical media service provider, being one of the world's largest film processors and independent manufacturers and distributors of DVDs and Blu-ray discs.

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. Make decisions on work methods which improve processes, productivity, and efficiencies. This role has an impact on the business in terms of organization strategy in dealing with third party vendors and the work methods used to provide contract agreed practices, pricing and communications for best results.

Essential Functions: Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Responsibilities:

  • Develop and execute Daily/Weekly/Monthly/Quarterly/Annual SLA and KPI reports for major customers including tool management control

  • Prepare a variety of reports daily, weekly, bi-weekly, monthly and quarterly that reflect business process in Manufacturing and Distribution for major customers

  • Develop/execute/ manage reporting needs for Technicolor as a whole utilizing various Technicolor system tools, including Business Objects and SAP for internal and external customers with complex requirements.

  • Analyze data for trends, patterns, accuracy and use data to draw conclusions/produce key takeaways, executive summaries and dashboard style reports for key customers

  • Communicate and work with customers to clarify discrepancies and resolve issues

  • Develop complex reporting processes used for forecasting and analyzing operational and financial data

  • Manipulate and integrate data from multiple sources to produce reports for supply chain organization by gathering data, data mining, creating graphs, and trend analysis to support business requirements with key customers

  • Scripting: write advanced macros, SQL codes, extract data for advanced analysis in Excel to discover meaningful analytical findings, and ad-hoc scripting as needed for increased automation of reporting

  • Maintain relationship with large studio clients as it relates to Account Management Manufacturing/Distribution Reporting

  • Identify & document issues and concerns, assess feasible resolutions, present options, and change plans as see fit for best practices

  • Manage issues up front to avoid escalation - eliminate bottlenecks and single point of failures to keep the team functioning at a steady pace

  • Participate in process improvement efforts and project management

  • Support commercial projects (management across Global supply chain) and execution of key projects for new contract requirements

Required Education and Experience

  • Bachelor's degree in business management, marketing, or related field preferred or equivalent combination of education and experience

  • 2 + years of work experience in a similar reporting and data analysis role, with prior responsibility for generating and managing executive level reports

  • Excellent analytical, keen attention to detail and problem-solving abilities are key for this role

  • Strong system knowledge including SAP, Excel, Word, Access, PowerPoint, and Outlook (SQL, Business Objects is a plus)

  • ETL Extract, transform, load migrate data from one database to another

  • Must have knowledge of contract administration, terms and have ability to interpret contracts

  • Must have excellent written and verbal communication skills

Additional Eligibility Qualifications

  • Experience with using statistical modeling for decision support purposes is preferred

  • Media/entertainment, Logistics or supply chain environment preferred

  • Independent, self-starter, ability to handle a high volume of work is required

  • Exceptional organization skills, self -directed, able to multi-task and reprioritize tasks for self and team as necessary under pressure

  • Must be able to develop reports, download data from current systems, conduct appropriate analysis, prepare presentations and communicate recommendation within deadlines

  • Ability to successfully work in a fast-paced work environment

  • Ability to professionally interact with all levels of management both internally and with studio clients

  • Strong understanding of order to cash flow

  • Must be professional, dependable, and able to work both independently and in a collaborative team atmosphere

  • Positive, flexible, and proactive approach to all work situations and possess good business acumen and judgment

COMPETENCIES

Communication = Expert

Accountability mindset = Advanced

Relationship Management = Expert

Integrity and Trustworthiness = Expert

Collaboration = Advanced

Change Management = Proficient

Work Environment

  • This job operates in a professional office environment. This role routinely uses standard office equipment such as laptop computers, phones, photocopiers, filing cabinets, and smartphones

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of the job. While performing the duties of this job, the employee is regularly required to talk or hear. The employee is frequently required to stand; walk; use hands to finger, handle or feel; and reach with hands and arms. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus.

Travel

  • Minimal local travel is expected for this position

TECHNICOLOR IS AN EQUAL OPPORTUNITY EMPLOYER

Technicolor complies with all Federal, State and Local law prohibiting discrimination on the basis of 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.


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
Sr Financial Analyst

Technicolor Inc

Posted 1 week ago

VIEW JOBS 9/11/2019 12:00:00 AM 2019-12-10T00:00 Work Location: Camarillo (Los Angeles area), CA Home Entertainment Services Overview: Technicolor Global Logistics (TGL) provides value added supply chain solutions with proven expertise in solving complex, end-to-end transportation and logistics challenges. After decades of experience in optimizing the supply chains for major Hollywood studios and other content publishers, TGL now serves a variety of market segments including gaming, technology, electronics, and other consumer products and high-value goods. TGL is a supply chain partner providing comprehensive multi-mode and optimization strategies that leverage the size and scale of the Technicolor organization, resulting in greater control and centralized visibility across the entire supply chain. Position Summary:The Senior Financial Analyst in the TGL Finance team will report to the Division's Controller and interact with TGL operations, Financial Shared Service center accounting, and Controlling team on a regular basis. Key function is Financial reporting and data analysis in support of Actual, Forecast, and Budget reporting for the division. Essential Functions: Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. 1/Manage financial reporting * Prepare and maintain financial reporting, including month end details and key metrics reporting * Analyze and support monthly P&L performance and prospective analysis * Prepare forecast based on input from business unit (Sales and Operational teams) * Identifies and communicates weekly financial status/trending by reviewing operational data * Prepare data and analysis for Audit requests (internal, external, and bank audits) 2/Manage general ledger accounting and month end close processes * Manage and perform day-to-day general accounting for assigned functional area (freight services) with support from the Financial Shared Services Center (FSSC) teams * Support month end close process and data analysis required to aggregate actuals * Collect operational reporting in support of month end close processes * Reconcile transactions by comparing and correcting data * Prepare accrual data by customer * Review accounting transactions for data accuracy 3/Collaborate with Operations, Accounts Receivable (AR), and Accounts Payable (AP) functions * Manage and perform day-to-day AR and AP for assigned function area (freight services) with support from the FSSC teams and Customer billing team * Prepare analysis and provide performance KPIs for GL, AR, and AP functions * Prepare and communicate exception reporting for GL, AR, and AP functions and identify areas for improvement * Manage processing and allocation of vendor refunds 4/Research and resolve business unit inquires for assigned functional area (freight services) * Compare forecasted actual results and identify areas of improvement related to order to cash and procurement to cash cycles 5/Procedures and processes * Document processes * Identify and communicate areas for improvement Required Education * Bachelor's degree in Business, Finance, Logistics, Economics or related field preferred or equivalent education, training and experience required * CPA / MBA preferred Required Experience * 5+ years' relevant industry and finance/accounting experience * High degree of proficiency in MS Office (heavy emphasis on Excel and PowerPoint), web-based, and Windows based software and databases * Proficient with accounting software required (SAP Business Warehouse and Business Objects a plus) Additional Eligibility Qualifications * Logistics experience preferred * Ability to interface and communicate effectively with multiple functional groups, geographic regions, diverse cultures, and different levels of internal organizations * Well-developed/professional communication skills and style; excellent interpersonal skills and the ability to work effectively with all levels of employees * Highly self-motivated with ability to handle multiple projects and deadlines within an ever-changing environment * Excellent judgment and creative problem-solving skills, including conflict resolution * Ability to make independent decisions in a changing environment and anticipate future needs * Identifies and resolves problems in a timely manner, gathers and analyzes information skillfully, works well in group problem solving situations and offers solutions * Solid negotiation and collaboration skills - able to influence outcomes and bring initiatives to successful completion through multiple departmental teams * Energetic, flexible, collaborative and proactive * Ethics: works with integrity and ethics, upholds organizational values Supervisory Responsibility No direct reports - leadership qualities needed for providing direction and motivating others Work Environment This job operates in a professional office environment. This role routinely uses standard office equipment such as laptop computers, phones, photocopiers, filing cabinets, fax machines and smartphones. Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of the job. While performing the duties of this job, the employee is regularly required to talk or hear. The employee is frequently required to stand; walk; use hands to finger, handle or feel; and reach with hands and arms. Specific vision abilities required by this job include close vision, distance vision, peripheral vision, depth perception and ability to adjust focus. Travel No travel is expected for this position Other Duties Please note this Job Profile is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities may change at any time with or without notice. TECHNICOLOR IS AN EQUAL OPPORTUNITY EMPLOYER Technicolor complies with all Federal, State and Local law prohibiting discrimination on the basis of 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. COMPETENCIES LEVEL Critical Thinking Advanced Accountability Advanced Integrity and Trustworthiness Expert Listening/Communication Expert Innovation & Risk Taking Proficient Technicolor Inc Camarillo CA

Sr. Data Analyst

Technicolor Inc