Data Analyst

Job Description:

Overview

The Data Analyst partners across Finance, Accounting, Supply Chain, and Operations to build, automate, and maintain the sales, cost, and shipping. This role owns how our products are costed and shipped across the US, EU, Canada, and Australia. You'll develop the reporting leadership relies on, analyze carrier rates and surcharges, and respond to ad-hoc data requests that shape day-to-day business decisions. It carries a wide range of high-impact projects and significant room for ownership. Successful candidates are self-directed, organized, and eager to take problems from question through to solution. 
The Data Analyst 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 sales, cost, and ecommerce reporting across multiple regions and currencies

• Develop and maintain SQL/BigQuery queries to deliver clean, reliable data to business partners

• Analyze shipping and freight costs, including carrier rates, surcharges, dim-weight, and peak-season increases. Quantify the impact of rate changes and contract proposals

• Maintain landed-cost, COGS, and manufacturing P&L models, including cost tracking and duty/tax reconciliation, and audit them for accuracy and variances

• Automate recurring reporting through scheduled jobs and scripting. Reduce manual work and future-proof existing processes

• Respond to ad-hoc data and analysis requests from stakeholders and leadership to support pricing, sourcing, logistics

• Identify issues and opportunities, then recommend and implement process and business improvements

• Bachelor's degree in a relevant field (Finance, Accounting, Economics, Statistics, Data Analytics, or similar)

• 0–3 years of analytics experience; new grads with strong relevant coursework, internships, or projects are encouraged to apply

• Working knowledge of SQL (writing queries, joins, aggregations); exposure to BigQuery or another cloud data warehouse is a plus.

• Advanced Microsoft Excel/Google Sheets skills, including building and maintaining complex models

• Self-motivated and comfortable working in a fast-paced, deadline-driven environment with limited direction. A genuine go-getter who takes ownership

• Strong organization and attention to detail across many concurrent projects

• Familiarity with Python, R, or JavaScript preferred

• Interest in or exposure to cost accounting, shipping/logistics, or manufacturing operations is a plus

By applying to Rogue, regardless of the platform you choose to use, you are agreeing to Rogue's preferred methods of communication (i.e. text message). Submitting an application, through whatever online forum is ultimately used, constitutes a knowing and voluntary agreement to send and receive text messages during the recruitment process.