Data Analyst – Python, SQL & AI/ML (Onsite, Fremont or Menlo Park, CA)

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

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