What are the responsibilities and job description for the AI Data Engineer/Data Scientist — Snowflake / Dataiku position at Pyramid Technology Solutions, Inc.?
Position: AI Data Engineer/Data Scientist — Snowflake / Dataiku
Location: Princeton, NJ ideally 1-3 days a week in office ( Remote might be considered)
Duration: 6 Months Contract
Must Have: Snowflake SnowPark or PySpark SQL experience with any ML capabilities
Job Description:
- Data Engineering work to support Design of USO Patient Journey Optimization and Pre-Call Intelligence Data products.
- Main platforms: Snowflake (data storage, transformation, analytical data products, feature datasets)
- Dataiku (analytical workflows, scoring, orchestration, deployment, monitoring), Power BI or other approved BI tooling for reporting.
Key responsibilities
- Consume the USO star-schema tables in Snowflake.
- Write/optimize SQL in Snowflake to query and shape data for feature engineering.
- Build and maintain feature datasets/views in Snowflake that feed Dataiku.
- Check the Feature Store for existing features before building new ones in Dataiku.
- Create and maintain features in Dataiku for consumption by the Data Science team's ML models.
- Design, build, and validate ML models for Patient Journey Optimization and Pre-Call Intelligence use cases.
- Support analytical data products and BI dataset needs from Snowflake.
Requirement:
- Hands-on Snowflake, SQL, Python, Dataiku.
- Experience with production data pipelines, data modeling, testing, monitoring, CI/CD.
- AWS data services experience (Lambda, S3, Glue, Step Functions) — useful for occasionally reading/debugging upstream CDW pipelines, but not core to this role.
- Comfortable in governed enterprise environments.
- Preferred: healthcare, claims, HCP, patient-support, or Veeva data experience.