Sr Data Analyst

Walker Products Inc.; Pacific (MO); On-site; USD 90,000 - 135,000; Full time

Job summary

Walker-Products-Inc. seeks a Senior Data Analyst to drive complex data analysis and data management initiatives across product management, pricing, and catalog development. You will turn raw data into actionable recommendations that support portfolio decisions and business growth.

The role independently manages analytical projects, improves data accuracy, and serves as a technical resource for cross-functional teams and junior analysts, shaping data-driven strategies.

Qualifications

• Bachelor's degree in Data Analytics, Data Science, CS, or related field.
• Five+ years in data analysis, BI, or product data management.
• Advanced SQL with complex queries and optimization.
• Proficiency in Python for data prep and automation.
• Experience building Power BI dashboards and data models.
• Strong Excel skills for large datasets.
• Ability to manage projects and meet deadlines.
• Excellent communication and presentation skills.
• Experience mentoring junior analysts.

Responsibilities

• Lead development and maintenance of databases for parts, pricing, catalog data.
• Develop SQL queries and data models to integrate internal and external data.
• Analyze product performance and market trends to identify gaps.
• Design and maintain pricing analysis tools and margin goals.
• Create Power BI dashboards with reliable insights on key measures.
• Establish data validation processes and documentation.
• Lead analytics projects from requirements to delivery.
• Automate data preparation and checks using SQL and Python.
• Prepare competitive analyses and present findings to stakeholders.
• Support catalogs and data submissions aligned with ACES/PIES standards.
• Collaborate with IT to improve data availability and integration.
• Mentor junior analysts and promote consistent methods.
• Perform other duties as assigned.

Skills

Project management

Advanced analytical skills

Communication skills

Problem solving

Data storytelling

Education

Bachelor's degree in Data Analytics / related field

Tools

SQL

Python

Power BI

Excel

Job description

JOB DESCRIPTION

Job Title: Senior Data Analyst

Department:Data Analytics & Catalog

SUMMARY:

The Senior Data Analyst leads complex data analysis and data management initiatives supporting product management, pricing, competitive research, and catalog development. This position transforms product, application, pricing, and market data into actionable recommendations that support product portfolio decisions and business growth.

The role independently manages analytical projects, improves data accuracy and reporting processes, and serves as a technical resource for cross-functional teams and junior analysts.

PRIMARY RESPONSIBILITIES:

1. Lead the development, maintenance, and improvement of databases containing company parts, OE and competitor cross-references, vehicle applications, pricing, and related product information.
2. Develop and optimize SQL queries, data models, and data transformation processes to integrate information from internal systems and external sources.
3. Analyze product performance, application coverage, competitive offerings, and market trends to identify product line gaps, expansion opportunities, and areas for improvement.
4. Develop and maintain pricing analysis tools incorporating product costs, competitive pricing, and margin objectives; provide recommendations to support pricing decisions.
5. Design, build, and maintain Power BI dashboards and reports that provide clear, reliable insights into product performance, pricing, catalog coverage, and other key business measures.
6. Establish and maintain data validation processes, business rules, and documentation to improve the accuracy, consistency, and completeness of product and catalog information.
7. Lead analytical projects from initial business requirements through data preparation, analysis, validation, presentation, and implementation support.
8. Automate recurring data preparation, reporting, and quality checks using SQL, Python, and other appropriate tools.
9. Prepare competitive analyses and present findings and recommendations to product managers, department leadership, and other stakeholders.
10. Support the development and maintenance of print catalogs, electronic catalogs, and customer data submissions, including alignment with applicable ACES and PIES standards.
11. Investigate and resolve complex product data discrepancies, application questions, and customer inquiries in collaboration with Product Management, Sales, Engineering, and other departments.
12. Partner with IT and business teams to improve data availability, database performance, reporting capabilities, and system integration.
13. Mentor junior analysts, review analytical work, and promote consistent methods for data analysis, reporting, and documentation.
14. Perform other related duties as assigned by management.

KNOWLEDGE AND SKILL REQUIREMENTS:

1. Bachelor's degree in Data Analytics, Data Science, Computer Science, Information Systems, Business Analytics, or a related field, or an equivalent combination of education and relevant experience.
2. Five or more years of progressively responsible experience in data analysis, business intelligence, product data management, or a related field.
3. Advanced SQL skills, including complex queries, joins, data transformation, troubleshooting, and query optimization.
4. Proficiency in Python for data preparation, analysis, validation, and process automation.
5. Demonstrated experience developing Power BI dashboards and reports, including data modeling, DAX calculations, and Power Query transformations.
6. Strong understanding of relational databases, data warehousing concepts, and extract, transform, and load (ETL) processes.
7. Advanced Microsoft Excel skills and experience analyzing large, complex datasets from multiple sources.
8. Demonstrated ability to independently manage projects, define requirements, prioritize competing requests, and deliver accurate results within established deadlines.
9. Strong analytical and problem-solving skills, with the ability to translate findings into practical business recommendations.
10. Excellent communication and presentation skills, including the ability to explain technical information to nontechnical audiences.
11. Experience establishing data quality controls, documenting processes, and mentoring or providing technical guidance to other analysts.