Business Systems Analyst / Data Analyst

Posted 2 Days Ago
New York, NY, USA
In-Office
Senior level
Information Technology • Consulting
The Role
Analyze and document data warehouse, data lake, and Lakehouse systems. Create source-to-target mappings, join logic, data models, profiling and reconciliation queries, and review transformation code using SQL, Databricks, Delta Lake, and Spark SQL. Handle semi-structured data, schema drift, incomplete records, and data governance requirements. Work independently on short timelines while producing clear technical documentation. Preferred experience includes procurement data, Workday Strategic Sourcing, semantic matching, asset management, telemetry, APIs, and dashboard access controls.
Summary Generated by Built In
Company 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

 

 

 

 

Regards,

 

Manoj Goud

Derex Technologies INC

Contact : 973-834-5005 Ext 206

Additional Information

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

Skills Required

  • 5 or more years of experience as a Business Systems Analyst or Data Analyst on data warehouse, data lake, or Lakehouse programs
  • Experience writing detailed source-to-target mappings and join logic across multiple source systems
  • Strong SQL skills, 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 semi-structured or user-maintained sources, including spreadsheets, and handling schema drift and incomplete records
  • Strong understanding of data modeling concepts, including keys, entity resolution, and curated-layer design
  • Strong written communication and ability to produce clear documentation with little rework
  • Ability to work independently on short timelines with minimal onboarding
  • Familiarity with procurement or sourcing data, including contracts, suppliers, renewals, ACV, 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 and 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 and Jira
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Harrison, NJ
24 Employees
Year Founded: 1996

What We Do

DEREX Technologies, Inc. established in 1996 is engaged nationally in providing professional computer services, including management consulting firm. We provide expert services nationwide to Fortune 500 companies and other private and public organizations in the United States. Derex provides a multi-faceted portfolio of products and services to its clients, including complete IT solutions.

Similar Jobs

Tapestry - Coach and Kate Spade Logo Tapestry - Coach and Kate Spade

Assistant Store Manager I

eCommerce • Fashion • Retail • Sales • Wearables • Design
Hybrid
New York, NY, USA
16000 Employees
19-38 Hourly

Tapestry - Coach and Kate Spade Logo Tapestry - Coach and Kate Spade

Assistant Store Leader

eCommerce • Fashion • Retail • Sales • Wearables • Design
Hybrid
Central Valley, NY, USA
16000 Employees
19-38 Hourly

Wipfli Logo Wipfli

Audit Manager, Tribal Industry

Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Remote or Hybrid
United States
2900 Employees
97K-131K Annually

Wipfli Logo Wipfli

Architect

Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Remote or Hybrid
United States
2900 Employees
129K-174K Annually

Similar Companies Hiring

NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity • Defense • Defense Technology
Austin, TX
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
567 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account