company_logo

Full Time Job

Sr Data Analytics Analyst

Warner Bros. Discovery

Mexico City, Mexico 02-12-2023
 
  • Paid
  • Full Time
  • Senior (5-10 years) Experience
Job Description
Every great story has a new beginning, and yours starts here.

Welcome to Warner Bros. Discovery… the stuff dreams are made of.

Who We Are…

When we say, ''the stuff dreams are made of,'' we're not just referring to the world of wizards, dragons and superheroes, or even to the wonders of Planet Earth. Behind WBD's vast portfolio of iconic content and beloved brands, are the storytellers bringing our characters to life, the creators bringing them to your living rooms and the dreamers creating what's next…

From brilliant creatives, to technology trailblazers, across the globe, WBD offers career defining opportunities, thoughtfully curated benefits, and the tools to explore and grow into your best selves. Here you are supported, here you are celebrated, here you can thrive.

The Job:

This position will support the management of the WBD Global Business Services organization through specialized O2C and P2P reporting and analysis. This will require periodic and ad-hoc reports and reporting tools for internal and external customers; This position will support reporting and analysis at the corporate level, as well as divisional level. This position will also assist with high-profile asset financing reports such as AR Securitizations, and AR Factoring; This position will assist in mitigating and minimize risk in accounts receivable portfolio Financial Risk by performing customer level credit risk analysis, and portfolio level financial risk analysis to mitigate.

The Daily:
• Accounts Receivable and Accounts Payable Portfolio Reporting
• Researches, analyzes and synthesizes large amount data from multiple sources into business information for Global WBD Order to Cash and Purchase to Pay.
• Create into reports and reporting tools to provide visibility for key AR and AP stakeholders.
• Create reporting to assist stakeholders and leadership in AR Collections, Cash Target, AP Payments, and Cash Disbursement decisioning.
• Provide company-wide as well as division-specific reporting.
• Ensure quality and accuracy of reporting through strong understanding and analysis of data.
• Supports the monthly financial analysis with operations.
• Create and maintain periodic and ad-hoc reports using various reporting software like Hyperion Essbase, SAP Business Objects, SQL, MS Suite, PowerBI, and Peoplesoft Query.
• Continually assess and implement automation of reporting and portfolio analytics.
• KPIs, Metrics and High-Profile Reporting
• Responsible for sourcing and consolidating data for high-profile company AR reports like AR Securitization, Factoring and Bad Debt Reserves. Assist with division-specific reporting and manage consolidated company-wide reporting.
• Manage the various internal and external processes and communications to ensure compliance with all contractual and compliance protocols.
• Create reporting for leadership with Key Performance Indicators, and metrics to assist AR, AP and resource performance evaluation and trending.
• Prepare dashboards and ad-hoc reporting for senior leadership.
• Analyze AR reports, data, and metrics to identify business drivers, opportunities and risks.
• Analyze and assess potential credit risk of all portfolio tranches (Agency holding company, advertiser, industry, region/country) to identify trends and potential issues.
• Where appropriate, review and analyze relevant financial statements and credit bureau information. Monitor exposure per risk category.
• Communicate trends and potential issues to appropriate stakeholders.
• Based on WBD O2C Global Credit Policy, review customer credit worthiness performed by Risk & Reporting Analyst. Perform deeper dive analysis as needed.
• For new clients, make decisions regarding credit approval; or, for existing clients, communicate findings and recommendations to collection team.
• Participate and contribute to periodic reviews of credit risk policies and procedures.
• Assists in reviewing work produced by more junior level team members

The Essentials:
• Associate or Bachelor degree in Business, Finance, or Accounting
• Experience in reporting from ERPs like SAP, Peoplesoft and/or Oracle
• Strong understanding of accounts receivables/accounts payables reporting principles & processes
• Strong understanding of general accounting principles (preferred)
• Ability to use & navigate across various systems & software programs
• Must have strong work ethic & work independently
• Must have ability to manage multiple priorities & competing deadlines
• Advanced analytical skills with the ability to explain & present findings in an easy-to-understand language.
• Advanced English (verbal & written)

Nice to Have:
• 5+ years in finance/accounting reporting experience
• Experience working with accounts receivable, accounts payable
• Experience working with credit risk analysis
• Advanced skills reconciling reports for accuracy from datasource
• Advanced Excel skills (pivot tables, lookup formulas, sumfis, index-matchs, if-then formulas, left, right, mid, etc)
• Experience in working with SAP Business Objects, and/or SQL
• Experience working with various reporting & data visualization tools (Power BI, Tableau, etc)
• Experience working in Media/Entertainment Industry

Warner Bros. Discovery embraces the opportunity to build a workforce that reflects the diversity of our society and the world around us. Being an equal opportunity employer means that we take seriously our responsibility to consider qualified candidates on the basis of merit, regardless of sex, gender identity, ethnicity, union status, age, sexual orientation, religion or belief, marital status, pregnancy, parenthood, disability or any other category protected by law.

If you're a qualified candidate with a disability and you need a reasonable accommodation in order to apply for this position, please contact us at recruitadmin@warnermedia.com.

How We Get Things Done…

This last bit is probably the most important! Here at WBD, our guiding principles are the core values by which we operate and are central to how we get things done. You can find them at www.wbd.com/guiding-principles/ along with some insights from the team on what they mean and how they show up in their day to day. We hope they resonate with you and look forward to discussing them during your interview.

The Legal Bits…

Warner Bros. Discovery embraces the opportunity to build a workforce that reflects the diversity of our society and the world around us. Being an equal opportunity employer means that we take seriously our responsibility to consider qualified candidates on the basis of merit, regardless of sex, gender identity, ethnicity, union status, age, sexual orientation, religion or belief, marital status, pregnancy, parenthood, disability or any other category protected by law.

If you're a qualified candidate with a disability and you need a reasonable accommodation in order to apply for this position, please contact us at recruitadmin@warnermedia.com.

Jobcode: Reference SBJ-rzq0j7-3-138-33-87-42 in your application.