Business Systems Analyst / Data Analyst – Databricks & Data Warehousing

Bestica Inc. · New York, NY
Pay · estimate~$115k – $160kMarket rate · not set by employer
PostedNov 22, 2026
LevelMid level
In short We are seeking an experienced Business Systems Analyst / Data Analyst to support enterprise data warehouse, data lake, and Lakehouse initiatives at Workday.
SQLPYTHONDATABRICKSSPARKLLM

📋 About the job

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

The selected candidate will be responsible for analyzing data from multiple source systems, developing detailed source-to-target mappings, defining transformation and join logic, and ensuring data accuracy across enterprise data pipelines.

This role requires a strong combination of business analysis and technical data expertise, particularly in SQL, Databricks, Delta Lake, and Spark SQL. The candidate will work with structured and semi-structured data sources, review transformation logic, identify data quality issues, and produce detailed technical documentation to support data engineering and analytics initiatives.

The ideal candidate is a technically strong Business Systems Analyst or Data Analyst who can independently translate business requirements into detailed data mapping specifications and work effectively with data engineers and other technical stakeholders.

Key Responsibilities

  • Data Analysis & Source-to-Target Mapping
  • Analyze data across multiple source systems, including data warehouses, data lakes, and Lakehouse environments.
  • Develop detailed source-to-target mapping documents covering source fields, target structures, transformation rules, and join logic.
  • Identify relationships and dependencies between multiple source systems.
  • Define data transformation requirements and document business rules for data integration.
  • Analyze structured, semi-structured, and user-maintained data sources, including spreadsheets.
  • Identify and address schema drift, incomplete records, inconsistent data, and data quality issues.
  • Work with data engineering teams to ensure accurate implementation of mapping specifications.
  • SQL & Data Validation
  • Write and optimize complex SQL queries for data analysis and validation.
  • Develop SQL queries involving joins, window functions, aggregations, and data profiling.
  • Perform data reconciliation and validation across source and target systems.
  • Identify discrepancies, missing records, duplicate data, and inconsistencies.
  • Validate transformation logic and ensure data accuracy throughout the data pipeline.
  • Review SQL-based transformation code and work closely with developers to resolve data issues.
  • Databricks & Lakehouse Analysis
  • Work hands-on with Databricks notebooks, Delta Lake, and Spark SQL.
  • Analyze data transformation w…
📄 Read the full description → The rest of this listing is on the hiring partner’s site.
Interested in this role?Apply in one click — no JobQ account needed.
Apply now →
Business Systems Analyst / Data Analyst – Databr...Bestica Inc.
Apply now