Asset Protection Data Analyst

Overview:

Who we are

Imagine working in a place where continuous improvement and innovation is celebrated and rewarded; where fast-paced, high-impact teams come together to positively drive results for one of the largest & most iconic brands in the world.

As the only rapidly growing retailer, you may know us as your friendly neighborhood store. You probably know our familiar name, have seen our pervasive logo, and have tried our highly sought-after products, such as Slurpee® and Big Bite®. “Brain Freeze” is a 7-Eleven registered trademark for our 53-year old Slurpee® and with over 67,000 stores globally (more than any other retailer or food service provider), we sell over 14 million a month.

But there’s a lot more to our story and much more left to be written. We are transforming our business, ensuring we are customer obsessed and digitally enabled to seamlessly link our brick and mortar stores with digital products and services.

At 7-Eleven the entrepreneurial spirit is in our DNA and has been ever since our inception 90+ years ago. It’s what drove us to invent the convenience industry in 1927 by envisioning how a simple ice dock could provide household staples such as milk and eggs to better serve the needs of our customers.

Today we are redefining convenience and the customer experience in big ways...we are fundamentally changing our culture and we want talented, innovative, customer obsessed, and entrepreneurial people like you to come make history with us.

How we lead

At 7-Eleven we are guided by our Leadership Principles.

Be Customer Obsessed

Be Courageous with Your Point of View

Challenge the Status Quo

Act Like an Entrepreneur

Have an “It Can Be Done” Attitude

Do the Right Thing

Be Accountable

Each principle has a defined set of behaviors which help guide the 7-Eleven team to Serve Customers and Support Stores.

Responsibilities:

Provide business intelligence support to the organization in support of the four pillars of the Asset Protection Department: Revenue and Profit Assurance, Inventory Variation Control, Incidents and Investigations, and Safety and Security. Support Asset Protection, Legal, Accounting, and Operations with analysis and reports designed to provide exceptions, trends, legal support and financial results of various risk areas within the company.

Duties and Responsibilities:

Translate business needs into analytical work products using several software packages including those used for building reports, identifying exceptions, dashboards/scorecards and other guided analysis applications. (PowerBI)

Build data models through extract-transform-load (ETL) methods and associate the metadata and training material with the model.

Maintain standards for delivery, quality, and visual presentation of delivered BI solutions.

Provide system administrator support for the exception-based reporting tool (Secure) and case management tool (APIS).

Support the physical inventory audit process with reporting and store notification processes.

Prepare financial reporting for all areas of risk on the Store P&L including standard routine reporting, trending or forecast analysis, and exception-based analytics.

Execute the routine store notification (IAR) process.

New program analysis to identify areas of risk.

Partner with other areas utilizing reporting expertise contained within the Analytics Team.

Work with the business unit to gather requirements for report generation.

Work with business customers and IT SME to define BI requirements.

Train end-users on new reports and dashboards.

Conduct various Ad hoc analysis.

Gasoline Shortage Analysis and Loss Mitigation.

Qualifications:

Bachelors/ 4 Year Degree in Finance, Accounting, General Business, Mathematics, Statistics or Information Management

Knowledge of Inventory Accounting Processes, GAAP & Financial Reporting

Solid knowledge of SQL Server, PowerBi required, data mining programming languages, MS Excel and Access, and be able to conceptualize, design, develop and deploy BI solutions

PDI, Oracle GL & other Oracle platforms/systems

Strong analytical knowledge, comprehensive understanding of retail business acumen (mathematics, statistical concepts) to analyze and develop financial reports

Hands-on experience with numerous data sources (structured & unstructured) as well as manage multiple projects concurrently

Excellent interpersonal skills; articulate communicator

Thorough understanding of GAAP

Self-motivated and able to work independently as well as collaboratively in a team environment

#LI-TK1

Permanent