CI&T

Lead Data Developer – Global Data Platform Integration

CI&T

full-time

Posted on:

Location Type: Remote

Location: Remote • Colorado • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AzureERPOracleSQL

About the role

  • You'll be joining a strategic data platform integration project to consolidate data from different acquired companies into one unified Azure-based data warehouse.
  • 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.
  • Design and build Azure Data Factory pipelines to integrate data from multiple ERP systems.
  • 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.

Requirements

  • 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
  • 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
  • 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
  • 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
Benefits
  • Premium Healthcare
  • Meal voucher
  • Maternity and Parental leaves
  • Mobile services subsidy
  • Sick pay-Life insurance
  • CI&T University
  • Colombian Holidays
  • Paid Vacations

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
data engineeringdata pipelinesAzure Data FactoryAzure SQL DatabaseAzure Data Lake StorageSQLdimensional modelingdata warehouse designdata integrationdata transformation
Soft skills
independent problem-solvingproduction supporttechnical documentationcollaborationcommunication