[Job 25647] Senior Data Engineer - Legacy System Migration

We are seeking an experienced Senior Data Engineer to lead the migration of our client data infrastructure from SQL Server to a modern cloud-based data stack. This role will involve converting legacy stored procedures, SSIS packages, and database views into streamlined dbt models and Prefect workflows running on Snowflake. You will play a critical role in modernizing our client data platform and establishing best practices for the new data architecture.

Lead the migration of SQL Server stored procedures, SSIS packages, and views to dbt models and Prefect workflows

Analyze and document existing legacy SQL Server data pipelines and business logic

Redesign ETL/ELT workflows from SSIS packages into Python-based Prefect jobs

Refactor complex stored procedures into modular, testable dbt models

Convert SQL Server views and data transformations to dbt in Snowflake

Leverage AI tools to accelerate code conversion and migration tasks where appropriate

Implement data quality checks and validation to ensure migration accuracy and data integrity

Optimize migrated workflows for performance and cost-efficiency in Snowflake

Establish data engineering best practices, coding standards, and documentation for the new stack

Collaborate with business stakeholders to understand and preserve critical business logic during migration

Create comprehensive mapping documentation between legacy and new systems

Mentor team members on modern data engineering practices and tools

Participate in code reviews and ensure adherence to the new architecture standards

Required Qualifications

Experience in data engineering or related roles

Strong experience with SQL Server, including stored procedures, views, and T-SQL

Hands-on experience with SSIS (SQL Server Integration Services) package development and maintenance

Strong proficiency in Python for data engineering, automation, and building Prefect workflows

Production experience with dbt including data modeling, testing, and incremental models

Experience with Prefect for workflow orchestration and pipeline management

Hands-on experience with Snowflake, including data warehousing and performance optimization

Proven track record of successful data platform migrations or modernization projects

Strong analytical skills to reverse-engineer and understand legacy code and business logic

Experience with data migration strategies, validation techniques, and rollback procedures

Excellent documentation skills and attention to detail

Strong communication skills to work with technical and non-technical stakeholders

Preferred Qualifications

Experience using AI tools (GitHub Copilot, ChatGPT, Claude, or similar) to assist with code conversion, migration, and development tasks

Experience migrating from on-premise systems to cloud data platforms

Familiarity with automated code conversion and refactoring tools

Experience with data catalog and lineage tools

Knowledge of change management and migration project management

Experience with Azure or other cloud platforms

Familiarity with data governance and compliance requirements

Understanding of dimensional modeling and data warehouse design patterns

Bachelor's degree in Computer Science, Engineering, or related field (or equivalent experience)