Data Analyst – Python, SQL & AI/ML (Onsite, Fremont or Menlo Park, CA)
$40 - $55/yr
About the Role We’re looking for a curious, analytical data analyst with strong Python and SQL skills and a solid understanding of machine learning and modern AI. You’ll work with large datasets, answer business questions with data, and help find ways AI can improve analytics work at a leading Bay Area technology company. Employment Details * Full-time, W-2 employee of 1 Data Analytics Inc., placed on a long-term client engagement * Long-term contract, renewed annually based on performance * Onsite in Fremont or Menlo Park, CA (not a remote position) Responsibilities * Write SQL to pull, join, and analyze data to find trends, rankings, and anomalies * Clean, transform, and analyze datasets using Python (Pandas) * Apply basic statistical and machine learning methods, and explain when they fit and when they don’t * Explore practical uses of LLMs, RAG, and AI agents in analytics workflows * Present findings clearly to technical and non-technical stakeholders Required Experience * 5+ years of professional experience in data analysis, data engineering, or software development (experience gained before or during graduate school counts) Required Skills Python and Data Manipulation * Pandas: reading, cleaning, and manipulating datasets * Core data structures: lists, tuples, dictionaries, and sets * Loops, conditions, functions, calculations, and data transformations SQL * JOINs, CTEs, and aggregations * Window functions such as RANK(), DENSE_RANK(), LAG(), and LEAD() * Writing SQL to identify trends and rankings Machine Learning and Statistics * Regression and classification; supervised vs. unsupervised learning * Training and testing data, overfitting, and model evaluation basics * Correlation, mean, median, standard deviation, and distributions * Advanced ML coding is not required, but you should understand these concepts and be able to explain where they apply Modern AI Concepts * Large Language Models (LLMs), prompting, and hallucination * Embeddings and vector databases * Retrieval-Augmented Generation (RAG) and AI agents * Most importantly: ideas on how AI can be used in data analytics Communication * Able to explain your projects clearly and concisely: the problem, the data, what you personally built, the technologies you used, and the result Preferred Qualifications * Master’s degree in Computer Science, Data Science, Analytics, Statistics, Engineering, or a related field * Portfolio or GitHub projects showing relevant data or ML work Work Authorization Candidates must be authorized to work in the US for this employer without sponsorship. We welcome OPT, STEM OPT (E-Verify employer), H-4 EAD, GC EAD, green card holders, and US citizens. We are unable to sponsor or transfer H-1B visas. Interview Process * Short recruiter screen * Technical interview with a brief hands-on Python and SQL exercise How to Apply Send your resume to 1da-jobs@1dataanalytics.com and include: * Phone number * Total years of experience * Expected salary * Current location Pay: $40.00 - $55.00 per hour Expected hours: 40.0 per week Work Location: In person