> Markdown version of [/jobs/ext/1313494-junior-data-analyst](https://www.wearedevelopers.com/jobs/ext/1313494-junior-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Junior Data Analyst - **Company:** Dr. J SkinClinic - **Location:** La Palma, CA, United States - **Experience:** Starter - **Salary:** $41,600.0 - $58,240.0 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Data Analysis, Microsoft Basic Data Partition, Spreadsheets, Data Cleansing, Data Dictionary, Lookup Table, Performance Tuning, Pivot Tables, QuickBooks (Software), Power BI, Salesforce.Com, Shopify, SQL Databases, Tableau (Software) - **Published:** July 17, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=48d522ef2dfcf02d ## About the Role * Associate's Degree or equivalent professional work experience. * 1-3 years' experience in a data, analytics, BI, or related role. * Familiarity with spreadsheet tools (Excel, Google Sheets) including formulas and pivot tables. * Experience creating visualizations in Tableau, Power BI, or similar is a plus; not required. Knowledge, Skills, & Abilities * Available to work onsite only. * Strong attention to detail and data accuracy. * Solid analytical thinking and problem-solving. * Clear written and verbal communication skills. * Comfortable working independently within established priorities under general direction. * Eagerness to learn new tools and grow technical skills. * Advanced Excel/Google Sheets (PivotTables, XLOOKUP/VLOOKUP, charts). * Basic understanding of statistical concepts, trend analysis, and KPI performance tracking. * Comfortable extracting data from systems and working with exports (CSV) (required); SQL experience is a plus., * Finance: 3 years (Required) * SQL: 2 years (Preferred) ## Description We are seeking a self-motivated Junior Data Analyst to join our Strategic Operations team. This role is ideal for a professional with 1-3 years of analytical experience who can manage assigned deliverables with periodic check-ins. The successful candidate will support operational and KPI reporting-including sales performance dashboards and other business metrics-while delivering accurate, timely insights that support strategic decision-making and performance optimization. The role will work primarily with data from Salesforce, Shopify, QuickBooks, and other operational datasets, and will collaborate with Finance-related data as needed. This position is not tied to month-end close deadlines. Essential Tasks, Duties, & Responsibilities Data Preparation & Cleaning * Extract and combine data from Salesforce, Shopify, QuickBooks, and spreadsheets. * Perform basic data transformations and ensure data quality and consistency. Reporting Support * Manage reporting requests in alignment with established priorities and timelines. * Build and maintain KPI dashboards and recurring reporting (daily/weekly/monthly) for Strategic Operations. * Produce reporting on sales and operational performance, pipeline/activity (Salesforce), and e-commerce performance (Shopify). * Produce ad-hoc reports and visualizations for stakeholders. * Maintain documentation of KPI definitions and reporting logic; perform routine QA checks to ensure KPI definitions and results are accurate and consistent. General Analytics Support * Assist senior team members and management with exploratory data analysis and segmentation. * Run basic statistical checks and summarize findings in clear, written form. * Help document data sources, definitions, and workflows. BI Deliverables * Support end-to-end delivery of key dashboards/scorecards. * Partner with stakeholders to translate questions into measurable KPIs and reporting logic. * Monitor data anomalies and collaborate to resolve root causes. Process Improvement & Documentation * Identify opportunities to automate recurring tasks and improve reporting efficiency. * Keep documentation up-to-date (data dictionaries, report specs, runbooks). Collaboration * Partner with Strategic Operations and collaborate cross-functionally with Finance and other teams as needed to validate data and definitions. * Communicate results in a clear, non-technical way for business users. General * Perform other tasks and duties as needed and directed by management. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Launching a marketplace on-time: A lesson in taking shortcuts using spreadsheets!](https://www.wearedevelopers.com/videos/477-launching-a-marketplace-on-time-a-lesson-in-taking-shortcuts-using-spreadsheets) - [WeAreDevelopers LIVE - Markdown, Liquid and Checkouts](https://www.wearedevelopers.com/videos/1814-wearedevelopers-live-markdown-liquid-and-checkouts) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [From Global Capability Centers to AI-Powered Command Centers](https://www.wearedevelopers.com/videos/100096-from-global-capability-centers-to-ai-powered-command-centers) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland)