Data Engineer – Integrations & Automation

KDCI Outsourcing is seeking a Data Engineer – Integrations & Automation to design, implement, and maintain data pipelines connecting multiple systems — including ERP, HubSpot CRM, and operational platforms — into a Snowflake-based data environment.

This hands-on role is ideal for someone who enjoys solving data challenges, automating workflows, and building reliable integrations that power business insights and efficiency. You’ll work closely with cross-functional teams to ensure seamless data flow, consistent documentation, and scalable data processes across the organization.

Responsibilities:

• Implement and maintain data pipelines and integrations into Snowflake, following established architecture and data standards.

• Build and automate data workflows using tools such as Azure Data Factory, Power Automate, Python, or N8N.

• Integrate data from ERP, HubSpot, logistics, and other business systems to support analytics and reporting.

• Monitor, troubleshoot, and enhance data quality, synchronization, and performance across systems.

• Collaborate with internal teams to ensure data consistency, transparency, and documentation accuracy.

• Support dashboarding, analytics, and automation initiatives that improve operational efficiency.

• Identify opportunities for small automation or low-code process improvements across departments.

Requirements

• 5–7 years of experience in data engineering, systems integration, or process automation.

• Strong command of SQL and hands-on experience with ETL / data pipeline tools (e.g., Azure Data Factory, dbt, Fivetran, Airbyte).

• Skilled in Python for data transformation and automation tasks.

• Familiarity with cloud environments, preferably Microsoft Azure.

• Experience integrating CRM systems, particularly HubSpot.

• Understanding of data modeling, version control (GitHub), and API integrations.

• Excellent communication, documentation, and collaboration skills.

• Bachelor’s degree in a technical field; Master’s degree preferred (Data Engineering, Computer Science, Data Science, or related).

Nice to Have

• Experience with Snowflake or modern data warehouses.

• Familiarity with Power BI, Power Apps, or other automation tools.

• Knowledge of CI/CD, dbt, or data-as-code best practices.

• Exposure to data governance and documentation frameworks.