Data Analyst 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 management's 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 company's 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 company's 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 program's 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 company's internal procedures, product information, and retailer incentive program. What We're 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.