We are looking for a practical, data-driven Sales Operations Analyst I to fill a critical role within our Sales & Trading department. In this position, you will act as the bridge between raw data and actionable business strategy. You will be responsible for managing data pipelines, automating pricing workflows, and maintaining the reporting infrastructure that our sales floor relies on daily.
Key Responsibilities
Data Pipeline & Reporting Management (Redshift & QuickSight)
- Manage and maintain data flows within AWS Quicksight to ensure the sales team has access to real-time, accurate data.
- Design, build, and maintain interactive dashboards in AWS QuickSight to track KPIs, sales trends, and inventory metrics.
Sales Operations & Process Automation
- Utilize advanced Excel macros to automate manual tasks, specifically regarding pricing sheets, dealer communication, and inventory updates.
- Streamline sales workflows to reduce friction and allow the sales team to focus on selling rather than data entry.
- Monitor and execute critical daily operational tasks, including Auto-Pricing and Platform Gold Pricing.
- Territory Management
- CRM and Reporting
Sales Analytics & Strategy
- Analyze sales data to identify areas of opportunity in pricing strategies, margin analysis, and sales representative productivity.
- Conduct competitor analysis and market research to ensure competitive pricing across all products.
- Provide leadership with actionable insights derived from clean, structured data.
Core Operational Duties
You Will Own The Following Specific Processes
- Pricing Updates: Auto-Pricing, Platform Gold Pricing, Pre-33/Silver Dollar Pricing Updates, and General Metals Pricing.
- Dealer Communication: Dealer Sheet generation and Constant Contact Dealer Sheet Link Emails.
- Analysis: Comp Analysis and Greysheet Monthly Analysis.
- Maintenance: General data pipeline maintenance tasks.
Qualifications
Qualifications
Required Technical Skills
- Python: Intermediate proficiency required. Must be able to write scripts for automation, data cleaning, and process optimization.
- SQL: Strong proficiency required. Ability to write complex queries, joins, and manage data within a data warehouse environment.
- Excel: Expert level required. Must be comfortable with VBA/Macros and complex formulas.
- CRM: Ability to operate within Salesforce at a proficient level.
Education & Experience
- Bachelor’s degree in Business Analytics, Information Systems, Economics, Computer Science, or a related field.
- 2+ years of experience in a Sales Operations, Business Analyst, or Data Analyst role.
- Hands-on experience with AWS Redshift and Amazon QuickSight (or similar BI tools like Tableau/PowerBI).
Soft Skills
- Strong analytical/problem-solving mindset with an attention to detail.
- Ability to communicate technical data concepts to non-technical sales stakeholders.
Total Rewards Package
- Competitive compensation based on experience
- Annual performance bonus opportunity
- Up to 6% company match on 401(k)
- Employer-paid profit-sharing and cash balance plans
- Comprehensive medical, dental, vision and Employee Assistance plans
- HSA and FSA plans (pre-tax benefit)
- Company paid STD, LTD, Life and AD&D
- Supplemental coverage available including Critical Illness, Accident, Hospitalization and Pet
- PTO and paid holidays
- Employee discounts
- Extensive on the job training and opportunities for advancement
