Senior Data Engineer

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:

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.