Data Engineer Lead, Brasil

CI&T; Colombia; On-site; COP 291,290,000 - 388,387,000; Full time

Benefits offered by this job

Health and dental insurance

Meal and food allowance

Life insurance

Continuous learning platform

Job summary

CI&T, a global technology partner, is seeking a senior data & BI engineer to lead end-to-end data flows from ingestion to the Power BI semantic layer. You will design Bronze/Silver/Gold architectures, build scalable ETL pipelines, and govern data quality across data lakes and warehouses.

You will own Power BI modeling, DAX optimization, and ERP/CRM integrations, collaborating with the Core Team’s Data Architect to enforce platform standards and control costs. Fluency in English is required.

Qualifications

• Hands-on experience with Microsoft Fabric and OneLake.
• End-to-end Bronze/Silver/Gold architecture design experience.
• Azure Data Factory pipeline design and data contracts.
• Power BI semantic modeling and advanced DAX.
• ERP/CRM integration into a unified data platform.

Responsibilities

• Own the complete data chain for the Foundation Pod from ingestion to semantic layer in Power BI.
• Build, optimize, and maintain scalable ETL/ELT data pipelines and gold datasets.
• Develop and govern high-performance Power BI models and dashboards.
• Implement robust data lakes and warehouses aligned with global strategy.
• Establish automated data quality checks and governance.
• Coordinate with Core Team's Data Architect on platform standards.
• Optimize query performance and manage cloud costs.
• Lead and mentor engineers, uphold SLAs, and maintain documentation.

Skills

Fabric & OneLake

Data architecture (Bronze/Silver/Gold)

Azure Data Factory

Power BI modeling & DAX

ERP/CRM integration

Technical leadership

English proficiency (B2+)

Tools

Power BI

Azure Data Factory

OneLake

Job description

At CI&T, we help large enterprises transform the potential of AI into real business impact with AI Deployment, AI-native execution, and tech-integrated business solutions.

With 30 years of experience in technological transformation, we accelerate innovation with expertise in Agentic SDLC, Application modernization, Data & AI, Martech and Business strategy.

We are 8,000 CI&Ters across more than 25 countries, collaborating to build solutions with real impact. AI is already part of how we work, evolve, and innovate every day.

What You Will Do (Core Responsibilities)

• End-to-End Ownership: Lead the complete data chain for the Foundation Pod, covering ingestion, Bronze, Silver, Gold layers, and the Power BI semantic layer.
• Pipeline Development: Build, optimize, and maintain scalable ETL/ELT data pipelines and Gold certified datasets to drive BI and analytics.
• Semantic Modeling & BI: Develop and govern high-performance Power BI semantic models and dashboards.
• Data Architecture: Implement robust Data Lakes, Data Warehouses, and integration layers aligned with the global data strategy.
• Data Quality & Governance: Establish automated quality checks, validation rules, and monitoring systems to ensure maximum accuracy and reliability.
• System Integration: Develop integrations between ERP/CRM sources, third-party tools, and analytics platforms, coordinating with the Core Team's Data Architect on platform standards.
• Performance & Cost Optimization: Fine-tune query performance, monitor pipeline execution times, and manage cloud storage/compute costs.
• Technical Leadership: Direct the work of peer engineers, uphold strict pipeline SLAs, and maintain comprehensive technical documentation.

At CI&T, we help large enterprises transform the potential of AI into real business impact with AI Deployment, AI-native execution, and tech-integrated business solutions.

With 30 years of experience in technological transformation, we accelerate innovation with expertise in Agentic SDLC, Application modernization, Data & AI, Martech and Business strategy.

We are 8,000 CI&Ters across more than 25 countries, collaborating to build solutions with real impact. AI is already part of how we work, evolve, and innovate every day.

What You Will Do (Core Responsibilities)

• End-to-End Ownership: Lead the complete data chain for the Foundation Pod, covering ingestion, Bronze, Silver, Gold layers, and the Power BI semantic layer.
• Pipeline Development: Build, optimize, and maintain scalable ETL/ELT data pipelines and Gold certified datasets to drive BI and analytics.
• Semantic Modeling & BI: Develop and govern high-performance Power BI semantic models and dashboards.
• Data Architecture: Implement robust Data Lakes, Data Warehouses, and integration layers aligned with the global data strategy.
• Data Quality & Governance: Establish automated quality checks, validation rules, and monitoring systems to ensure maximum accuracy and reliability.
• System Integration: Develop integrations between ERP/CRM sources, third-party tools, and analytics platforms, coordinating with the Core Team's Data Architect on platform standards.
• Performance & Cost Optimization: Fine-tune query performance, monitor pipeline execution times, and manage cloud storage/compute costs.
• Technical Leadership: Direct the work of peer engineers, uphold strict pipeline SLAs, and maintain comprehensive technical documentation.

What We Are Looking For (Required Skills)

• Hands-on experience with Microsoft Fabric and OneLake (or equivalent Azure data platform experience).
• Proven track record designing Bronze/Silver/Gold medallion architectures end-to-end.
• Expertise in Azure Data Factory pipeline design and data contract definition.
• Deep experience in Power BI semantic modeling and advanced DAX authoring.
• Practical experience integrating ERP and CRM source systems into a unified data platform.
• Strong technical leadership skills (ability to direct engineering work and hold pipeline SLAs).
• Professional English proficiency (B2+ level or higher).

Nice to Have

• Experience with Infor SyteLine or Infor ION integrations.
• Experience handling regulated or medical-device data within an ISO 13485 context.
• Familiarity with Infrastructure-as-Code (Bicep or Terraform) and CI/CD for data pipelines.
• Hands-on experience with source systems like OneStream, Workday, or Fusion PLM.

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.