Sr Data Analyst

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

Job summary

Walker Products Inc. seeks a Senior Data Analyst to lead complex data analysis and data management initiatives supporting product management, pricing, and catalog development. The role will transform product, pricing, and market data into actionable recommendations for portfolio decisions and growth.

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

Qualifications

• Bachelor's degree or equivalent experience in data analytics or related field.
• 5+ years in data analysis, BI, or product data management.
• Advanced SQL with complex queries and optimization.
• Proficient in Python for data preparation and automation.
• Experience building Power BI dashboards with data modeling & DAX.
• Strong understanding of data warehousing and ETL concepts.
• Advanced Excel skills and large dataset handling.
• Excellent communication and presentation abilities.

Responsibilities

• Lead development and improvement of databases for parts, cross-references, applications, and pricing.
• Develop and optimize SQL queries, data models, and data transformations.
• Analyze product performance, market trends, and gaps for growth.
• Create pricing analysis tools and support pricing decisions.
• Design and maintain Power BI dashboards for key business metrics.
• Establish data validation processes and documentation.
• Lead analytics projects from requirements to implementation support.
• Automate data preparation, reporting, and quality checks with SQL and Python.
• Prepare competitive analyses and present findings to stakeholders.
• Support print/electronic catalogs and data submissions with ACES/PIES alignment.
• Investigate data discrepancies with cross-functional teams.
• Collaborate with IT to improve data availability and system integration.
• Mentor junior analysts and promote standardized methods.
• Perform other duties as assigned by management.

Skills

Advanced SQL

Python for data preparation

Power BI dashboards

Data analysis

Data modeling

DAX calculations

ETL concepts

Excel (advanced)

Project management

Communication

Mentoring

Cross-functional collaboration

Education

Bachelor's degree in Data Analytics or related field

Tools

Power BI

SQL

Python

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.