Data Analyst
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.