Lead Data Integration Engineer - Lakehouse (Remote)

BizFirst; United States; Remote; USD 124,000 - 193,000; Full time

Benefits offered by this job

Medical, Dental & Vision plans

401(k) match

Fully remote work

Learning academy & certifications

Certification stipend

Proprietary learning resources

Job summary

BizFirst is seeking a Senior Consultant, Integrations Specialist to lead data integration workstreams for enterprise clients. You will own end-to-end integration across Aspen IP.21, Coupa, and QTS SmartData, building a Databricks lakehouse with Bronze and Silver layers.

You will work remotely within the DMV area and collaborate with operations, procurement, and transportation SMEs. Strong SQL, Python, dbt, and cloud data platform experience are essential.

Qualifications

• 5+ years of hands-on data engineering experience with enterprise data sources.
• Strong experience integrating heterogeneous data sources and SaaS APIs.
• Proficient with modern cloud data platforms (Databricks or Snowflake) and dbt.

Responsibilities

• Connect platforms like Aspen IP.21, QTS SmartData, Coupa; configure data connectors.
• Design Bronze-layer ingestion and Silver-layer normalization in a Databricks lakehouse.
• Map cross-system keys (Coupa to JDE Vendor Master; QTS rail data to JDE vouchers).
• Validate data models with client operations and procurement SMEs.

Skills

SQL

Python

dbt

Stakeholder management

Data integration

Tools

Databricks

Snowflake

Fivetran

ODBC

Job description

BizFirst is seeking a Senior Consultant, Integrations Specialist to lead data integration workstreams for enterprise clients. You will own end-to-end integration across Aspen IP.21, Coupa, and QTS SmartData, building a Databricks lakehouse with Bronze and Silver layers.

You will work remotely within the DMV area and collaborate with operations, procurement, and transportation SMEs. Strong SQL, Python, dbt, and cloud data platform experience are essential.