[Job 25647] Senior Data Engineer - Legacy System Migration

We are **tech transformation** specialists, uniting human expertise with AI to create scalable tech solutions. With over 7\.400 CI\&Ters around the world, we’ve built partnerships with more than 1,000 clients during our 30 years of history. Artificial Intelligence is our reality. **About the Role** 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. **Key Responsibilities** 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) **Our benefits:*** Health and dental insurance * Meal and food allowance * Childcare assistance * Extended paternity leave * Partnership with gyms and health and wellness professionals via Wellhub (Gympass) TotalPass; * Profit Sharing and Results Participation (PLR); * Life insurance * Continuous learning platform (CI\&T University); * Discount club * Free online platform dedicated to physical, mental, and overall well\-being * Pregnancy and responsible parenting course * Partnerships with online learning platforms * Language learning platform And many more! More details about our benefits here: https://ciandt.com/br/pt\-br/carreiras At CI\&T, inclusion starts at the first contact. If you are a person with a disability, it is important **to present your assessment during the selection process.** This way, we can ensure the support and accommodations that you deserve. **If you do not yet have the assessment, don't worry: we can support you in obtaining it.** We have a dedicated Health and Well\-being team, inclusion specialists, and affinity groups who will be with you at every stage. Count on us to make this journey side by side. We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.