Business Systems Analyst / Data Analyst

Derex Technologies Inc

New York (NY)

On-site

USD 90,000 - 130,000

Full time

5 days 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

Derex Technologies Inc, based in Harrison, NJ, is seeking a Business Systems Analyst / Data Analyst in New York, NY. The role focuses on data warehouse, data lake, or Lakehouse initiatives, requiring Databricks, SQL, Python, Delta Lake, and Spark SQL expertise.

You will map source-to-target data, review transformation code, and ensure clear documentation. The candidate should excel working independently on tight timelines and bring strong data modeling skills.

Qualifications

  • 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, including joins, window functions, 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 and handling schema drift.
  • Strong 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.

Skills

Databricks
Python
SQL
Spark
Delta Lake
Data modeling
Transformation code review
Documentation
Data wrangling

Tools

Databricks
Delta Lake
Spark SQL
Unity Catalog
Data lineage tools
Workday Sourcing
Google Sheets API

Job description

Derex Technologies Inc specializes in providing IT consulting, staffing solutions and software services. Globally headquartered in Harrison New Jersey since 1996 Derex delivers the highest quality technology professionals and an array of customized IT talent solutions designed to improve productivity and drive results to global clients throughout North America.

With over two decades of unparalleled experience, Derex provides supports to its clientele, across such industries as Systems Integration, Banking and Finance, Telecommunications, Pharmaceutical and Life Sciences, Energy, Healthcare, Technology, Transportation, and local and federal Government agencies.

Job Description

Role: Business Systems Analyst / Data Analyst

Location: New York, NY

Primary Skills: Databricks, Python, Spark, Delta Lake

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 modeling 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 C
Additional Information

All your information will be kept confidential according to EEO guidelines.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data & Systems Analyst — Databricks, Python, Spark
Data & Systems Analyst — Databricks, Python, Spark

Derex Technologies Inc • New York (NY)

On-site
USD 90,000 - 130,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
Data Analyst
Data Analyst

Robotics Technologies • Pleasanton (CA)

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

CloudBigD • Pleasanton (CA)

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

Ethereum Technologies LLC • Pleasanton (CA)

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

Robotic Process Automation LLC • Pleasanton (CA)

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

Quantum Technologies LLC • Pleasanton (CA)

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

Valiant Technologies LLC • Pleasanton (CA)

On-site
USD 120,000 - 180,000
Senior BI Lead / Architect
Senior BI Lead / Architect

Derex Technologies Inc • Chicago (IL)

On-site
USD 130,000 - 180,000
Data Analyst - IV
Data Analyst - IV

Compunnel Inc. • San Francisco (CA)

Remote
USD 85,000 - 120,000