Senior Consultant, Integrations Specialist (IP.21, QTS, Coupa)

BizFirst

5d • Remote

About The Position

BizFirst is supporting its client in hiring a Senior Consultant, Integrations Specialist for a hands-on contract engagement focused on integrating supplementary data sources for enterprise clients. The role owns an integration workstream end to end, connecting operational, process historian, logistics, and procurement platforms into a unified Databricks lakehouse. It covers ingestion, Bronze-layer architecture, and Silver-layer modeling across diverse enterprise systems. The engagement is expected to last 4.5 to 6 months, with potential conversion to a full-time role at its conclusion. The position is remote for candidates based in the DMV area (Washington, DC, Maryland, or Virginia). The client provides any hardware needed by contractors. The hourly rate is competitive and based on experience and fit.

The consultant will work directly with client operations, procurement, and transportation subject matter experts. The technology environment includes SQL, Python, Databricks or Snowflake, dbt, Fivetran, ODBC staging, Aspen IP.21, QTS SmartData, Coupa, and JD Edwards vendor and freight data.

Benefits listed in the posting apply only to W-2 full-time employees of the client if hired in that capacity. They include competitive salary; medical, dental, and vision plans; a 401(k) match; flexible paid time off; hardware; a proprietary learning academy; and a certification stipend.

Requirements

• At least 5 years of hands-on data engineering experience.
• Strong expertise integrating heterogeneous enterprise data sources and third-party SaaS APIs.
• Production experience with SQL, Python, dbt, and modern cloud data platforms such as Databricks or Snowflake.
• Experience with specialized industrial, logistics, or ERP supplementary data systems, such as process historians or supply chain platforms.
• Excellent stakeholder management skills and the ability to translate business operational requirements into robust data integration architectures.
• Based in the DMV area: Washington, DC, Maryland, or Virginia.

Nice To Haves

• Certifications such as Databricks Data Engineer Professional or Snowflake SnowPro.
• Industry depth in freight and logistics or industrial operations.

Responsibilities

• Configure and manage advanced data connectors, including Fivetran and ODBC staging mechanisms, for Aspen IP.21 process historian, QTS SmartData freight and logistics data, and Coupa procurement data.
• Design and build Bronze-layer ingestion pipelines and schema-documented Silver-layer normalization models.
• Establish robust join keys and cross-system mappings, including connecting Coupa suppliers to JD Edwards Vendor Masters and QTS rail data to JD Edwards freight vouchers.
• Partner with client operations, procurement, and transportation subject matter experts to validate data models and ensure operational alignment.
• Own a defined integration workstream end to end.

Benefits

• Competitive salary for W-2 full-time employees, if hired as such.
• Medical, dental, and vision plans for W-2 full-time employees, if hired as such.
• 401(k) match, dollar-for-dollar up to 4% of salary, for W-2 full-time employees, if hired as such.
• Flexible paid time off for W-2 full-time employees, if hired as such; at least two weeks off per year is expected, preferably contiguous.
• Top-of-the-line hardware for W-2 full-time employees, if hired as such.
• Access to a proprietary learning academy with 100+ custom modules for W-2 full-time employees, if hired as such.
• Certification stipend for platforms delivered on, for W-2 full-time employees, if hired as such.
• Remote work and an empowerment culture for W-2 full-time employees, if hired as such.
• Necessary hardware provided to contractors.

What This Job Offers

• Career Level: Senior
• Education Level: No Education Listed