Data Integration Specialist

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.