Senior Data Analyst: Data Warehouse, Lakehouse & SQL Expert

Robotic Process Automation LLC

Pleasanton (CA)

On-site

USD 110,000 - 140,000

Full time

39 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Robotic Technologies Automation in Pleasanton, CA is seeking an experienced Business Systems/Data Analyst to join our data-driven team. You will work on data warehouse, data lake, or lakehouse programs, writing source-to-target mappings and validating join logic across multiple source systems.

The role requires strong SQL skills, hands-on Databricks experience (notebooks, Delta Lake, Spark SQL), and the ability to read transformation code.

Qualifications

  • 5 or more years as a Business Systems Analyst or Data Analyst on data warehouse, data lake, or Lakehouse programs. A track record of writing detailed source-to-target mappings and join logic across multiple source systems.
  • Strong SQL, including joins, window functions, and profiling and reconciliation queries.
  • Hands-on experience with Databricks, including notebooks, Delta Lake, and Spark SQL.
  • You should be able to read and review transformation code.
  • Experience mapping data from semi-structured or user-maintained sources, such as spreadsheets, and handling schema drift and incomplete records.
  • Strong grasp of data modelling concepts, including keys, entity resolution, and curated-layer design.
  • Strong written communication, and the ability to produce clear documentation with little rework.
  • Proven ability to work independently on short timelines with minimal onboarding.

Skills

Data analysis
SQL proficiency
Documentation
Independent work
Communication
Data modeling

Tools

Databricks
Delta Lake
Spark SQL
Python
PySpark
Jira
Confluence

Job description

Robotic Technologies Automation in Pleasanton, CA is seeking an experienced Business Systems/Data Analyst to join our data-driven team. You will work on data warehouse, data lake, or lakehouse programs, writing source-to-target mappings and validating join logic across multiple source systems.

The role requires strong SQL skills, hands-on Databricks experience (notebooks, Delta Lake, Spark SQL), and the ability to read transformation code.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst (Senior) - Lakehouse, SQL, Databricks
Data Analyst (Senior) - Lakehouse, SQL, Databricks

Robotics Technologies • Pleasanton (CA)

On-site
USD 90,000 - 140,000
Senior Data Analyst – Databricks & Lakehouse
Senior Data Analyst – Databricks & Lakehouse

CloudBigD • Pleasanton (CA)

On-site
USD 110,000 - 160,000
Senior Data Analyst: Lakehouse, Databricks & Data Governance
Senior Data Analyst: Lakehouse, Databricks & Data Governance

Valiant Technologies LLC • Pleasanton (CA)

On-site
USD 120,000 - 180,000
Senior Databricks Developer - Lakehouse & Spark Expert
Senior Databricks Developer - Lakehouse & Spark Expert

Robotic Technologies Automation • Louisville (KY)

On-site
USD 110,000 - 170,000
Data Engineer for AI/ML Analytics & Lakehouse
Data Engineer for AI/ML Analytics & Lakehouse

Robotic Process Automation LLC • Minnetonka (MN)

On-site
USD 56,000 - 94,000
Senior Data Engineer: Cloud Lakehouse & AI Analytics
Senior Data Engineer: Cloud Lakehouse & AI Analytics

Robotic Process Automation LLC • Atlanta (GA)

On-site
USD 83,000 - 124,000
Senior Data Analyst - Lakehouse & SQL Expert
Senior Data Analyst - Lakehouse & SQL Expert

Ethereum Technologies LLC • Pleasanton (CA)

On-site
USD 120,000 - 160,000
Senior Databricks Data Engineer - AWS Lakehouse
Senior Databricks Data Engineer - AWS Lakehouse

Robotic Technologies Automation • Harrisburg

On-site
USD 83,000 - 131,000
Senior Data Platform Engineer: Lakehouse, Streaming & CI/CD
Senior Data Platform Engineer: Lakehouse, Streaming & CI/CD

Robotic Process Automation LLC • Atlanta (GA)

On-site
USD 120,000 - 180,000
Senior Databricks Engineer: Lakehouse, Delta Lake & AWS
Senior Databricks Engineer: Lakehouse, Delta Lake & AWS

Robotic Process Automation LLC • Wilmington (DE)

On-site
USD 90,000 - 128,000