Data Integration & API Engineer

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.
Key Responsibilities

API Data Integration & Ingestion
- 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).

Data Processing & Transformation
- Transform raw API data into curated datasets.
- Build ETL/ELT pipelines supporting data quality and schema compliance.
- Implement partitioning and performance tuning.

Data Modeling & Analytics Enablement
- Structure data for Snowflake and downstream analytics tools.
- Support Tableau dashboards and reporting needs.
- Align to enterprise data models.

Integration Architecture & Governance
- Partner with enterprise architecture teams for API onboarding.
- Ensure compliance with data and API standards.

Automation & Reliability
- Develop automated pipelines and monitoring processes.
- Troubleshoot ingestion failures.
Success Measures
- 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 HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/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


Integration & API Layer
- API Gateway, Event Hub, Query Hub, EIP

Data Pipeline & Processing
- AWS (S3, Glue, Lambda)
- ETL frameworks

Data Storage & Analytics
- Data Lake
- Snowflake
- Tableau

Development
- 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

Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.