Extract, clean, and validate sales and financial data from systems (Salesforce, Shopify, QuickBooks, CSVs); build and maintain KPI dashboards and recurring reports; perform QA checks, reconciliations, segmentation, and ad-hoc analyses; document KPI definitions and reporting logic to ensure data consistency and accuracy.
Company Description
Junior Data Analyst (Operations / Sales Analytics)
Location: Cerritos
Employment Type: Full-time, On-site
$25-$28/hr (DOE)
Full Benefit
We are seeking a hands-on Junior Data Analyst (1–3 years of experience) to support our Strategic Operations team. This role is focused on data execution, reporting, and accuracy across multiple systems including sales and financial data.
The ideal candidate is detail-oriented, reliable, and capable of working with structured data to ensure accuracy and consistency across operational reports.
- Extract, clean, and prepare data from systems such as Salesforce, Shopify, QuickBooks, and CSV files
- Build and maintain KPI dashboards and recurring reports (daily, weekly, monthly)
- Support sales and operational performance reporting
- Perform data validation, QA checks, and identify discrepancies across systems
- Assist with data analysis, segmentation, and ad-hoc reporting requests
- Maintain clear documentation for KPI definitions and reporting logic
- Ensure consistency and accuracy of data used in reporting
- 1–3 years of experience in data analysis, reporting, or similar role
- Strong Excel or Google Sheets skills (Pivot Tables, VLOOKUP/XLOOKUP, data handling)
- Experience working with CSV files and combining multiple data sources
- High attention to detail and strong data accuracy mindset
- Ability to work independently with structured guidance
- Preferred Qualifications
- Basic SQL knowledge
- Experience with Tableau or Power BI
- Exposure to sales or financial data environments
All your information will be kept confidential according to EEO guidelines.
Similar Jobs
Automotive • eCommerce • Manufacturing
Prepare, clean, and validate sales and financial data from Salesforce, Shopify, QuickBooks, and CSVs. Build and maintain KPI dashboards and recurring reports, perform QA checks, support sales and operations reporting, conduct ad-hoc analysis and segmentation, and document KPI definitions and reporting logic to ensure data accuracy and consistency.
Top Skills:
CsvExcelGoogle SheetsPivot TablesPower BIQuickbooksSalesforceShopifySQLTableauVlookupXlookup
Fintech • Professional Services • Sales • Financial Services
Lead development, maintenance, and monitoring of credit risk models and loss forecasts. Extract and analyze large datasets with Python/SQL, automate reporting and dashboards, perform EDA and stress/sensitivity analyses, document audit-ready model deliverables, support model governance/validation, and communicate insights to stakeholders to inform credit policy and decisioning.
Top Skills:
CklightboxGoogle Cloud PlatformOscilarPythonPython WidgetsSQLTableauTaktileXgboost
Fintech • Financial Services
Grow and manage relationships with affluent customers by providing advisory, multi-product banking solutions across deposits, lending, investments, and home/business banking. Proactively acquire new customers, lead discovery-based planning, coordinate with Wealth/Home Lending/Business partners, support branch service needs, champion digital adoption, and maintain accurate documentation and regulatory compliance. Role requires obtaining and maintaining FINRA and state insurance licenses.
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
