Data Analytics and Reporting Auditor

Job Summary                                                                                                                                                                            

The Data Analytics & Reporting Auditor is responsible for extracting, validating, and analyzing data from enterprise systems—primarily Oracle—to support inventory accuracy, operational decision-making, and internal investigations. This individual will audit key reporting processes, identify system discrepancies, and present findings to stakeholders through dashboards and structured reports using BI tools such as Power BI, Tableau, and Excel.

 Key Duties and Responsibilities                                                                                                                                                                            

Oracle Data Auditing & Validation

• Query and audit inventory movement, returns, transfers, and refunds from Oracle Analytics Cloud using SQL.
• Test and validate data integrity across system outputs and reporting tools.
• Support root cause analysis (RCA) of known issues and work closely with IT and data team.

Operational Reporting & Analysis

• Analyze inventory discrepancies across locations and cross-reference against invoices, orders, and pickups.
• Audit report accuracy tied to spoilage, returns, transfers, and invoicing processes.
• Collaborate with field operations to investigate data issues brought forward by regional teams.

Dashboard Development & Visualization

• Build intuitive dashboards and visual reports with BI tools such as Power BI and Tableau to support executive decision-making.
• Organize complex data into clean formats for weekly, monthly, and ad-hoc reporting.
• Present findings clearly to non-technical teams, translating data into actionable business insights.

Security, Safety & Investigative Support

• Deliver structured datasets to Security and Safety teams identifying specific times, locations, customers, or employees to review.
• Track and log potential theft or fraud cases for escalation.
• Monitor and contribute to stolen inventory logs (KPA reports) and alert leadership when red flags arise.

Cross-Functional Collaboration

• Work closely with IT, Operations, and Oracle support to help refine system thresholds, stop blind returns, and improve data pipelines.
• Assist with the development of new inventory accountability policies and validation protocols.

Qualifications: Knowledge, Skills & Abilities                                                                                                                                                                            

• 3+ years of professional experience in data testing, auditing, analytics, investigator, or reporting roles.
• Strong SQL skills and working knowledge of Oracle RDS and APEX or similar query tools.
• Experience at a retail distribution level preferred
• Certified Forensic Interviewer preferred and experience with Wicklander/Zulawski (WZ) or Reid techniques
• Proficient in BI tools such as Power BI or Tableau.
• Expert in Microsoft Excel, including advanced formulas, pivot tables, Power Query, and error tracing.
• Exce