Data Analyst

Data Analyst role focused on optimizing profitability of inventory assets through statistical and financial analysis across multiple departments, reporting to the Lead Data Analyst.

Responsibilities

• Build and refine analytic models of sales and performance indicators to support strategic forecasting.
• Collaborate with colleagues across systems and departments to collect, validate, and scrutinize financial results.
• Scan historical data to detect lucrative opportunities and recalibrate models based on prior findings to reveal new revenue streams.
• Leverage data insights to identify high-potential live events and oversee the daily online purchasing of event tickets.
• Preserve organized, accurate electronic documentation for all models and daily operations to ensure traceability and compliance.

Requirements

• Education: Bachelor's degree in Statistics, Economics, Finance, Mathematics, Accounting, or a related quantitative field.
• Experience: 1–2 years in professional data or analytics roles; 2–5 years strongly preferred.
• Technical stack: Advanced Excel reporting capabilities required.
• Programming: Proficiency with SQL is required.
• Desirable: Experience with statistical software.
• Business knowledge: Strong understanding of standard accounting principles and financial data trends.
• Soft skills: Excellent communication and interpersonal abilities, heavy phone and email collaboration with internal stakeholders, meticulous attention to detail, and the ability to prioritize multiple tasks efficiently.

Technologies

• SQL
• Excel

Benefits

• 401(k)
• Dental insurance
• Health insurance
• Life insurance
• Vision insurance

Physical & Special Requirements

• Regular and reliable attendance is expected.
• Predominantly sedentary work in an office setting.
• Ability to lift or move up to 20 pounds regularly, with occasional lifting up to 50 pounds.

Job Type

• Full-time

Pay

• From USD 55,000 per year

Location

• Mission, KS (onsite)

Application Questions

• Describe a time when you used SQL to extract data and Excel to model or analyze it for a business decision. What formulas or advanced Excel functions (e.g., VLOOKUP/XLOOKUP, Pivot Tables, Index/Match) did you rely on?
• On a scale of 1-5, how would you rate your SQL proficiency?
• This position requires regular, predictable on-site attendance at our office. Are you currently residing within a reliable commuting distance of Mission, KS?