Data Integration & API Engineer
Role details
Job location
Tech stack
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