Data Integration & API Engineer

Genesis10
Columbus, United States of America
18 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 146K

Job location

Remote
Columbus, United States of America

Tech stack

API
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Data analysis
Application Integration Architecture
Information Engineering
Data Integration
ETL
JSON
Python
OAuth
Performance Tuning
SQL Databases
Tableau
Openapi
Enterprise Data Management
Data Storage Technologies
Cloud Platform System
Delivery Pipeline
Snowflake
Data Lake
Information Technology
Enterprise Integration
Amazon Web Services (AWS)
Api Gateway
REST
Data Pipelines

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

Requirements

  • 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)

Desired Skills:

  • 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

Benefits & conditions

Compensation: $60.00 - $70.00 per hour, W2, based on experience and qualfications

About the company

Ranked a Top Staffing Firm in the U.S. by Staffing Industry Analysts for six consecutive years, Genesis10 puts thousands of consultants and employees to work across the United States every year in contract, contract-for-hire, and permanent placement roles. With more than 300 active clients, Genesis10 provides access to many of the Fortune 100 firms and a variety of mid-market organizations across the full spectrum of industry verticals. For contract roles, Genesis10 offers the benefits listed below. If this is a perm-placement opportunity, our recruiter can talk you through the unique benefits offered for that particular client. Benefits of Working with Genesis10: * 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), For multiple years running, Genesis10 has been recognized as a Top Staffing Firm in the U.S., as a Best Company for Work-Life Balance, as a Best Company for Career Growth, for Diversity, and for Leadership, amongst others. To learn more and to view all our available career opportunities, please visit us at our website .

Apply for this position