Pricing and Merchandising Data Solutions Analyst

Dealer Tire; Kentucky; On-site; USD 65,000 - 90,000; Full time

Job summary

Dealer Tire is seeking a Pricing & Merchandising Data Solutions Analyst to compile and analyze data across pricing, merchandising and AOR functions. The role involves auditing large datasets, leveraging tools like Alteryx, Snowflake, R-Studio, Excel, VBA, and SQL Server to identify trends and shape strategic recommendations.

Operates across Finance, IT, Marketing, Supply Chain, and Sales. The ideal candidate has 2–4 years in a technical analytics role, strong Excel and PowerBI skills, and solid

Qualifications

• Bachelor’s degree in a business-related field is required.
• 2–4 years’ experience in performance analytics, financial analysis, pricing/product analysis, or related field.
• Proficient in Excel and PowerBI; Alteryx experience preferred.
• MS Excel, Database, VBA, and SQL proficiency needed.
• Strong analytical skills with knowledge of tools like Alteryx, SQL, Python and visualization platforms (PowerBI, Tableau).
• Experience handling large data sets and data modeling is required.

Responsibilities

• Compile and analyze pricing, merchandising, and AOR data.
• Audit large data sets for accuracy.
• Identify trends and make data-driven recommendations.
• Prepare operational reports and metrics with actionable insights.
• Collaborate with cross-functional teams (Supply Chain, Sales, IT, Marketing).
• Support Finance and other DT family companies with analytics.

Skills

Excel

PowerBI

Alteryx

SQL

Python

Tableau

VBA

Education

Bachelor’s degree in Business/Finance/Economics/Statistics

Tools

Alteryx

SQL Server Management Studio

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.

Other Duties as Assigned

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