Data & Automation Engineer: Build End-to-End Data Pipelines

Joerns Healthcare Inc; Charlotte (NC); On-site; USD 110,000 - 125,000; Full time

Benefits offered by this job

Hands-on training

Comprehensive benefits package

401(k) retirement plan

Job summary

Joerns Healthcare Inc seeks a Data & Automation Engineer to design, build, and maintain automation, reporting, and integration solutions powering business operations. You will own end-to-end data workflows from source systems to polished, decision-ready reporting, across KNIME, n8n, SQL, Power BI, and SAP HANA.

You’ll translate complex data into insightful dashboards, troubleshoot across platforms, and manage CRM data integrations with HubSpot.

Qualifications

• Bachelor's degree in CS/CE/Data Science or equivalent.
• Experience with KNIME, n8n or similar workflow platforms.
• Strong SQL development and optimization skills (SQL Server, PostgreSQL).
• Hands-on experience designing Power BI reports/dashboards.
• Familiarity with SAP HANA including Calculation Views.
• Able to troubleshoot across data/reporting systems and multi-point integrations.

Responsibilities

• Build and maintain KNIME Server workflows and automations.
• Develop, deploy, and troubleshoot n8n workflows and server infrastructure.
• Design and maintain Power BI reports and dashboards.
• Develop and maintain SAP HANA Calculation Views.
• Write and optimize SQL for SQL Server and PostgreSQL.
• Manage HubSpot CRM data, including data cleanup and integrations.
• Support data integration and ETL processes across business systems.
• Troubleshoot and maintain automation, reporting, and database solutions.

Skills

KNIME

n8n

SQL

Power BI

SAP HANA

Troubleshooting

Data Integration

Education

Bachelor's degree in Computer Science, Computer Engineering or Data Science

Tools

HubSpot

KNIME Server

n8n

SQL Server

PostgreSQL

Job description

Joerns Healthcare Inc seeks a Data & Automation Engineer to design, build, and maintain automation, reporting, and integration solutions powering business operations. You will own end-to-end data workflows from source systems to polished, decision-ready reporting, across KNIME, n8n, SQL, Power BI, and SAP HANA.

You’ll translate complex data into insightful dashboards, troubleshoot across platforms, and manage CRM data integrations with HubSpot.