Sr Analyst, Retail Analytics

Pilotcompany; Knoxville (TN); On-site; USD 90,000 - 120,000; Full time

Job summary

Pilotcompany in Knoxville, TN seeks a Senior Data Analyst to transform large, complex datasets into actionable insights and automated dashboards. You will mentor junior analysts and collaborate with cross-functional teams to define KPIs and guide data-driven decisions.

The role emphasizes data quality, scalable reporting, and governance, with advanced skills in SQL, Python, and Tableau/Power BI. Travel and onsite work may be required.

Qualifications

• Bachelor's or Master's degree in business analytics, computer science, or statistics or equivalent experience.
• Minimum 5 years in data analytics or similar roles.
• Advanced proficiency in SQL and Python or R for data manipulation and automation.
• Deep experience with cloud data platforms and ETL workflows.
• Mastery of data visualization with Tableau or Power BI.

Responsibilities

• Analyze large datasets to extract actionable insights and support business plans.
• Lead problem-solving sessions and drive innovative thinking across teams.
• Communicate methodologies clearly to non-technical stakeholders.
• Automate and enhance reports and dashboards using Tableau/Power BI and Python/R.
• Ensure data accuracy, security, and regulatory compliance across projects.

Skills

SQL

Python

Tableau

Power BI

Databricks

Mentoring

Education

Bachelor's or Master's in business analytics / CS / statistics

Tools

Databricks

Job description

The Senior Data Analyst turns large, complex datasets into actionable business insights and automated reporting dashboards. This role collaborates with cross-functional teams to define core KPIs and guide strategic, data-driven decisions through identifying innovative solutions to optimize business performance and drive growth. Additionally, the position requires mentoring junior analysts and maintaining high standards for data quality. Ideal candidates have over five years of experience and advanced skills in SQL, Python, and data visualization tools like Tableau or Power BI.

Responsibilities

• Apply advanced data mining techniques to analyze large datasets, extract insights, and contribute to the development of business plans.
• Lead team problem-solving discussions and exhibit innovative thinking, remaining open to change and feedback.
• Effectively communicate analytical methodologies to non-technical audiences and be a champion of change management with stakeholders.
• Lead the automation and enhancement of advanced reports and dashboards using tools like Tableau, Power BI, and statistical programming languages (R/Python), ensuring outputs are consistently aligned with business goals and decision-making processes at all levels.
• Ensure all analyses, reports, and dashboards adhere to company policies, maintaining data accuracy, integrity, and security while complying with all relevant regulations.
• Ensure all data processes, analyses, and outputs meet the highest standards of accuracy, integrity, and security, while consistently complying with company policies, industry standards, and regulations across all projects.
• Model behaviors that support the company's common purpose; ensure guests and team members are supported at the highest level
• Ensure all activities are in compliance with rules, regulations, policies, and procedures
• Complete other duties as assigned
• Mentor junior analysts as needed.
• Make effective presentations to internal and external top management officials as requested.

Qualifications

• Bachelor's or Master's degree in business analytics, computer science, or statistics required or equivalent combination of education and experience
• Minimum 5 years in (type of work) required or equivalent combination of education and experience
• Advanced proficiency in SQL and Python or R for data manipulation, statistical analysis, and automation.
• Deep experience and familiarity with cloud data platforms (Databricks preferred), ETL workflows, and large-scale, complex datasets.
• Mastery of data visualization tools, such as Tableau (preferred) or PowerBI.
• Expert-level Microsoft Office skills.
• Ability to coach, mentor and motivate a diverse team; ensure team and individual accountability and performance standards are met
• Ability to prioritize, multitask and manage multiple projects successfully in a fast-paced and dynamic environment
• Strong organizational skills with attention to detail
• Ability to communicate and interact effectively with different levels of the organization to negotiate, problem solve, complete projects and influence decision making
• Strong analytical and strategic thinking skills
• Self-motivated with ability to work both independently and within teams in order to establish and meet deadlines, goals, and objectives
• Excellent customer service skills
• Ability to work in a complex, fast-paced environment demonstrating confidence with change and ambiguity
• Strong teamwork, conflict management, influencing, and negotiation skills

Benefits & Physical Requirements

• Overnight travel required is up to 5%
• General office work requiring sitting or standing for long periods of time
• Able to lift up to 30 lbs