Data and Reporting Coordinator

Job Description: Data & Reporting Coordinator

Position Overview

David Weisz Fine Jewelry is seeking a detail-oriented technically proficient Data & Reporting Coordinator to manage company reporting maintain product and pricing data and oversee our retailer sales incentive program.

The ideal candidate has strong experience with Power BI and advanced Excel is comfortable working with large amounts of data and can independently develop reports based on managements needs.

Key Responsibilities

1. Power BI Reporting & Data Analysis

* Build maintain and update Power BI dashboards and reports.

* Generate sales inventory financial and operational reports as requested by management.

* Develop new reports based on specific business needs.

* Gather organize and analyze information from company software and other data sources.

* Ensure reports are accurate reliable and updated regularly.* Troubleshoot reporting issues and resolve discrepancies.

2. Database & Product Information Management

* Learn and work within our LogicMate/JewelMate inventory management software.

* Perform bulk updates to pricing product information and other database records.

* Maintain accurate product data including style numbers descriptions costs and pricing.

* Generate and customize reports from the companys existing software.

* Assist with catalog updates price lists and other data-related projects.

* Coordinate with other departments to obtain and verify information before making updates.

3. Retailer Sales Incentive Program

* Take full responsibility for administering the companys retailer sales incentive program.

* Monitor and process incentive submissions received from participating retailers.

* Verify submitted sales against company records in LogicMate.

* Calculate incentive rewards during the programs semiannual processing periods.

* Track rewards earned distributed redeemed and outstanding.

* Communicate directly with retailer managers and sales associates regarding submissions eligibility balances and rewards.

* Respond to inquiries resolve discrepancies and request missing information.

* Prepare and distribute reward dollars to participating retailers and sales associates.

* Maintain complete and accurate incentive program records.

4. Excel Reporting & Administrative Data Support

* Create and maintain advanced Excel spreadsheets and reports.

* Organize clean and analyze data exported from company systems.

* Perform data comparisons reconciliations and calculations.

* Prepare reports and information requested by management or other departments.

* Assist with special projects involving pricing inventory sales information or data organization.

Required Qualifications

* Strong hands-on experience with Microsoft Power BI including dashboard development Power Query data modeling and DAX.

* Advanced Microsoft Excel skills including formulas pivot tables lookups and working with large datasets.

* Experience working with databases business management software or ERP systems.

* Ability to understand reporting requirements and independently build accurate reports.* Excellent organizational skills and attention to detail.

* Strong written and verbal communication skills.

* Ability to manage multiple responsibilities and meet deadlines.

* Comfortable learning new software and internal business processes.

* Ability to work independently while coordinating effectively with other departments.

Training Provided

Training will be provided on LogicMate/JewelMate the companys internal procedures product information and retailer incentive program.

What Were Looking For

Someone who is analytical organized resourceful and dependable. This person should enjoy working with numbers and systems be comfortable handling detailed administrative responsibilities and have the technical ability to turn data into useful business reports.

The position requires both technical expertise and the ability to manage ongoing responsibilities accurately and independently.