Data Systems Analyst: Lakehouse, SQL & Databricks

Bestica Inc.

New York (NY)

On-site

USD 120,000 - 180,000

Full time

9 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

Bestica Inc. is seeking an experienced Business Systems Analyst / Data Analyst to support enterprise data warehouse, data lake, and Lakehouse initiatives at Workday.

The ideal candidate combines business analysis with technical data expertise, focusing on SQL, Databricks, Delta Lake, and Spark SQL to ensure data quality and accurate mappings across pipelines. You will document requirements and collaborate with data engineers and analytics teams.

Qualifications

  • 5+ years of experience as a Business Systems Analyst, Business Analyst, or Data Analyst working on data warehouse, data lake, or Lakehouse programs.
  • Window functions
  • Data reconciliation and validation queries
  • Hands-on experience with Databricks, including:
  • Databricks notebooks
  • Spark SQL
  • Ability to read, understand, and review data transformation code.
  • Experience working with structured and semi-structured data sources, including spreadsheets and user-maintained datasets.
  • Understanding of schema drift, incomplete records, and data quality challenges.
  • Strong knowledge of data modeling concepts, including keys, entity resolution, relationships, and curated-layer design.
  • Excellent written communication and technical documentation skills.
  • Ability to work independently, manage priorities, and deliver within tight timelines with minimal supervision.

Responsibilities

  • Analyze data across multiple source systems and develop detailed source-to-target mappings.
  • Write and optimize complex SQL queries for data analysis and validation.
  • Work hands-on with Databricks notebooks, Delta Lake, and Spark SQL.
  • Document data definitions, mapping logic, transformation rules, and data dependencies.
  • Collaborate with data engineers and analytics teams to meet project deadlines.

Skills

Window functions
Data reconciliation
Databricks
Spark SQL
Review transformation code
Structured data
Semi-structured data
Data modeling
Documentation
Independent work
Agile/Jira

Tools

Databricks
Jira

Job description

Bestica Inc. is seeking an experienced Business Systems Analyst / Data Analyst to support enterprise data warehouse, data lake, and Lakehouse initiatives at Workday.

The ideal candidate combines business analysis with technical data expertise, focusing on SQL, Databricks, Delta Lake, and Spark SQL to ensure data quality and accurate mappings across pipelines. You will document requirements and collaborate with data engineers and analytics teams.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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
Data Analyst (Senior) - Lakehouse, SQL, Databricks
Data Analyst (Senior) - Lakehouse, SQL, Databricks

Robotics Technologies • Pleasanton (CA)

On-site
USD 90,000 - 140,000
Business Systems Analyst / Data Analyst – Databricks & Data Warehousing
Business Systems Analyst / Data Analyst – Databricks & Data Warehousing

Bestica Inc. • New York (NY)

On-site
USD 120,000 - 180,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 Data Analyst: Data Warehouse, Lakehouse & SQL Expert
Senior Data Analyst: Data Warehouse, Lakehouse & SQL Expert

Robotic Process Automation LLC • Pleasanton (CA)

On-site
USD 110,000 - 140,000
Databricks Data Engineer: Lakehouse & Spark Expert
Databricks Data Engineer: Lakehouse & Spark Expert

CloudBigD • Louisville (KY)

On-site
USD 120,000 - 180,000
Senior Data Analyst - Cloud Lakehouse & Analytics Engineer
Senior Data Analyst - Cloud Lakehouse & Analytics Engineer

Compunnel Inc. • San Francisco (CA)

Remote
USD 85,000 - 120,000
Remote Data Engineer – Databricks, PySpark & Lakehouse
Remote Data Engineer – Databricks, PySpark & Lakehouse

Career Sigma Software • United States

Remote
USD 120,000 - 150,000
Remote Lakehouse Data Engineer | Databricks
Remote Lakehouse Data Engineer | Databricks

BairesDev • United States

Remote
USD 120,000 - 180,000
100% remote work
Competitive USD salary
Home office setup provided
+3