CI&T
We are
tech transformation
specialists, uniting human expertise with AI to create scalable tech solutions.
With over 8,000 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.
Hey everyone! This is Thai Viapiana from CI&T's Talent Attraction Team :) At CI&T, we're growing fast and looking for a talented, motivated
Senior Data Engineer
to join our team. You'll play a crucial role in enhancing and maintaining a data warehouse that consolidates data from acquired entities across multiple ERP platforms for a global healthcare organization.
Project Environment
Azure SQL Database (data warehouse)
Azure Data Factory (ETL orchestration)
Azure Data Lake (landing zones)
Power BI (reporting layer)
ELT architecture with transformation logic in T‑SQL stored procedures
Responsibilities
Develop and maintain ETL pipelines in Azure Data Factory.
Write and optimize T‑SQL stored procedures for data transformation.
Enhance dimensional models (star schema) to support new reporting requirements.
Integrate data from multiple ERP systems (NetSuite, SAP Business One, Business Central) and flat file sources.
Manage reference data and dimension tables.
Collaborate with business stakeholders to translate requirements into technical specifications.
Ensure data quality and consistency across sources with varying structures.
Support Power BI reporting through the semantic layer.
Document data lineage and transformation logic.
Requirements
Excellent English communication skills (reading, writing, and speaking).
Experience working with international clients.
Strong proficiency in T‑SQL (stored procedures, CTEs, window functions).
Experience with Azure Data Factory or similar ETL orchestration tools.
Solid understanding of dimensional modeling (star schema, fact/dimension tables).
Experience with Azure SQL Database or SQL Server.
Familiarity with ERP data structures (NetSuite, SAP, or similar).
Ability to work with ambiguous business logic across multiple source systems.
Understanding of Data Quality practices.
Nice to Have
Experience with Power BI data modeling.
Knowledge of CI/CD for database deployments.
Understanding of Data Governance principles.
Experience in healthcare or PE‑backed roll‑up environments.
#LI-THAI23
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.
See which data needs to be included in the report by clicking here, 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.
#J-18808-Ljbffr
tech transformation
specialists, uniting human expertise with AI to create scalable tech solutions.
With over 8,000 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.
Hey everyone! This is Thai Viapiana from CI&T's Talent Attraction Team :) At CI&T, we're growing fast and looking for a talented, motivated
Senior Data Engineer
to join our team. You'll play a crucial role in enhancing and maintaining a data warehouse that consolidates data from acquired entities across multiple ERP platforms for a global healthcare organization.
Project Environment
Azure SQL Database (data warehouse)
Azure Data Factory (ETL orchestration)
Azure Data Lake (landing zones)
Power BI (reporting layer)
ELT architecture with transformation logic in T‑SQL stored procedures
Responsibilities
Develop and maintain ETL pipelines in Azure Data Factory.
Write and optimize T‑SQL stored procedures for data transformation.
Enhance dimensional models (star schema) to support new reporting requirements.
Integrate data from multiple ERP systems (NetSuite, SAP Business One, Business Central) and flat file sources.
Manage reference data and dimension tables.
Collaborate with business stakeholders to translate requirements into technical specifications.
Ensure data quality and consistency across sources with varying structures.
Support Power BI reporting through the semantic layer.
Document data lineage and transformation logic.
Requirements
Excellent English communication skills (reading, writing, and speaking).
Experience working with international clients.
Strong proficiency in T‑SQL (stored procedures, CTEs, window functions).
Experience with Azure Data Factory or similar ETL orchestration tools.
Solid understanding of dimensional modeling (star schema, fact/dimension tables).
Experience with Azure SQL Database or SQL Server.
Familiarity with ERP data structures (NetSuite, SAP, or similar).
Ability to work with ambiguous business logic across multiple source systems.
Understanding of Data Quality practices.
Nice to Have
Experience with Power BI data modeling.
Knowledge of CI/CD for database deployments.
Understanding of Data Governance principles.
Experience in healthcare or PE‑backed roll‑up environments.
#LI-THAI23
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.
See which data needs to be included in the report by clicking here, 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.
#J-18808-Ljbffr