Freelance Latin America
Information Technology and Services
DataIntegrationSpecialist
Neural analysis suggests this role is
optimal for Mid+ candidates.
“Data Integration Specialist at Freelance Latin America. Skills: Data integration, ETL/ELT pipelines, SQL, Python. Build ETL/ELT pipelines. Manage ETL/ELT pipelines”
What You'll Achieve.
Ensure data arrives clean; Ensure data arrives structured; Ensure data arrives reliably
Industry & Context.
Solve unstructured data issues; Solve integration issues; Solve connectivity issues; Systems-thinking
What They're Looking For.
Must Have
Hands-on experience with automation and ETL tools, Understanding of REST APIs, JSON, OAuth2, and webhooks, Advanced Power Query / M language skills, Intermediate Python / pandas experience, Advanced SQL skills, Solid knowledge of relational databases, Experience with version control, Experience with code reviews, Experience with structured technical documentation, Attention to data integrity, Attention to accuracy, Attention to reliable pipeline performance, Ability to independently solve unstructured data issues, Ability to independently solve integration issues, Ability to independently solve connectivity issues, Systems-thinking mindset
What You'll Do.
Build ETL/ELT pipelines
Manage ETL/ELT pipelines
Connect data sources through REST APIs
Manipulate data using SQL
Transform datasets using Power Query / M
Transform datasets using Python
Configure Power BI Gateway
Monitor Power BI Gateway
Troubleshoot Power BI Gateway connections
Troubleshoot refresh schedules
Troubleshoot pipeline errors
Create API integrations
Establish standards for folder structures
Establish standards for API logging
Establish standards for documentation
Establish standards for Git workflows
Establish standards for branches
Establish standards for pull requests
Document integration architecture
Document pipeline flows
Document data sources
Document troubleshooting procedures
How You'll Work.
Team & Collaboration
International teams; Client's team
Communication Scope
Documentation
Process & Methodology
Git workflows, Branches, Pull requests
Full Job Description
We are looking for a Data Integration Specialist to build, optimize, and maintain automated data pipelines for a remote business intelligence environment. This role ensures operational and financial data from multiple systems arrives clean, structured, and reliably for reporting and analytics. ### Duties / Task to perform * Build and manage ETL/ELT pipelines using tools such as n8n, Microsoft Power Automate, and SQL. * Connect data sources through REST APIs, including OAuth authentication, JSON parsing, and webhook management. * Query, clean, and manipulate data using SQL, including PostgreSQL or T-SQL. * Prepare and transform complex datasets using advanced Power Query / M and Python before they feed into analytical models. * Configure, monitor, and troubleshoot Power BI Gateway connections, refresh schedules, and pipeline errors. * Create stable API integrations with third-party platforms such as ERP, POS, CRM, Excel, and SharePoint systems. * Establish and follow standards for folder structures, API logging, documentation, Git workflows, branches, and pull requests. * Document integration architecture, pipeline flows, data sources, and troubleshooting procedures. **Requirements** * Hands-on experience with automation and ETL tools such as n8n and/or Microsoft Power Automate. * Strong understanding of REST APIs, JSON, OAuth2, and webhooks. * Advanced Power Query / M language skills. * Intermediate Python / pandas experience for ETL and data transformation. * Advanced SQL skills and solid knowledge of relational databases. * Experience with version control, code reviews, and structured technical documentation. * Strong attention to data integrity, accuracy, and reliable pipeline performance. * Ability to independently solve unstructured data, integration, or connectivity issues with a systems-thinking mindset. **Schedule: Monday to Friday, 8:00 AM – 12:00 PM (EST)** **Benefits** * Fully remote work environment * Stable, long-term collaboration with potential to sca
Applying for this Data Integration Specialist role?
Most applicants get filtered before a human reads their resume. See if yours makes the cut.
ANONYMOUS · UNFILTERED
What do employees actually say about Freelance Latin America?
Real rants from real employees. Read before you apply.