Technical Consultant Data Integration

Job Description

A self-motivated individual desiring to play an integral part in a growing insightsoftware product . We are seeking a highly experienced Data Integration Subject Matter Expert (SME) to lead and support enterprise data initiatives across multiple ERP platforms. This role will focus on designing and implementing scalable ELT processes, integrating data from diverse systems, and creating optimized views to support analytics, reporting, and operational needs. As a member of the Professional Services team, you will be providing the following services to our Enterprise customers and partners :

Key Responsibilities

• Serve as the SME for data integration across multiple ERP systems (e.g., SAP, Oracle, Workday, Microsoft Dynamics, NetSuite).
• Design and implement ELT pipelines using modern tools (e.g., Informatica, Talend, dbt, Azure Data Factory, Fivetran, Matillion).
• Develop and maintain reusable integration patterns and frameworks to support enterprise-wide data flows.
• Create and optimize database views to support business intelligence, operational reporting, and data accessibility.
• Collaborate with cross-functional teams including data architects, business analysts, and application owners to ensure alignment on data strategy.
• Troubleshoot and resolve complex data integration issues across cloud and on-prem environments.
• Document technical designs, data mappings, and integration workflows.
• Provide guidance and mentorship to development teams on data integration best practices.

Qualifications

Experience Level : 4 to 7 Years

Required Qualifications

Preferred Qualifications

Non-Technical Skills

Education

Additional Information

All your information will be kept confidential according to EEO guidelines.

insightsoftware About Us : Hear From Our Team - InsightSoftware (wistia.com)

insightsoftware About Us : Hear From Our Team - InsightSoftware (wistia.com)

Background checks are required for employment with insightsoftware, where permitted by country, state / province.

At insightsoftware, we are committed to equal employment opportunity regardless of race, color, ethnicity, ancestry, religion, national origin, gender, sex, gender identity or expression, sexual orientation, age, citizenship, marital or parental status, disability, veteran status, or other class protected by applicable law. We are proud to be an equal opportunity workplace.

Skills Required

Azure Data Factory, Informatica, Azure, dbt, ELT, Aws, Talend, Gcp, Sql, Etl, Fivetran