[Job - 25548] Lead Data Developer - Global Data Platform Integration, Colombia

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. Our benefits include: - Premium Healthcare - Meal voucher - Maternity and Parental leaves - Mobile services subsidy - Sick pay-Life insurance - CI&T University    - Colombian Holidays - Paid Vacations And many others.  Collaboration is our superpower, diversity unites us, and excellence is our standard.  We value diverse identities and life experiences, fostering a diverse, inclusive, and safe work environment. We encourage applications from diverse and underrepresented groups to our job positions.