Data Integration Specialist

Se busca Data Integration Specialist para construir, optimizar y mantener pipelines de datos automatizados para un entorno de inteligencia empresarial remoto.

Descripción del puesto

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.

Responsabilidades

• Construir y gestionar pipelines de datos
• Conectar fuentes de datos a través de APIs REST
• Preparar y transformar datasets complejos
• Configurar y monitorear conexiones de Power BI
• Crear integraciones de API estables

Skills requeridas

Beneficios

• Trabajo remoto
• Oportunidad de crecimiento
• Soporte y capacitación

Trabajos similares

Más ofertas de Freelance Latin America