Data Warehouse ETL Expert for ERP Data Integration - Remote

Overview

A skilled Data Warehouse ETL Expert is needed for a part-time project to integrate ERP data into a SQL Data Warehouse.

In Short

• Load data into SQL Data Warehouse from Sedona Office and Connectwise MSP Software.
• Maintain existing SQL Data Warehouse structure while integrating new data.
• Perform data mapping from source systems to target tables.
• Utilize SQL queries and API calls for data extraction.
• Apply knowledge of business processes and data analysis.
• Create detailed mapping instructions for data integration.
• Quality assure results and provide remediation instructions.
• Collaborate with ETL developers and FPA team.
• Work 3-4 hours a day during Eastern US business hours.
• Engage with offshore teams during specified overlap hours.

Requirements

• Proven experience in SQL, data warehouse, and ETL processes.
• Experience with Sedona Office and/or Connectwise ERP systems.
• Strong T-SQL, SSIS, and ETL development skills.
• Capability to work with API integration.
• Ability to query databases directly and via API calls.
• Familiarity with business process concepts.
• Strong problem-solving skills and attention to detail.
• Excellent communication skills.

Benefits

• Remote opportunity.
• Flexible working hours.