Data Integration Specialist
New
F
Freelance Latin AmericaBusiness Intelligence
Venezuela, Bolivarian Republic of. Colombia. Argentina. Mexico. Costa Rica. Chile, Monday to Friday, 8:00 AM – 12:00 PM (EST)Part-TimeMiddle
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Required Skills
- PythonSQLMicrosoft Power BIOAuthPandasRESTful APIsJSON
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.
Responsibilities
- 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.
View Full Description & ApplyYou'll be redirected to the employer's site
