> Markdown version of [/jobs/ext/2307230-staff-data-engineer-core-migrations](https://www.wearedevelopers.com/jobs/ext/2307230-staff-data-engineer-core-migrations). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Staff Data Engineer, Core Migrations - **Company:** Machinify, Inc. - **Location:** La Grange, KY, United States - **Experience:** Expert - **Salary:** $230,000.0 - $260,000.0 - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Airflow, Amazon Web Services, Amazon S3, Business Logic, Code Generation, Directed Acyclic Graph (Directed Graphs), Data Validation, Extract Transform Load (ETL), Cursor (Graphical User Interface Elements), Software Debugging, Distributed Computing Environment, Python (Programming Language), Microsoft SQL Server, Performance Tuning, Cloud Services, Reverse Engineering, Software Deployment, SQL Stored Procedures, SQL Databases, SQL Server Integration Services, Transact-SQL, Prompt Engineering, Apache Spark, Legacy Systems - **Published:** August 30, 2026 - **Apply:** https://www.juju.com/job/00000000gpt2zt ## About the Role High School Diploma/G.E.D., 8+ years as a hands-on Data Engineer or Software Engineer, with demonstrated experience independently owning complex, multi-stakeholder technical projects from start to finish. Strong Python and SQL - fluent with complex, unfamiliar legacy code, not just greenfield work. Apache Spark - deep understanding of distributed processing, performance tuning, partitioning, and debugging at scale. Apache Airflow - advanced; comfortable designing and authoring production DAG architectures from scratch. AI-assisted development - actively uses coding agents (Claude, Copilot, Cursor, or equivalent) as a force multiplier in daily engineering work. Comfortable prompt-engineering for code generation, debugging, and documentation, and able to evaluate and trust AI output critically. Legacy ETL stack - able to reconstruct intent from code and translate it faithfully into a modern stack (e.g., From SSIS, SQL Server stored procedures, T-SQL, or equivalent). Data validation & reconciliation at scale - experience designing automated frameworks that prove migrated data matches source systems with high confidence. AWS - proficient with S3, solid grasp of cloud-native data patterns such as partitioned object storage, secure cross-account access, and cost/performance trade-offs. Cross-functional coordination - proven ability to drive alignment across engineering, operations, and client-facing teams simultaneously, without losing velocity. Clear technical communication - able to write discovery specs, architecture docs, and stakeholder updates that are accurate, concise, and actionable for both technical and non-technical audiences. Data-first mindset & fidelity - a rigorous, data-first mindset, with deep experience in building automated reconciliation frameworks that guarantee 100% data fidelity between legacy and modern systems. ## Description As a Staff Data Engineer on the Migrations team, you are the end-to-end technical and operational owner of client migrations. You will drive the full lifecycle, from deep-dive legacy analysis to production deployment, while orchestrating collaboration across Operations, Client Success, Product, Data Science and Platform Engineering. You don't just implement; you own the outcome. This is a high-trust, high-autonomy role for someone who can think like an architect, execute like a senior engineer, and coordinate like a program manager - all on the same project. You'll own the problem space from discovery to go-live, making the defining architectural decisions and writing the code that brings them to life. What You'll Do Lead discovery & technical due diligence - get to the bottom of poorly documented legacy systems (ETL, stored procedures, reporting layers, file feeds), reconstruct the business logic, and capture it in the lineage maps, mapping specs, and risk analyses everyone builds from. Reverse-engineer complex legacy systems using agents- you will be responsible for reverse-engineering complex, undocumented legacy systems (SSIS packages, stored procedures) where business logic is embedded, not documented. You must be able to reconstruct the intent of these systems to build modern, stable equivalents. Drive ambiguity to resolution - spot the unknowns early, own the open questions, and pull answers from clients, SMEs, and Operations instead of waiting to be unblocked. Architect & build the migration pipelines - turn intricate legacy logic into production-grade Airflow DAGs and Spark jobs on the Machinify platform, edge cases, payer-specific carve-outs, and business-rule exceptions included, owning the full flow from ingestion through reconciliation to steady-state handoff. Make and document the hard architectural calls - own the decisions that matter (pipeline design, partitioning strategy, validation approach) and leave a clear trail of the reasoning so others can learn from and build on it. Prove correctness at scale - build automated reconciliation frameworks that confirm, with confidence, that migrated output matches the source down to the row. Own the program end to end - be the single technical owner from kickoff through go-live and hypercare: scope, sequence, and track the work, surface risks before they bite, align Operations, Client Success, Platform Engineering, SMEs, and the client, and drive UAT through to sign-off. Raise the bar for the practice - Institutionalize migration knowledge by codifying runbooks and retrospectives, mentor L3/L4 engineers to build independent capability, and turn recurring migration pain points into scalable, reusable tooling. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [WeAreDevelopers LIVE - CSS is DOOMed](https://www.wearedevelopers.com/videos/1838-wearedevelopers-live-css-is-doomed) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [AI Model Management Life Circles: ML Ops For Generative AI Models From Research to Deployment](https://www.wearedevelopers.com/videos/1152-ai-model-management-life-circles-ml-ops-for-generative-ai-models-from-research-to-deployment) - [Hate organising your photos? Try it with 5 Terabytes](https://www.wearedevelopers.com/videos/79-hate-organising-your-photos-try-it-with-5-terabytes) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers) - [Navigating the AI Shift](https://www.wearedevelopers.com/magazine/629-navigating-the-ai-shift) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)