Pricing and Merchandising Data Solutions Analyst

Dealer Tire; Kentucky; On-site; USD 70,000 - 110,000; Full time

Job summary

Dealer Tire is seeking a Pricing & Merchandising Data Solutions Analyst to drive data-driven decisions across Pricing, Merchandising, and AOR. You will compile and analyze large data sets, build reports, and collaborate with Finance, IT, and Supply Chain to optimize revenue and margins.

Ideal candidates will have strong Excel/PowerBI, SQL, and Python skills, plus a bachelor’s degree in a related field. This role offers exposure to enterprise data tools and strategic growth opportunities within

Qualifications

• Bachelor’s degree in business, finance, economics, statistics or related field.
• 2–4 years of experience in performance analytics, financial analysis, pricing/product analysis or related field.
• Excel and PowerBI at intermediate to advanced level; Alteryx or analytic automation software preferred.
• Proficiency in MS Excel, Database, VBA, and SQL.
• Strong analytics tools (Alteryx, SQL, Python) and visualization platforms (PowerBI, Tableau).
• Experience with statistics, data modeling and handling large data sets.
• Excellent attention to detail and cross-functional collaboration and communication.

Responsibilities

• Compile and analyze data related to Pricing, Merchandising & AOR.
• Audit large data sets to ensure accuracy and identify trends.
• Develop reports and metrics; provide interpretations and recommended actions.
• Support Pricing, Merchandising, AOR, and Finance with advanced analytics.
• Collaborate with Supply Chain, Sales, IT and Marketing to develop solutions.
• Maintain tools to represent profitability for Pricing, Merchandising and AOR.

Skills

Excel

PowerBI

Alteryx

SQL

Python

Tableau

VBA

Database

Statistics

Data modeling

Education

Bachelor’s degree in Business/Finance/Economics/Statistics or related field

Tools

SQL Server Management Studio

MS Excel

Job description

As an Pricing & Merchandising Data Solutions Analyst, your essential job functions will include the following:

Data Management

• Compile and analyze Dealer Tire data related to Pricing, Merchandising & AOR.


• Audit and analyze large data sets to ensure accuracy in all information.


• Leverage new and existing technologies in most efficient ways possible (can include, but not limited to: data warehouse solutions, Alteryx, Snowflake, R-Studio, Excel, VBA,SQL Server Management Studio) to identify trends and make recommendations.


• Identify the components of a problem and apply appropriate analytics techniques to create solutions.


• Support Pricing, Merchandising, AOR, and Finance teams with advanced analytics and, if assigned, also provide support for all DT family companies.


• Assemble, manage and distribute operational reports and metrics, providing others with interpretations of the results and suggestions on actions to be taken.


• Utilize data & analytics to support Dealer Tire in achieving annual revenue and margin targets.


• Work collaboratively with other teams in the organization to develop solutions, including but not limited to: Supply Chain, Sales, Program Management, IT, Marketing.


• On an ad-hoc basis, provide support/analysis to Finance, Program Management, Sales, Supplier Relations, and Inventory Management.


• Collaborate with others in the organization to streamline data analytics and processes, ensuring consistent approach and strategy.


• Maintain/create tools to that accurately represent profitability in various ways for Pricing, Merchandising and AOR.


• Analyze gross margin impact and revenue impact of recommendations made to Pricing, Merchandising and AOR teams.

Position Requirements

• Bachelor’s degree in a Business, Finance, Economics, Statistics, or business-related field required.


• Minimum of 2-4 years’ experience in a technical role focused on performance analytics, financial analysis, pricing/product analysis or other related business field.


• Intermediate to advanced skills using Excel and PowerBI required. Experience with Alteryx or other analytic process automation software preferred.


• Proficiency in MS Excel, Database, VBA, and SQL.


• Strong proficiency in analytical tools (e.g., Alteryx, SQL, Python) and visualization platforms (e.g., PowerBI, Tableau)


• Expertise with statistics, data modeling, and manipulation of large data sets.


• Strong attention to detail, organizational skills, interpersonal, verbal and written communication, problem solving and time management skills.


• Ability to develop and maintain complex data bases


• Strong analytical ability, including the ability to gather, analyze and evaluate information and to translate concepts into financial / operational models


• Possess basic knowledge and understanding of business and finance/accounting


• Excellent interpersonal, communications, and organizational skills with ability to succeed in a cross functional working environment


• Critical Thinking/Analytical Skills


• Time & Productivity Management


• Detail Orientated


• Business Acumen


• Results Orientation


• Agility


• Initiative


• Influence


• Customer Focus

Physical Job Requirements

• Sitting for long periods of time.


• Continuous viewing and inputting data into a computer screen.


• Travel domestically as required (<10%).

Drug Policy

• Dealer Tire is a drug-free environment. All applicants being considered for employment must pass a pre-employment drug screening before beginning work