KI
Senior Data Engineer - Contract
Kaygen Inc.
- 🇺🇸 United States
- Hybrid
- Senior
- 13 hours ago
- $50 – $65 / hour
- Power BI
- AWS S3
- AWS
- REST API
- Oracle Database
- Azure Data Factory
- AWS Glue
- Step Functions
- Python
- SQL
- PySpark
- Delta Lake
- Parquet
- AWS Lambda
- Git
- Databricks
- Microsoft Fabric
- Kaizen
- Pension
13 hours ago
KAYGEN is an emerging leader in providing top talent for technology-based staffing services. We specialize in providing high-volume contingent staffing, direct hire staffing and project-based solutions to companies worldwide ranging from startups to Fortune 500 and Managed Service Providers (MSP) across a wide variety of industries.
Title:Senior Data Engineer
Duration:Through 4/30/27
Location:Remote with 50% travel to Indianapolis, IN - expenses permitted
Responsibilities
- Senior Data Engineer (8+ years) will be responsible for designing, building, and maintaining data pipelines that extract data from source systems, transform it through the medallion architecture layers, and prepare it for consumption by the analytics layer.
- This role will work closely with the Power BI Developer to ensure data is properly structured, documented, and accessible for reporting and analytics.
- Following EDB standard, design and establish AWS S3 bucket structure for data lake (Bronze/Silver/Gold zones) with Red CCI security controls
- Build new data pipelines to extract data from the selected SaaS-based HSE systems
- Enhance/extend data pipelines using the dataset from AWS EDB Asset related data products and digital solutions
- Build data ingestion pipeline for Manufacturing Execution System via REST API (Lambda-based extraction).
- Data pipeline to SaaS based tools to integrate data into the data warehouse
- Implement CDC pipeline for LabVantage LIMS using AWS DMS from Oracle database (or Azure Data Factory)
- Develop Bronze-to-Silver transformations using AWS Glue or Azure Data Factory depending on data domains
- Configure AWS Glue Data Catalog with appropriate metadata and Red CCI classification tags
- Connect to EDB marketplace for enterprise reference data
- Build Silver-to-Gold transformations creating batch-centric data products
- Implement data quality checks and monitoring dashboards
- Develop orchestration workflows using AWS Step Functions
- Support Power BI Developer in validating OneLake shortcut connectivity to Gold zone
- Seeking at least 8 years of experience as a Data Engineer
- Python
- SQL
- AWS S3 / Data Lake Architecture
- PySpark / AWS Glue
- Delta Lake / Parquet
- AWS Lambda
- AWS DMS / CDC Patterns
- REST API Integration
- Git / Version Control
- Databricks
- Microsoft Fabric
- Data Products
At KAYGEN, people are at the heart of everything we do. We foster a diverse, inclusive, and employee-driven culture where every individual is valued, empowered, and encouraged to bring their authentic self to work. Our candidate-first approach means we are committed to understanding your career goals and connecting you with opportunities that align with your aspirations, skills, and potential. Whether you're taking the next step in your career or searching for your dream opportunity, KAYGEN is more than a staffing partner—we're a community dedicated to helping you grow, succeed, and thrive. Join us and discover a place where your talent is recognized, your ambitions are supported, and your future is built alongside a team that invests in your success every step of the way.
Our team of experienced staffing experts will work with you to find you the best opportunity. For more information, please visit us atwww.kaygen.com.
Benefits:
- Free Healthcare Insurance
- 401(k) Retirement Plan
- Free Life Insurance
- Sick Time Off
- Mentorship Program
- Certifications
- Referrals
- Family and Wellness benefits
- Continuous Growth and Career Development
Senior Data Engineer - Contract · Kaygen Inc.