Job Description
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...