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.
- 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)
- 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.