# Data Integration Specialist

> Freelance Latin America · Venezuela, Bolivarian Republic of (Remote) · Part-time · Posted 2026-06-04

**Workplace:** remote

**Department:** IT

## 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 scale
-   Clear scope of responsibilities and structured workflows
-   Training and onboarding support
-   Opportunity to work with international teams
-   Exposure to modern BI, analytics, and financial reporting processes
-   Supportive and collaborative work culture
-   Opportunity for skill development and career growth

📌 Before You Apply, Please Read:

At Freelance Latin America, we’re excited to connect you with meaningful remote opportunities. However, we want to be clear:

⏰ These are professional roles with set schedules defined by the client.  
Consistent availability is expected. You will have a set work schedule determined by the client, and you are expected to be present during those hours.

🤝 You will be part of the client’s team.  
You’ll follow their company guidelines, communication practices, and workflows, ensuring seamless collaboration.

📈 KPIs and goals matter.  
Your performance will be measured to ensure alignment with client expectations and project objectives.

🧑‍🏫 Training may be required.  
You might need to complete training to fully understand your role, tools, and client processes.

🎯 Commitment and responsibility are essential.  
We work with clients who rely on your dedication to deliver consistent, high-quality results. This is key to building trust and long-term partnerships.

🚀 Ready to grow your career with us?  
Apply only if you are ready to commit, learn, and take ownership of your role.

## Apply

[Apply at Freelance Latin America](https://apply.workable.com/freelance-latin-america/j/95B2848BA4/apply)

---
Powered by [Workable](https://www.workable.com)