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 DescriptionRole: 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 InformationAll 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
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.







