Sr Data Analyst

Role overview

Responsibilities

• Lead databases for company parts, OE and competitor cross-references, vehicle applications, pricing, and related product information.
• Develop SQL queries, data models, and transformations to integrate internal and external sources.
• Analyze product performance, application coverage, competitive offerings, and market trends to identify gaps and opportunities.
• Build pricing analysis tools and recommend pricing decisions based on cost, competition, and margin objectives.
• Design and maintain Power BI dashboards and reports for product performance, pricing, catalog coverage, and business measures.
• Establish validation processes, business rules, and documentation to improve product and catalog data accuracy.
• Lead analysis projects from requirements and data preparation through validation, presentation, and implementation support.
• Automate recurring data preparation, reporting, and quality checks using SQL, Python, and other suitable tools.
• Prepare and present competitive analyses and recommendations to product managers, department leaders, and stakeholders.
• Support print and electronic catalogs and customer data submissions in line with ACES and PIES standards.
• Resolve product data discrepancies, application questions, and customer inquiries with Product Management, Sales, Engineering, and other teams.
• Improve data availability, database performance, reporting, and system integration; mentor junior analysts and promote consistent methods.

Qualifications

• Bachelor’s degree in a related analytics, science, computer science, information systems, or business analytics field, or equivalent education and relevant experience.
• Five or more years of progressively responsible experience in data analysis, business intelligence, product data management, or a related field.
• Advanced SQL, including complex queries, joins, transformations, troubleshooting, and optimization; proficiency in Python for data preparation, analysis, validation, and automation.
• Power BI dashboard and report development, including data modeling, DAX, and Power Query.
• Strong understanding of relational databases, data warehousing, and ETL; advanced Excel and experience analyzing large, complex datasets.
• Ability to manage projects independently, define requirements, prioritize requests, and deliver accurate work on deadlines.
• Strong analytical, problem-solving, communication, and presentation skills, including explaining technical information to nontechnical audiences.
• Experience with data quality controls, process documentation, and mentoring or providing technical guidance to analysts.