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, an...