We specialize in tech transformation, combining human expertise with AI to deliver scalable technology solutions. With more than 8,000 CI&T professionals worldwide, we have partnered with over 1,000 clients throughout our 30‑year history. Artificial Intelligence is part of our everyday work.

We are seeking a Data Analyst with solid experience in data migration, transformation, and process automation. In this role, you will analyze gaps between source data and target databases, define transformation and enrichment rules, and support the creation of a reliable, automated data import pipeline.

Your primary responsibility will be to ensure that data coming mainly from CSV files is accurately transformed, loaded into our final databases using SQL, and kept consistent and dependable for the systems that rely on it.

What You Will Do

1. Data Gap and Requirements Analysis
Review existing data sources (primarily CSV files and source databases) along with target database structures.
Identify discrepancies, inconsistencies, and data quality issues.
Map fields between source and target systems, including complex mappings and business rules.
Document data definitions, flows, and dependencies.

2. Data Transformation, Enrichment, and Cleaning
Define and document rules for transformation, enrichment, validation, and handling missing data.
Collaborate with stakeholders to clarify business logic for derived fields.
Design and test transformation steps such as standardization, normalization, lookups, and reference data enrichment.

3. Data Import and Automation
Convert transformation rules into SQL import scripts and processes to load data into target databases.
Work with engineers to design or implement automated ETL/ELT pipelines for routine data loads.
Define and support consistency checks to ensure data reliability in downstream systems.

4. Data Quality and Consistency Assurance
Establish data validation rules, quality checks, and reconciliation reports (including counts, referential integrity checks, duplicates, and null validations).
Monitor data loads and identify root causes of ingestion issues.
Recommend improvements to schemas, processes, and tools to reduce manual effort and increase reliability.

5. Documentation and Collaboration
Create clear documentation for mappings, transformation rules, and automated processes.
Collaborate with product, engineering, and business teams to refine requirements and confirm results.
Present findings and recommendations clearly to both technical and non‑technical audiences.

What We’re Looking For

Must‑Haves
Proven experience as a Data Analyst, Data Migration Analyst, or a related role.
Strong SQL skills, including complex joins, window functions, data profiling, and validations.
Experience working with CSV imports and relational databases.
Strong data modeling and mapping knowledge, including schemas and key relationships.
Experience defining and documenting data transformation and enrichment rules.
Background in data quality practices such as validations, reconciliations, and anomaly detection.
Ability to convert business requirements into technical data processes.
Excellent analytical skills and attention to detail.

Nice‑to‑Haves
Experience with ETL/ELT tools or automation scripting (e.g., Python, dbt, Airflow, SSIS).
Background in system‑to‑system or platform‑to‑platform data migration projects.
Knowledge of data warehousing concepts.
Experience using version control (e.g., Git) for SQL and pipeline management.
Familiarity with data flows in your industry (e.g., finance, e‑commerce, SaaS).

Soft Skills
Strong facilitation and communication abilities, capable of leading structured discussions with both business and technical teams.
Ability to interview and collaborate with people involved in manual processes and translate their workflow into clear data and process requirements.
Comfort asking clarifying questions and challenging assumptions to uncover hidden rules and edge cases.
Skill in explaining complex data concepts in simple terms and translating business needs into technical tasks.
Proactive mindset, ownership of tasks, and ability to ensure alignment across teams.
Strong organizational skills to track decisions, open points, and next steps.

Our benefits include:
Health and dental insurance
Meal and food allowance
Childcare assistance
Extended paternity leave
Gym and wellness partnerships via Wellhub (Gympass) and TotalPass
Profit Sharing and Results Participation (PLR)
Life insurance
Continuous learning platform (CI&T University)
Discount club
Free online platform for physical, mental, and overall well‑being
Pregnancy and responsible parenting course
Access to online learning platforms
Language learning platform
And much more.

More details about our benefits: https://ciandt.com/br/pt-br/carreiras

At CI&T, inclusion begins with your first interaction with us. If you are a person with a disability, it is important to provide your assessment during the selection process. This ensures we can offer the accommodations and support you need. If you do not yet have the assessment, we can help you obtain it.

Our Health and Well‑being team, inclusion specialists, and affinity groups will be with you every step of the way. You can count on us to accompany you throughout your journey.