Description

Design, build, and maintain scalable data integration pipelines that move and transform data across enterprise systems, ensuring accurate and timely flow from source systems into analytics environments.

This role is remote.

Responsibilities

• Design, develop, test, and maintain ETL/ELT pipelines to extract, transform, and load data from multiple source systems into target data warehouses or lakes.
• Build and optimize integrations between enterprise source systems (ERP/MRP) and downstream reporting or analytics platforms.
• Monitor, troubleshoot, and tune existing ETL jobs for performance, reliability, and scalability.
• Implement data quality checks, validation rules, and error-handling within pipelines.
• Collaborate with data architects and BI teams to support data modeling and warehouse design.

Required Skills

• 8+ years of hands-on experience developing ETL/ELT processes in an enterprise environment.
• Strong SQL skills, including complex query writing, performance tuning, and stored procedure development.
• Experience building and maintaining packages in SSIS (SQL Server Integration Services).
• Proficiency with Microsoft SQL Server, Snowflake, and/or Microsoft Fabric.
• Ability to integrate data using REST/SOAP web services.
• Experience with Python for data processing or automation.
• Solid understanding of data warehousing concepts, dimensional modeling, and data quality governance.
• Experience managing version control, deployment, and change management processes for ETL code.

Preferred Skills

• Direct experience integrating data from NetSuite ERP and/or Epicor MRP.
• Hands-on experience with Boomi for integration and orchestration.
• Experience with Fivetran for automated data replication or ELT.

Key Skills

Education

Any Graduate