Lead Data Developer

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.
Location: Brazil (Remote) Industry: MedTech / Reproductive Health Supply Chain Project Type: Post-M&A data platform consolidation
The Project: Post-M&A Data Integration
You'll be joining a strategic data platform integration project to consolidate data from different acquired companies into one unified Azure-based data warehouse. They need to break down data silos and build a unified global data warehouse that gives leadership a single source of truth for operations, finance, and business performance across their global footprint.
The Mission:
- Integrate disparate data systems (NetSuite, SAP, Dynamics NAV, Business Central, Oracle) from multiple acquired companies - Build a modern Azure data platform that scales globally - Enable executive decision-making with unified financial and operational reporting - Support PE investors and board with consolidated company performance data - Prepare for Salesforce CRM migration by establishing clean, integrated data foundation
What You'll Do
Data Platform Development (50%) Design and build Azure Data Factory pipelines to integrate data from multiple ERP systems (NetSuite, SAP, Dynamics NAV, Business Central) Architect dimensional data models (star schema, fact/dimension tables) for consolidated financial and operational reporting Build data transformation logic to harmonize data across 9 different company systems Optimize Azure SQL Database and Azure Data Lake implementations for performance and cost Implement data quality validation to ensure accuracy across source systems
Technical Leadership (30%) Guide technical implementation with the Data Product Manager on architecture decisions Establish data engineering standards for the new global platform Debug and resolve production issues independently - you're the go-to technical expert Document data flows, transformations, and business logic for the platform Collaborate with cross-functional teams across different acquired companies and geographies
Multi-Source Data Integration (20%) Extract data from legacy ERP systems - navigating different technical platforms (Oracle, Microsoft) Build data mappings between different systems' schemas and business logic Handle data consolidation challenges (duplicate customers, product matching, currency conversion, multi-entity hierarchies) Validate data completeness and reconcile against source systems Support stakeholder requirements for consolidated reporting needs
What You Need to Succeed
Core Requirements:
1. Azure Data Engineering Expertise (Non-Negotiable) 5+ years hands-on data engineering building production data pipelines Expert-level Azure Data Factory experience - this is your primary tool (not nice-to-have, REQUIRED) Strong Azure SQL Database and Azure Data Lake Storage experience Advanced SQL skills - complex queries, joins, performance tuning, query optimization
2. Data Modeling & Warehousing Dimensional modeling expertise - star schema, fact tables, dimension tables (you've built these in production) Data warehouse design - understanding best practices for analytics and reporting Experience with multi-source data integration - combining data from different systems
3. Problem-Solving & Independence Debugging inherited/incomplete infrastructure - you can pick up someone else's code and fix it Independent problem-solving - figure things out without constant hand-holding Production support experience - troubleshooting live issues under pressure
4. Communication English proficiency for stakeholder communication (US and EMEA teams) Technical documentation skills - you write clear, helpful docs Collaboration across teams - work with product, business stakeholders, and technical teams
Highly Valuable (Nice-to-Have):
1 - ERP Systems Experience NetSuite, SAP, Dynamics NAV, or Business Central integration Understanding of financial data models (chart of accounts, general ledger, P&L) Multi-entity/multi-company ERP implementations
2 - Data Quality & MDM Master Data Management (MDM) concepts - customer/product matching logic Data deduplication and consolidation Data quality validation frameworks
3 - Domain Knowledge Healthcare or medical device industry experience Understanding of regulatory/compliance requirements (HIPAA, medical data) Supply chain or logistics data
4 - Additional Tools Power BI for data visualization Oracle database experience Salesforce data integration
Why This Role?
High-Impact Project: Lead a critical consolidation initiative for a company that just went through massive M&A Direct impact on executive decision-making - board and PE investors rely on your data Global scope - data spanning EMEA and USA operations Visible results - you're building the foundation for the entire company's data strategy
Technical Challenge: Complex integration problem - 9 different companies, multiple ERP systems, disparate data models Modern Azure stack - work with current cloud technologies Architecture opportunity - design decisions that impact the entire platform Salesforce migration support - be part of CRM transformation
Career Growth: Lead-level experience without pure management - technical leadership with hands-on work M&A integration expertise - highly valuable and transferable skill Healthcare domain knowledge - specialized industry experience Azure expertise - deepen skills in high-demand cloud platform
Team & Environment: Strategic role - you're guiding technical decisions, not just executing tasks Collaborative team International exposure - US and EMEA stakeholders
The Ideal Candidate
You're likely a great fit if you can say:
"I've built production data pipelines in Azure Data Factory - it's my primary tool" "I have strong dimensional modeling experience - I've designed star schemas for analytics" "I've integrated data from multiple ERP or business systems before" "I'm comfortable debugging inherited code and fixing production issues independently" "I've worked on data consolidation or integration projects (bonus if post-M&A)" "I write advanced SQL and can optimize queries for performance" "I can work independently but collaborate well with product and business teams"
This might NOT be the right fit if: 
You're looking for pure people management (this is technical leadership, not team management) You're uncomfortable with complex, messy data integration challenges You prefer greenfield projects over consolidating existing systems Azure Data Factory is not your strength (it's non-negotiable here)
Common Questions
"Is this a 'lead' role with people management?" No - this is technical leadership, not people management. You'll guide architecture and implementation, mentor through code reviews, but you won't have direct reports. Think "Lead Developer" not "Development Manager."
"What happens after the end of the project?" Based on success and company needs, there may be opportunities to extend for ongoing platform development, Salesforce integration work, or other Clients' and CI&T projects.
"How much of this is ERP-specific vs. general data development?" About 60% general Azure data development, 40% ERP/business system integration. You don't need to be an ERP expert, but understanding how to extract and model financial/operational data is important.
"What's the most challenging part of this project?" Consolidating data from 9 different companies with different systems, business processes, and data quality standards - creating consistent, unified data models that serve global reporting needs.
"What level of English is required?" You'll need to communicate clearly in written and verbal English - daily chat messages, video meetings with US/EMEA stakeholders, technical documentation. Doesn't need to be perfect, but professional communication is essential.
#LI-AG3
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. We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.

---