Senior Data Engineer - Hybrid, BigQuery & API Pipelines

Covenant HR LLC; Montvale (NJ); Hybrid; USD 83,000 - 124,000; Part time

Job summary

Covenant HR LLC is helping an established healthcare technology organization in Montvale, NJ, to hire a Senior Data Engineer for a 6–12 month contract. The role focuses on building and optimizing scalable data pipelines, data models, and API-driven ingestion to support analytics and reporting.

The ideal candidate will have strong BigQuery and GCP expertise, advanced SQL skills, and hands-on ETL/ELT experience, plus Python and API integration capabilities.

Qualifications

• Strong BigQuery and GCP expertise with hands-on experience.
• Advanced SQL expertise, including writing and optimizing complex queries.
• Strong ETL/ELT pipeline development and management experience.
• Strong Python experience for data transformation and automation.
• API-based data integration experience with handling pagination and rate limits.

Responsibilities

• Design, build, and maintain scalable data pipelines moving data from source systems to analytics-ready datasets.
• Own and improve data orchestration workflows for reliable data availability.
• Build and support API-driven data ingestion across internal and external systems.
• Develop and maintain data models, warehouse relationships, datasets, and views for analytics.
• Implement data quality, governance, validation, lineage, and documentation.
• Build monitoring and alerting for pipeline health, freshness, failures, and SLAs.
• Optimize pipeline performance, BigQuery efficiency, and warehouse costs.
• Support reverse ETL and outbound data delivery through APIs to operational systems.
• Integrate business data from CRM and ERP platforms like Salesforce and NetSuite.
• Collaborate with analytics, product, engineering, and business stakeholders to deliver data solutions.
• Leverage modern AI/LLM tools to accelerate data workflows; Claude experience is a plus.
• Work with SQL, Python, GCP, BigQuery, Salesforce, NetSuite, GitHub, Copilot, and Jira.

Skills

BigQuery & GCP

Advanced SQL

ETL/ELT pipelines

Python data transformation

API data integration

Tools

BigQuery

GCP

SQL

Python

Salesforce

NetSuite

GitHub

Jira

Job description

Covenant HR LLC is helping an established healthcare technology organization in Montvale, NJ, to hire a Senior Data Engineer for a 6–12 month contract. The role focuses on building and optimizing scalable data pipelines, data models, and API-driven ingestion to support analytics and reporting.

The ideal candidate will have strong BigQuery and GCP expertise, advanced SQL skills, and hands-on ETL/ELT experience, plus Python and API integration capabilities.