Senior data engineer - contract

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.

Technical Skills - Required

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

Rate: $ 50 - 65

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 at www.kaygen.com.

Benefits: Free Healthcare Insurance, 401(k) Retirement Plan, Free Life Insurance, Sick Time Off. Achieve your Kaizen by clicking here. A unique and exclusive talent community supported by KAYGEN, that includes programs like: Mentorship Program, Certifications, Referrals, Family and Wellness benefits, Continuous Growth and Career Development.