Senior Data Pipeline Engineer

Build trustworthy data pipelines at Foresight using Python, advanced SQL, and production-grade workflow orchestration. Preferred locations include New York, San Francisco, and Montreal.

As a Senior Data Engineer, you will build Foresight's data foundation for predictions, AI recommendations, analytics, and customer reporting. You will own production pipelines from source to consumer while shaping standards on a new team. The work includes project data ingestion, modeling, observability, and governance.

Key Responsibilities:

• Build robust pipelines from industry scheduling and planning tools
• Preserve update history for confident point-in-time comparisons
• Develop features, training datasets, and search indexes for AI
• Create models and pipelines for dashboards, reports, and exports
• Set data contracts, freshness targets, and quality standards

Requirements:

• Five or more years building production data pipelines
• Strong Python and advanced SQL skills
• Deep Postgres or relational database modeling experience
• Experience normalizing messy, inconsistent real-world data
• Hands-on workflow orchestration, retries, dependencies, and backfills

Bring pipeline ownership, data modeling, and quality engineering to Foresight's infrastructure intelligence platform.