[Job 25647] Senior Data Engineer - Legacy System Migration

CI&T; Brasil; Teletrabalho; BRL 120.000 - 160.000; Tempo integral

Resumo da oferta

A leading tech transformation company in Brazil is seeking an experienced Senior Data Engineer to lead the migration of client data infrastructure to a modern cloud-based stack. This role involves converting SQL Server data to streamlined dbt models and Prefect workflows on Snowflake. Candidates should have strong SQL Server and Python experience, with a robust background in data engineering and cloud technologies. The company offers competitive benefits and promotes inclusion and support for all employees.

Serviços

Health and dental insurance

Meal and food allowance

Childcare assistance

Extended paternity leave

Partnership with gyms and wellness professionals

Profit Sharing

Continuous learning platform

Discount club

Free online well-being platform

Pregnancy and parenting course

Partnerships with online learning platforms

Language learning platform

Qualificações

• Experience in data engineering or related roles.
• Strong experience with SQL Server, including stored procedures, views, and T-SQL.
• Hands-on experience with SSIS package development and maintenance.
• Strong proficiency in Python for automation and building workflows.
• Production experience with dbt including data modeling and testing.
• Experience with Prefect for workflow management.
• Hands-on experience with Snowflake, including optimization.
• Proven track record of data platform migrations.
• Strong analytical skills to understand legacy code.
• Experience with data migration strategies.
• Excellent documentation skills and attention to detail.
• Strong communication skills.

Responsabilidades

• Lead the migration of SQL Server data to dbt models and Prefect workflows.
• Analyze and document existing SQL Server data pipelines.
• Redesign ETL/ELT workflows to Python-based Prefect jobs.
• Convert SQL Server views and transformations to dbt in Snowflake.
• Optimize workflows for performance and cost-efficiency.
• Establish best practices and standards for data architecture.
• Mentor team members on modern data practices.

Conhecimentos

Data engineering

SQL Server

SSIS packages

Python

dbt

Prefect

Snowflake

Analytical skills

Documentation

Communication skills

Formação académica

Bachelor's degree in Computer Science or related field

Ferramentas

dbt

Snowflake

SSIS

Prefect

GitHub Copilot

Descrição da oferta de emprego

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.