Sr Data Analyst

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.