Business Data Analyst - Dealer Data Management

Job Summary Innova Software Services Inc. is seeking an experienced Business Data Analyst to support Dealer Data Management (DDM), data governance, data quality, service operations, and dealer data programs. The ideal candidate will have strong experience in automotive data environments, dealer management systems, enterprise data warehousing, SQL analysis, business requirements documentation, and cross-functional stakeholder coordination.

Title:Business Data Analyst Dealer Data Management
Location: Fountain Valley, California, USA
Experience: 5+ Years
Work Arrangement:Onsite

Job Summary

Innova Software Services Inc. is seeking an experienced Business Data Analyst to support Dealer Data Management (DDM), data governance, data quality, service operations, and dealer data programs.

The ideal candidate will have strong experience in automotive data environments, dealer management systems, enterprise data warehousing, SQL analysis, business requirements documentation, and cross-functional stakeholder coordination.

Key Responsibilities

Dealer Data Management and Governance

• Support dealer data management programs and related data governance activities.

• Analyze dealer data processes, data quality issues, and operational requirements.

• Collaborate with business and technical teams to define data governance and quality requirements.

• Support metadata management and data validation processes.

SQL and Data Analysis

• Develop SQL queries for data extraction, profiling, validation, and reporting.

• Analyze data exceptions, inconsistencies, and quality issues.

• Support data reconciliation and issue investigation.

• Prepare data analysis reports and communicate findings to stakeholders.

Business Analysis and Documentation

• Gather and document business and functional requirements.

• Prepare Business Requirements Documents (BRDs), Functional Requirements Documents (FRDs), and user stories.

• Create process flows, data-flow diagrams, and related documentation.

• Translate business requirements into actionable technical specifications.

Testing and Project Delivery

• Develop test plans, testing documentation, and user acceptance testing (UAT) materials.

• Support testing, issue tracking, and resolution.

• Collaborate with project teams throughout the software development lifecycle.

• Coordinate with stakeholders to support enterprise data delivery initiatives.

Required Qualifications

• Bachelor's degree in Management Information Systems, Computer Science, Business Analytics, or a related field, or equivalent relevant experience.

• 5+ years of experience in technical program management, project management, business analysis, data governance, data quality, or enterprise data delivery.

• Experience in automotive data environments, data warehousing, dealer data, dealer management system integrations, after-sales operations, or STAR-standard data.

• Strong SQL experience, preferably Oracle SQL.

• Experience with data extraction, profiling, validation, exception analysis, and reporting.

• Experience preparing BRDs, FRDs, user stories, process flows, data-flow diagrams, test plans, and UAT documentation.

• Working knowledge of data governance, data quality, metadata management, and SDLC practices.

• Strong analytical, presentation, communication, and stakeholder management skills.

Preferred Qualifications

• Master's degree in a related discipline.

• Experience with automotive dealer data programs.

• Familiarity with dealer management system (DMS) integrations.

• Experience with automotive service operations and after-sales data.

• Knowledge of STAR-standard automotive data.

• Experience with enterprise data warehousing environments.