Note: The job is a remote job and is open to candidates in USA. Genesis10 is currently seeking a Senior Data Integration & API Engineer for a Remote position with a Regional Financial Institution located in Columbus, OH. This role involves designing, developing, and maintaining scalable data pipelines for analytics and reporting, while collaborating closely with Data Engineering and business analytics teams.
Responsibilities
- 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
Skills
- 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)
- 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
Benefits
- Access to hundreds of clients, most who have been working with Genesis10 for 5-20+ years
- The opportunity to have a career-home in Genesis10; many of our consultants have been working exclusively with Genesis10 for years
- Access to an experienced, caring recruiting team (more than 7 years of experience, on average)
- Behavioral Health Platform
- Medical, Dental, Vision
- Health Savings Account
- Voluntary Hospital Indemnity (Critical Illness & Accident)
- Voluntary Term Life Insurance
- 401K
- Sick Pay (for applicable states/municipalities)
- Commuter Benefits (Dallas, NYC, SF, and Illinois)
Company Overview