Data Engineer

Illumination Works

Data Engineer building data pipelines for analytics and machine learning at Illumination Works. Collaborating across teams to ensure reliable data for insights and experimentation.

Posted 4/11/2026full-timeRemote • 🇺🇸 United StatesMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

Amazon RedshiftAWSAzureCloudETLGoogle Cloud PlatformPythonSQL

About the role

Key responsibilities & impact

Develop and maintain metadata-driven data pipelines for ingestion, transformation, and delivery of data
Build and support ETL/ELT processes for both legacy and modern data sources
Implement data transformations to convert legacy formats (e.g., SFTP, flat files) into modern formats (e.g., XML, JSON, APIs)
Develop API integrations and data services supporting real-time and near real-time data exchange
Support implementation of data quality checks, validation rules, and monitoring processes
Collaborate with a Data Architect to implement data models, schemas, and integration patterns
Optimize pipelines and queries for performance, scalability, and reliability
Assist in documenting data flows, interfaces, and pipeline configurations
Support DevSecOps practices to ensure a standardized data environment, including implementing CI/CD pipelines, automated testing, and deployment
Work in cross-functional team with data scientists, data engineers, and business stakeholders

Requirements

What you’ll need

Experience developing and maintaining ETL pipelines and data integration workflows
Strong proficiency in SQL and Python
Experience with cloud platforms (AWS, Azure, GCP, GovCloud) and cloud-native architectures
Hands-on experience with cloud-based data warehouses and object storage (S3, Redshift, Snowflake)
Experience with API integration and data exchange
Understanding of database design principles, data modeling, schema development, and data-centric documentation
Experience integrating data from a variety of data source types
Experience improving code performance and query optimization
Outstanding problem-solving skills
Excellent verbal and written communication skills
4+ years of experience as a Data Engineer or similar role
Bachelor’s degree in Computer Science, Mathematics, or comparable academic discipline
Must have or be willing to obtain Secret Clearance (this requires US Citizenship)

Benefits

Comp & perks

market competitive salary
generous PTO package
comprehensive medical, dental, vision and life insurance plans
401K
short/long-term disability insurance
fun and engaging culture
training opportunities to keep you up to speed on the latest technologies

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETLELTSQLPythonAPI integrationdata modelingquery optimizationdata transformationdata quality checksDevSecOps

Soft Skills

problem-solvingcommunication

Certifications

Bachelor’s degreeSecret Clearance