[Job - 26699] Senior Data Engineer, Brazil at CI&T

CI&T

Brazil·2d ago

SeniorFull-timeAzureCI/CDAI

Salary Range

$37,128 - $50,232 /year

Estimated

This salary is estimated based on similar roles. The actual salary may vary.

About the Role

We are looking for a Senior Data Engineer to join our team. You will 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.

Key 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 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