Pricing Data Analyst

Rogue Fitness; United States; On-site; USD 90,000 - 120,000; Full time

Job summary

Rogue Fitness is seeking a Pricing Data Analyst to own how Rogue prices its products. The role is fully onsite in Columbus, Ohio; remote work is not available. You will build pricing templates, develop SQL/BigQuery pipelines, and analyze margins and landed costs to support profitability across regions.

Applicants should have 3–5 years as a data analyst in pricing or related fields, with strong SQL and Excel/Google Sheets skills and experience in automation using Python or R.

Qualifications

• 3–5 years in a data analyst, cost, financial, pricing, or related role.
• Proficient in SQL; BigQuery or cloud data warehousing a plus.
• Advanced Excel/Google Sheets for complex models and calculators.
• Ability to interpret tariffs, duties, freight, and material costs.
• Familiarity with R or Python for automation and reporting.
• Strong communication and attention to detail in fast-paced settings.

Responsibilities

• Build, maintain, and automate pricing templates and margin reporting.
• Develop SQL/BigQuery queries and data pipelines for pricing data.
• Analyze margin and landed-cost by order/SKU including tariffs and freight.
• Quantify impact of price/cost changes and track results post-go-live.
• Monitor cost drivers and flag pricing changes for leadership.
• Maintain regional pricing logic and templates.
• Provide scenario modelling for cost changes and economic shifts.
• Support pricing updates, budgeting, and forecasting.
• Collaborate with Sales, Operations, Procurement, Finance for inputs.
• Identify data-quality issues and implement workflow improvements.
• Prepare reports on margin performance, pricing risks, and actions.

Skills

SQL

BigQuery

Excel

Google Sheets

Python

R

Data analysis

Pricing

Communication

Education

Bachelor's degree in Finance/Accounting/Economics/Statistics/Data Analytics

MBA

Tools

BigQuery

Excel

Job description

The Pricing Data Analyst owns how Rogue prices its products and is a fully onsite role in Columbus, Ohio. Remote work is not available.

Applicants must be authorized to work in the United States for any employer.

Responsibilities

• Build, maintain, and automate pricing templates and margin reporting, reducing manual work and future-proofing existing processes.
• Develop and maintain SQL/BigQuery queries and pipelines to deliver clean, reliable pricing and cost data.
• Perform order- and SKU-level margin and landed-cost analysis - tariffs, duty/HTS rates, freight, and shipping components - to ensure pricing supports profitability targets across regions and currencies.
• Quantify the impact of price and cost changes (raw materials, freight, tariffs/duty, etc) and track results after changes go live.
• Monitor economic and cost drivers, proactively flag when changes require pricing updates, and recommend actions to leadership.
• Maintain and improve regional pricing logic and templates.
• Provide scenario modeling for cost changes, competitive pressure, customer programs, and economic shifts.
• Support quarterly, annual, and ad-hoc pricing updates, plus budgeting and forecasting related to pricing and cost trends.
• Collaborate with Sales, Operations, Procurement, Supply Chain, and Finance to gather accurate cost inputs and validate pricing assumptions.
• Identify data-quality and process issues, then recommend and implement improvements to pricing accuracy and workflows.
• Prepare reports that highlight margin performance, pricing risks, economic impacts, and recommended actions.

Qualifications

• Bachelor's degree in a relevant field (Finance, Accounting, Economics, Statistics, Data Analytics, or similar); MBA a plus.
• 3-5 years in a data analyst role, cost, financial, or, pricing or equivalent.
• Working knowledge of SQL (writing queries, joins, aggregations); experience with BigQuery or another cloud data warehouse is a plus.
• Advanced Excel/Google Sheets skills, including building and maintaining complex models, lookups, and calculators.
• This is a modeling- and data-intensive role.
• Ability to interpret tariffs, duty/HTS codes, freight and logistics charges, and raw-material cost inputs.
• Familiarity with R or Python for automation and scripting preferred; experience automating recurring reporting (scheduled jobs, scripting) is a plus.
• High attention to detail and accuracy across many concurrent projects.
• Strong communication skills, with the ability to present findings and recommendations clearly.
• Self-motivated and comfortable in a fast-paced, in-office, deadline-driven environment with limited direction.

About Rogue

Rogue Fitness is the leading manufacturer of strength and conditioning equipment, including barbells, power racks, sleds, and accessories.

Founded in a garage in 2006, the company has grown to over 1400 team members globally.

Rogue is the official equipment supplier of the CrossFit Games, USA Weightlifting, the Arnold Strongman Classic, and the World's Strongest Man competition.

The company remains dedicated to serving the needs of serious athletes at every level, from the garage to the arena.