Senior Data Engineer: API-Driven Pipelines

Health Monitor Network; Montvale (NJ); On-site; USD 130,000 - 170,000; Full time

Job summary

Health Monitor Network is seeking a Senior Data Engineer to own the data foundation powering reporting and decision-making. You will build and maintain reliable pipelines moving data from source systems to analytics-ready datasets, with API-driven ingestion and integration.

You will design scalable data models, ensure data quality, and optimize performance across an enterprise data warehouse ecosystem including BigQuery and Redshift. Legally authorized to work in the U.S. required.

Qualifications

• Bachelor's degree in Computer Science, IT/IS, Software Engineering, or a similar field.
• Advanced SQL expertise, including writing and optimizing complex queries in BigQuery.
• Strong experience with Python for data transformation, automation, and pipeline development.
• Experience building and operating large-scale data pipelines and data architectures.
• Strong understanding of relational databases and analytics-focused data modeling.
• Experience working with API-based data integrations and incorporating API-sourced data into ETL/ELT workflows.
• Experience integrating data from business systems such as NetSuite (ERP) and Salesforce (CRM).
• Strong organizational skills and ability to manage multiple priorities.

Responsibilities

• Design, implement, and maintain scalable data pipelines that support reliable ingestion, transformation, and delivery of analytics-ready datasets
• Own and improve orchestration workflows to ensure consistent, timely data availability for reporting and downstream use
• Support and enhance API-based data ingestion between internal and external systems and the data platform
• Build ingestion patterns that handle real-world API behavior, including pagination, rate limits, retries, schema drift, and partial failures
• Partner with engineering and stakeholders to define data contracts and ensure consistent payloads into downstream processing
• Build and maintain data models that support operational reporting and performance analytics
• Work with large conceptual data models and define how entities should be structured and related within the data warehouse
• Deliver datasets and views optimized for downstream consumption and reporting tools
• Apply data governance best practices to ensure datasets are secure, consistent, and usable across teams
• Define and implement data quality checks to support trust in reporting, including validation, completeness testing, and reconciliation
• Build monitoring and alerting to track pipeline health, freshness, failures, and SLA adherence
• Proactively tune pipeline performance, query efficiency, and warehouse cost management
• Support outbound and reverse ETL workflows, delivering curated datasets back into operational systems via API-based delivery
• Support ingestion and modeling of business-critical datasets from systems such as CRM and ERP platforms
• Work with data from tools like NetSuite and Salesforce to enable reporting across finance, operations, customer, and revenue workflows
• Support analytics datasets that include digital and campaign-related data as needed
• Partner with stakeholders to ensure tracking data is consistent and reportable
• Create and maintain documentation including data definitions, lineage, and pipeline documentation
• Collaborate cross-functionally with analytics, product, and engineering partners to deliver reliable data solutions

Skills

Advanced SQL

Python programming

Data pipeline design

API integrations

Data modeling

Education

Bachelor's degree in CS/IT/IS/Software Engineering

Tools

BigQuery

AWS Redshift

NetSuite

Salesforce

Job description

Health Monitor Network is seeking a Senior Data Engineer to own the data foundation powering reporting and decision-making. You will build and maintain reliable pipelines moving data from source systems to analytics-ready datasets, with API-driven ingestion and integration.

You will design scalable data models, ensure data quality, and optimize performance across an enterprise data warehouse ecosystem including BigQuery and Redshift. Legally authorized to work in the U.S. required.