Data Analyst

Robotic Process Automation LLC

Pleasanton (CA)

On-site

USD 110,000 - 140,000

Full time

48 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

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Job Description :

Required 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.

Preferred Qualifications :

  • Familiarity with procurement or sourcing data, such as contracts, suppliers, renewals, ACV and TCV, and notice periods. Workday Strategic Sourcing experience is a strong plus.
  • Experience with Unity Catalog, data lineage tools, or data governance practices.
  • Exposure to LLM-based or semantic matching use cases, including how to evaluate match quality.
  • Experience with IT asset management, software asset management, or application portfolio management data.
  • Familiarity with endpoint or usage telemetry, such as Nexthink, and with privacy‑aware handling of usage data.
  • Experience with the Google Sheets and Drive APIs as data sources.
  • Working knowledge of Python or PySpark.
  • Familiarity with role-based or row-level access patterns in dashboards
  • Experience with Agile delivery, Jira, and Confluence.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst
Data Analyst

Valiant Technologies LLC • Pleasanton (CA)

On-site
USD 120,000 - 180,000
Data Analyst
Data Analyst

CloudBigD • Pleasanton (CA)

On-site
USD 110,000 - 160,000
Data Analyst
Data Analyst

Robotics Technologies • Pleasanton (CA)

On-site
USD 90,000 - 140,000
Data Analyst
Data Analyst

Quantum Technologies LLC • Pleasanton (CA)

On-site
USD 120,000 - 170,000
Data Analyst
Data Analyst

Ethereum Technologies LLC • Pleasanton (CA)

On-site
USD 120,000 - 160,000
Data Analyst
Data Analyst

CloudBigD • Weehawken (NJ)

On-site
USD 65,000 - 90,000
Data Analyst
Data Analyst

Robotic Process Automation LLC • Weehawken (NJ)

On-site
USD 65,000 - 90,000
Data Analyst
Data Analyst

Quantum Technologies LLC • Weehawken (NJ)

On-site
USD 65,000 - 90,000
Data Analyst
Data Analyst

Ethereum Technologies LLC • Weehawken (NJ)

On-site
USD 65,000 - 95,000
Data Analyst
Data Analyst

Robotics Technologies • Weehawken (NJ)

On-site
USD 65,000 - 90,000