We are looking for a Data Analyst to support reporting, audience targeting, and data-driven decision-making for a manufacturing organization in Diamond Bar, California. This Long-term Contract position partners closely with business stakeholders to translate operational goals into meaningful reports, reliable datasets, and actionable audience lists. The ideal candidate brings strong analytical skills, hands-on experience with SQL and Excel, and the ability to communicate clearly while maintaining high standards for data accuracy.

Responsibilities:

• Partner with business teams to gather reporting needs, clarify audience outreach objectives, and turn those needs into practical data solutions.
• Develop and refine reports, datasets, and audience lists that help stakeholders measure performance and support business priorities.
• Write and troubleshoot SQL queries across multiple tables, using joins and backend reporting techniques to extract accurate information.
• Pull, validate, and organize data from platforms such as Salesforce and marketing-related systems to support analysis and campaign targeting.
• Perform data validation checks and investigate quality issues to improve confidence in reporting outputs and audience segmentation.
• Use advanced Excel functions, including PivotTables and lookup formulas, to analyze trends, reconcile data, and present findings clearly.
• Build targeted audience segments and list selections based on defined business rules, data attributes, and outreach requirements.
• Communicate proactively with cross-functional partners to provide status updates, resolve issues quickly, and ensure deliverables align with expectations.