We are seeking a highly skilled Senior Data Integration & API Engineer to join our client's dynamic data engineering team.
Title: Senior Data Integration & API Engineer - Database Engineer: III
Company: Established US National banking client
JobID #: 8685
Position Type: Contract(6 months with possible extensions)
Location: Akron, OH, Columbus, OH or around bank's other U.S. footprint location.
Onsite Flexibility: 100% Remote
Prefer US Citizen or Permanent resident or applicants on H4-EAD status
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.
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.
Required Qualifications
- 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)
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
Tools & Technologies
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
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
Remarks:
100% remote job
If you qualify for this role and are interested in applying to this job, please call me at 408-499-2397 and share your resume to support our discussions.
Thank you,
James Parakka
[email protected]
www.centralpointpartners.com
Pay: From $60.00 per hour
Benefits:
- Dental insurance
- Health insurance
- Vision insurance
Education:
Experience:
- APIs: 5 years (Required)
- SQL: 5 years (Required)
- Data pipelines: 3 years (Required)
- AWS: 3 years (Required)
- ETL: 3 years (Required)
- Data lake: 3 years (Required)
- Snowflake: 2 years (Preferred)
- Tableau: 3 years (Preferred)
- REST: 3 years (Required)
Work Location: Remote
