Contract Data Pipeline Migration Engineer

Apollopros; Fort Walton Beach (FL); On-site; USD 66,000 - 73,000; Full time

Job summary

Apollopros in Fort Walton Beach, FL is seeking a Contract Data Pipeline Migration Engineer. The role focuses on translating analytics pipelines from Alteryx and R into SQL/Dataiku, ensuring production‑ready pipelines with clear lineage and zero regression in business logic.

You will convert workflows, deploy on a primary cloud platform (Redshift/Snowflake/Athena), and validate results while documenting assumptions and steps for internal teams.

Qualifications

• Bachelor’s degree in CS, IS or Data Engineering.
• 2–4 years in data engineering with pipeline migration experience.
• Fluency in writing/optimizing queries for cloud warehouses and traditional DBs.
• Proven track record converting R/Alteryx logic to SQL or similar tools.
• Ability to explain technical steps to non‑engineers.

Responsibilities

• Convert R (dplyr/data.table) and Alteryx workflows into modular SQL/Dataiku recipes.
• Deploy and test translated logic on Redshift, Snowflake or Athena.
• Run unit-style validation and document lineage and steps.
• Lead 2–3 short sessions to walk teams through migrations and results.
• Maintain a living wiki with transformation logic and known limitations.

Skills

SQL

Data pipelines

Data migration

Dataiku

Alteryx

R to SQL

Git

Education

Bachelor’s degree in CS/IS/Data Engineering

Tools

Dataiku

Alteryx

DBT

KNIME

Informatica

Git

Redshift

Snowflake

Athena

Job description

Contract Data Pipeline Migration Engineer Fort Walton Beach Fl Contract Hours: 8am - 4pm Pay Rate: $50.09/Hr.

REQUIREMENTS:

Contract Data Pipeline Migration Engineer Bachelor’s degree in CS, IS, Data Engineering, or equivalent practical experience (e.g., 3+ years hands‑on SQL/data pipeline work). Experience: 2–4 years in data engineering with direct pipeline migration/replatforming experience (e.g., moved Alteryx to Dataiku; converted R to SQL/Python; packaged SQL to DBT, other equivalent experience). Fluency in writing/optimizing queries (JOINs, CTEs, window functions) for cloud warehouses and traditional databases (Redshift/SQL Server). Proven track record converting R/Alteryx logic to SQL or equivalent experiences (KNIME, Informatica, etc). Comfort building simple row-count/checksum tests to verify migration fidelity. Ability to explain technical steps to non-engineers and document assumptions plainly. Comfort working with minimal daily supervision; flags blockers early.

JOB DESCRIPTION:

Contract Data Pipeline Migration Engineer Our client is seeking a pragmatic specialist to migrate existing analytical pipelines from Alteryx and R into Dataiku. The focus is on executing validated, documented translations—not building platform extensions or innovating on tooling. Success = production-ready SQL/Dataiku pipelines handed off to internal teams with clear lineage and zero regression in business logic.

Key Responsibilities:

• 1. Convert R (dplyr/data.table) and Alteryx workflows into modular, optimized SQL (CTEs, window functions, set-based logic) and/or Dataiku visual/SQL recipes—prioritizing correctness over elegance.
• 2. Deploy/test translated logic on one primary cloud platform (Redshift or Snowflake or Athena)—no need for multi-cloud expertise.
• 3. Run unit-style validation against source pipelines; document assumptions, lineage, and deployment steps for internal teams.
• 4. Conduct 2–3 focused sessions (max 1 hr each) walking data science/analytics team members through migrated pipelines and validation reports.
• 5. Maintain a living wiki/OneNote page with transformation logic, test results, and known limitations—not formal data governance artifacts.

PREFERRED EDUCATION & SKILLS:

Contract Data Pipeline Migration Engineer Bachelor’s degree in CS, IS, Data Engineering Familiarity with Dataiku DSS interface (visual recipes, project structure)—learnable in < 1 week. Exposure to DBT concepts (understands why modular SQL matters for handoff). Experience with Git for version control (basic branching/PRs).