Business Systems Analyst – Databricks / Data Mapping

Teqfocus

Pleasanton (CA)

On-site

USD 90,000 - 140,000

Full time

9 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Teqfocus is a Data and AI company delivering a unified data layer and trusted Databricks-based portfolio view. We seek a senior analyst to own data mappings and business rules for software contracts and application records, enabling a curated UDL.

As a Salesforce Summit Partner, Teqfocus works across Healthcare, Life Sciences, Financial Services, Insurance, and Hi-Tech with a delivery model that emphasizes ownership and production-ready outcomes.

Qualifications

  • 5+ years as a Business Systems Analyst or Data Analyst in data warehouse, data lake or lakehouse programs.
  • Demonstrated experience writing source-to-target mappings, complex joins and reconciliation rules across multiple systems.
  • Strong SQL, including joins, window functions, profiling and reconciliation queries.
  • Hands-on Databricks experience with notebooks, Delta Lake and Spark SQL; ability to review transformation logic.
  • Experience with spreadsheet-based or semi-structured sources, schema drift and incomplete data.
  • Knowledge of data modeling, keys, entity resolution, curated layers and stakeholder-facing documentation.
  • Ability to work independently with minimal onboarding and deliver clear specifications on tight timelines.

Responsibilities

  • Document source-to-target mappings for contract records and application registry fields.
  • Define contract-to-application join logic and data quality flags.
  • Define dashboard data requirements for renewal radar, application details, filters and role-based visibility.
  • Coordinate data corrections with source owners and review lineage and reconciliation.

Skills

Business Systems Analyst
Data Analyst
Source-to-Target Mappings
SQL Proficiency
Databricks Experience
Delta Lake
Data Modeling
Documentation
Independent Work

Tools

Databricks
Spark SQL

Job description

Own the data mapping and business-rule specifications that connect software contracts and application records into a trusted Databricks-based software portfolio view. This is a hands‑on, deliverables‑driven engagement supporting a software portfolio initiative built on Databricks and a curated Unified Data Layer (UDL).

About Teqfocus:

Teqfocus is a Data and AI company that helps enterprises build and scale the Agentic Enterprise — connecting the data foundation, the intelligence layer, and the applications teams run their businesses on into a single, coherent architecture.

As a Salesforce Summit Partner, we work in Healthcare, Life Sciences, Financial Services, Insurance, and Hi-Tech — industries where getting AI right matters and the tolerance for failure is low. Our delivery model is senior‑heavy by design. The same team that scopes an engagement ships it to production. There are no junior shadow teams, no sub‑contractors brought in when the problem gets hard, and no hand‑off to a separate managed services vendor when the project closes.

We run an internal innovation practice that builds the reusable patterns, pre‑tested architectures, and industry‑specific frameworks that give every Teqfocus client a head start — and give every Teqfocus practitioner work that compounds over time.

We are a diverse, immigrant‑entrepreneurial company. We were built on the conviction that the best outcomes come from people who take genuine ownership of what they build — and are trusted to do so.

www.teqfocus.com

Key Responsibilities:
Source Mapping and Business Rules
  • Document source-to-target mappings for software contract records, including supplier, dates, auto‑renewal, notice period, ACV, TCV, seats and currency.
  • Map application registry fields including vendor, description, owner, business capability, contract dates, rationalization status and sourcing identifier.
  • Define contract-to-application join logic, unmatched-record handling and data quality flags.
  • Document notice‑deadline calculations, fiscal time frames, renewal status, spend exclusions and inputs to the similar-tools intelligence layer.
Requirements, Validation and Handover
  • Define dashboard data requirements for renewal radar, application details, filters, portfolio breakdowns and role-based visibility.
  • Profile data with SQL, identify incomplete records and coordinate corrections with source owners.
  • Partner with data engineers on curated UDL table contracts, schema changes, data lineage and reconciliation.
  • Create mapping specifications, data-quality baseline, business rules, reconciliation/UAT plans and executed results.
  • Provide weekly progress updates, final documentation and knowledge transfer.
Required Qualifications:
  • 5+ years as a Business Systems Analyst or Data Analyst in data warehouse, data lake or lakehouse programs.
  • Demonstrated experience writing source-to-target mappings, complex joins and reconciliation rules across multiple systems.
  • Strong SQL, including joins, window functions, profiling and reconciliation queries.
  • Hands‑on Databricks experience with notebooks, Delta Lake and Spark SQL; ability to review transformation logic.
  • Experience with spreadsheet-based or semi‑structured sources, schema drift and incomplete data.
  • Knowledge of data modeling, keys, entity resolution, curated layers and stakeholder-facing documentation.
  • Ability to work independently with minimal onboarding and deliver clear specifications on tight timelines.
Good to Have:
  • Procurement, sourcing, contract or software asset management domain knowledge.
  • Unity Catalog, governance, lineage, Google Sheets/Drive APIs, Python or PySpark.
  • Exposure to semantic/LLM matching, role-based data access, Agile tools and Databricks certification.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Databricks Application Developer
Databricks Application Developer

Teqfocus • Pleasanton (CA)

On-site
USD 140,000 - 210,000
Databricks Data Mapping & Rules Specialist
Databricks Data Mapping & Rules Specialist

Teqfocus • Pleasanton (CA)

On-site
USD 90,000 - 140,000
Data Engineer - Databricks
Data Engineer - Databricks

UNAVAILABLE • McLean (VA)

On-site
USD 120,000 - 170,000
Senior Data Engineer - Databricks
Senior Data Engineer - Databricks

UNAVAILABLE • McLean (VA)

On-site
USD 120,000 - 160,000
Senior Business Analyst
Senior Business Analyst

Xinova Group • Dallas (TX)

On-site
USD 90,000 - 120,000
Senior Solutions Consultant
Senior Solutions Consultant

Unison Group • San Francisco (CA)

On-site
USD 140,000 - 190,000
Senior Databricks Engineer
Senior Databricks Engineer

Remote • San Francisco (CA)

On-site
USD 150,000 - 190,000
Business Development Executive
Business Development Executive

CleanSlate Technology Group • United States

Remote
USD 95,000 - 160,000
Data QA Engineer
Data QA Engineer

Ex Parte, Inc • Bethesda (MD)

On-site
USD 90,000 - 120,000
Sr. Data and Automation Engineer, Enterprise Applications
Sr. Data and Automation Engineer, Enterprise Applications

DeWinter BH • Redwood City (CA)

Hybrid
USD 180,000 - 240,000