Business Systems Analyst / Data Analyst

Derex Technologies Inc•New York, NY
•Onsite

About The Position

Derex Technologies Inc is hiring a Business Systems Analyst / Data Analyst for a role in New York, NY. The position supports data warehouse, data lake, or Lakehouse programs, with a focus on source-to-target mapping, data transformation review, data modeling, and documenting data across multiple source systems. The role requires strong SQL and hands-on Databricks experience, including notebooks, Delta Lake, and Spark SQL. Candidates should be able to work independently on short timelines with minimal onboarding and produce clear documentation.

Requirements

  • At least 5 years as a Business Systems Analyst or Data Analyst on data warehouse, data lake, or Lakehouse programs.
  • Track record of writing detailed source-to-target mappings and join logic across multiple source systems.
  • Strong SQL skills, including joins, window functions, and profiling and reconciliation queries.
  • Hands-on experience with Databricks, including notebooks, Delta Lake, and Spark SQL.
  • Ability 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 modeling concepts, including keys, entity resolution, and curated-layer design.
  • Strong written communication and ability to produce clear documentation with little rework.
  • Proven ability to work independently on short timelines with minimal onboarding.

Nice To Haves

  • Familiarity with procurement or sourcing data, such as contracts, suppliers, renewals, ACV and TCV, and notice periods.
  • Workday Strategic Sourcing experience.
  • Experience with Unity Catalog, data lineage tools, or data governance practices.
  • Exposure to LLM-based or semantic matching use cases, including evaluating 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 privacy-aware handling of usage data.
  • Experience with 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 C (as written in the posting).

Responsibilities

  • Write detailed source-to-target mappings and join logic across multiple source systems.
  • Use SQL for joins, window functions, data profiling, and reconciliation queries.
  • Work with Databricks notebooks, Delta Lake, and Spark SQL.
  • Read and review transformation code.
  • Map data from semi-structured or user-maintained sources, such as spreadsheets, and handle schema drift and incomplete records.
  • Apply data modeling concepts, including keys, entity resolution, and curated-layer design.
  • Produce clear documentation with minimal rework.
  • Work independently on short timelines with minimal onboarding.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service