Junior Data Analyst in at Auto Care Association

The Auto Care Association is seeking a motivated and detail-oriented Junior Data Analyst to support the day-to-day operation, maintenance, and reliability of the Association's data systems, reporting platforms, and automation processes.

This role focuses on maintaining and supporting existing solutions. The Junior Data Analyst will help ensure databases, reports, workflows, and operational processes remain accurate, efficient, and dependable while providing timely support to internal stakeholders.

The position serves as a key operational resource by supporting data quality, troubleshooting technical issues, maintaining business intelligence reporting, and assisting with process documentation and continuous improvement efforts. By assuming ownership of routine technical support and maintenance functions, this role enables senior technical staff to focus on new development initiatives, process modernization, scalable solution design, and long-term strategic planning.

This position serves as the primary operational support resource for data systems, reporting platforms, and automation processes, helping ensure continuity, reliability, and data quality while enabling senior technical staff to focus on new development, architecture, and strategic initiatives.

Working closely with the SQL Database Developer, this role provides hands-on experience with enterprise databases, reporting systems, automation processes, and operational data management while offering a clear growth path into more advanced technical and analytical roles.

• Maintain and update existing database objects, including tables, views, stored procedures, and scheduled processes.
• Perform routine data validation, reconciliation, and quality assurance reviews.
• Investigate and resolve data integrity issues and operational data discrepancies.
• Support database performance monitoring and assist with optimization efforts.
• Execute and monitor recurring data imports, exports, and operational data processes.
• Assist with database updates, releases, and maintenance activities.

• Maintain and enhance existing Power BI dashboards and operational reports.
• Support report updates, data model adjustments, and visualization improvements.
• Monitor and validate Power BI dataset refreshes and reporting processes.
• Perform data validation to ensure reporting accuracy and consistency.
• Respond to routine reporting requests and operational data inquiries from internal stakeholders.
• Assist business users with report troubleshooting and interpretation.

• Monitor and maintain existing automation scripts, scheduled jobs, and data workflows.
• Troubleshoot automation failures and implement approved enhancements.
• Support Python-based and SQL-based automation processes.
• Review automated job outputs, error logs, and exception reports.
• Assist with testing, deployment, and validation of process improvements.
• Identify opportunities for incremental automation and operational efficiencies.

• Support recurring data imports, exports, scheduled jobs, and operational data processes.
• Monitor existing SQL-based, Python-based, and reporting-related workflows to ensure successful completion and identify exceptions.
• Assist with troubleshooting failed processes, incomplete data loads, report refresh issues, and data inconsistencies.
• Support routine validation of source data, transformed data, and published reports.
• Maintain documentation for recurring jobs, report logic, data sources, workflow dependencies, and escalation procedures.
• Support database updates, releases, and related documentation activities.
• Follow established documentation and version control practices when updating scripts, reports, dashboards, and operational processes.
• Escalate complex development, performance tuning, integration, or database architecture issues to senior technical staff when appropriate.

• Perform routine data analysis and research to support business and operational needs.
• Fulfill recurring data requests from internal teams.
• Investigate and resolve data discrepancies identified by business users.
• Support operational reporting and recurring business processes.
• Assist users with troubleshooting data, reporting, and system-related issues.
• Provide timely and professional support for operational data needs.

• Maintain technical documentation, standard operating procedures, and process guides.
• Assist with documenting existing systems, reports, and automation workflows.
• Help identify areas where processes can be simplified, standardized, or improved.
• Support knowledge transfer and process continuity initiatives.
• Contribute to maintaining accurate and up-to-date operational documentation.

• Associate's or Bachelor's degree in Computer Science, Information Systems, Data Analytics, MIS, Business Technology, or a related field.
• Equivalent combination of education and relevant work experience may be considered.

• Working knowledge of SQL, including queries, joins, views, and basic stored procedure concepts.
• Basic to intermediate Python skills for scripting, automation, and data manipulation.
• Familiarity with Power BI or similar business intelligence platforms.
• Experience working with Microsoft Excel and structured datasets.
• Understanding of relational database concepts and data management best practices.

• Strong analytical and problem-solving abilities.
• Excellent attention to detail and commitment to data quality.
• Strong organizational and time-management skills.
• Ability to manage multiple priorities and routine operational tasks.
• Effective written and verbal communication skills.
• Ability to work independently while collaborating across teams.
• Strong customer-service mindset and responsiveness to stakeholder requests.

• Experience supporting business users in a data-driven environment.
• Exposure to ETL processes, data integration, or scheduled data workflows.
• Familiarity with Microsoft SQL Server environments.
• Familiarity with Power Query, DAX, or Power BI Service.
• Familiarity with GitHub, Azure DevOps, or similar version control tools.
• Exposure to APIs, XML, JSON, Postman, Swagger, or structured data exchange processes.
• Understanding of database indexing and optimization concepts.
• Experience working with automotive aftermarket data, data standards, or structured reference databases is a plus.

Why join us?

At Auto Care Association, we recognize and appreciate that each employee’s unique experiences, perspectives, and viewpoints add value to our ability to create and deliver the best possible service, technical assistance, and research to members and partners.

Our Core Values of Teamwork, Curiosity, Integrity, and Fun (TCIF) help to create an environment where all employees feel valued, included, and empowered to do their best work, and bring great ideas to the table. We operate as one team, accountable to one another and grow stronger by sharing knowledge, collaborating, and working toward common goals. We embrace change and constantly strive to be better through seeking out information and learning from one another. We lead by example and do what’s right, even when no one is looking. We also very much enjoy our time at work by creating opportunities to have fun and develop friendships.