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
Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
Partner with clients on R&D strategy and platform implementations (Veeva, Medidata, IQVIA). Support process improvements across Clinical, Quality, Regulatory, and Safety domains, run qualitative/quantitative analyses, synthesize recommendations, coordinate project execution, mentor associates, and communicate results to clients and teams.
Top Skills:
GxpIqviaMedidataVeeva
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
What you need to know about the Los Angeles Tech Scene
Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.
Key Facts About Los Angeles Tech
- Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
- Key Industries: Artificial intelligence, adtech, media, software, game development
- Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
- Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering
