Data Integration Specialist

Freelance Latin America

Data Integration Specialist responsible for building and maintaining automated data pipelines. Focusing on data formatting and reliability for reporting in a remote business intelligence environment.

Posted 6/25/2026part-timeRemote • 🇻🇪 VenezuelaMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

ERPETLPandasPostgresPythonSQL

About the role

Key responsibilities & impact

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

What you’ll need

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.

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

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

Hard Skills & Tools

ETLELTSQLPostgreSQLT-SQLPower QueryPythonpandasREST APIsOAuth2

Soft Skills

attention to detailproblem-solvingsystems thinkingdocumentationindependence