Data Integration & API Engineer

Job Description

We are seeking a Senior Data Integration & API Engineer to design, develop, and maintain scalable data pipelines that extract data from APIs, ingest that data into Huntington’s enterprise data lake, and transform it into structured, consumable datasets for analytics and reporting.

This role sits at the intersection of integration architecture, data engineering, and analytics enablement, partnering closely with Data Engineering, Architecture, and business analytics teams to deliver high-quality, governed data assets.

• Design and develop solutions to extract data from APIs (REST/JSON, OAuth-secured APIs).

• Build scalable ingestion pipelines to land data into the Enterprise Data Lake (landing → raw → curated layers).

• Ensure integrations follow enterprise integration patterns (API Gateway, Event Hub, EIP).

• Optimize ingestion patterns (batch vs near real-time).

• Transform raw API data into curated datasets.

• Build ETL/ELT pipelines supporting data quality and schema compliance.

• Implement partitioning and performance tuning.

• Structure data for Snowflake and downstream analytics tools.

• Support Tableau dashboards and reporting needs.

• Align to enterprise data models.

• Partner with enterprise architecture teams for API onboarding.

• Ensure compliance with data and API standards.

• Develop automated pipelines and monitoring processes.

• Troubleshoot ingestion failures.

• Reliable ingestion of API data into the data lake

• High-quality datasets for analytics

• Compliance with enterprise standards

• Reduced onboarding time for new data sources

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances.

If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to  To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:

• Bachelor’s degree in Computer Science or related field

• 5+ years experience in API integration and data engineering

• Strong experience with REST APIs, SQL, and data pipelines

• Experience in cloud environments (AWS preferred

• API Gateway, Event Hub, Query Hub, EIP

• AWS (S3, Glue, Lambda)

• ETL frameworks

• Data Lake

• Snowflake

• Tableau

• Python, SQL

• JSON, OpenAPI Preferred Qualifications

• Experience with enterprise integration platforms

• Familiarity with Snowflake and AWS Data Lake

• Experience in data modeling and governance

• Exposure to Tableau or other BI tools