← Back to jobsJob ID col-cmv8edtqw053toz01oqjakv2b

Illumination WorksPosted 30+ days ago

Data Engineer

Full-time
Remote
4+ years
$401K/yr
Posted 30+ days ago

Illumination Works is a technology and data solutions company specializing in data engineering, data science, software engineering, and cloud design. The Data Engineer will develop and maintain data pipelines, data structures, Databricks notebooks, and data integration workflows to support analytics and data science initiatives. The role will collaborate with data scientists and other stakeholders to ensure reliable, high-quality data and optimize data solutions for mission requirements.

Posted
30+ Days Ago
Source
Ethic Leaf recruiter
Sector
Information Technology & AI

No employer link yet — an Ethic Leaf recruiter forwards your application

Responsibilities

  • Develop, maintain, and enhance data pipelines using Python, SQL, and Databricks
  • Develop and maintain Databricks notebooks supporting data ingestion, transformation, and delivery
  • Design and maintain data tables, schemas, and Delta Lake structures to support analytics and data science requirements
  • Work closely with data scientists to understand data requirements and modify pipelines, tables, and data structures as needs evolve
  • Develop complex SQL queries using joins, aggregations, window functions, and other advanced techniques to transform and prepare data
  • Integrate and transform data from multiple structured and semi-structured data sources
  • Support data quality through validation, troubleshooting, and resolution of data issues
  • Optimize data pipelines, SQL queries, and data structures for performance
  • Document data sources, transformations, data flows, schemas, and pipeline configurations
  • Collaborate with data scientists, engineers, analysts, and business stakeholders to deliver data solutions that support mission requirements

Qualifications

  • 4+ years of experience as a Data Engineer or in a similar data-focused role
  • Possess advanced SQL skills (i.e., complex joins, aggregations, window functions, transformations)
  • Proficiency with Python for data engineering and transformation
  • Hands-on experience with Databricks, including development and maintenance of notebooks and data pipelines
  • Experience developing and maintaining ETL/ELT pipelines and data integration workflows
  • Experience with Delta Lake
  • Experience with database design, data modeling, schema development, and data-centric documentation
  • Experience integrating and transforming data from multiple data source types
  • Experience troubleshooting data issues and optimizing queries and pipelines
  • Strong analytical and problem-solving skills
  • Excellent verbal and written communication skills and ability to collaborate effectively with technical and business stakeholders
  • Bachelor's degree in Computer Science, Mathematics, Data Science, Engineering, or a comparable academic discipline
  • Must hold an active Secret clearance with eligibility for Top Secret (U.S. Citizenship required)
  • Must successfully pass required background screening and drug testing

Preferred

  • Experience supporting data scientists and advanced analytics or machine learning use cases
  • Functional knowledge of Department of War or U.S. Air Force data sources and systems
  • Experience working with logistics, supply chain, maintenance, or other operational data
  • Holds Top Secret clearance
  • Department of War Data
  • U.S. Air Force Data
  • Data Sources And Systems

Required skills

SQLPythonDatabricksETL/ELT PipelinesDelta LakeData ModelingDatabase DesignData IntegrationData TransformationData PipelinesQuery Optimization

Nice to have

• CompTIA Security+ certification

Full job description

Illumination Works is a technology and data solutions company specializing in data engineering, data science, software engineering, and cloud design. The Data Engineer will develop and maintain data pipelines, data structures, Databricks notebooks, and data integration workflows to support analytics and data science initiatives. The role will collaborate with data scientists and other stakeholders to ensure reliable, high-quality data and optimize data solutions for mission requirements.

Responsibilities

  • Develop, maintain, and enhance data pipelines using Python, SQL, and Databricks
  • Develop and maintain Databricks notebooks supporting data ingestion, transformation, and delivery
  • Design and maintain data tables, schemas, and Delta Lake structures to support analytics and data science requirements
  • Work closely with data scientists to understand data requirements and modify pipelines, tables, and data structures as needs evolve
  • Develop complex SQL queries using joins, aggregations, window functions, and other advanced techniques to transform and prepare data
  • Integrate and transform data from multiple structured and semi-structured data sources
  • Support data quality through validation, troubleshooting, and resolution of data issues
  • Optimize data pipelines, SQL queries, and data structures for performance
  • Document data sources, transformations, data flows, schemas, and pipeline configurations
  • Collaborate with data scientists, engineers, analysts, and business stakeholders to deliver data solutions that support mission requirements

Preferred

  • Experience supporting data scientists and advanced analytics or machine learning use cases
  • Functional knowledge of Department of War or U.S. Air Force data sources and systems
  • Experience working with logistics, supply chain, maintenance, or other operational data
  • CompTIA Security+ certification
  • Holds Top Secret clearance
  • Data Scientist Support
  • Advanced Analytics
  • Machine Learning
  • Department of War Data
  • U.S. Air Force Data
  • Data Sources And Systems
  • Logistics Data
  • Supply Chain Data
  • Maintenance Data
  • Operational Data
  • CompTIA Security+ Certification

Benefits

  • Remote work arrangement
  • A generous PTO package
  • Comprehensive medical, dental, vision and life insurance plans
  • 401K
  • Short/long-term disability insurance
  • A fun and engaging culture
  • Training opportunities to keep you up to speed on the latest technologies

Company

  • Data science, engineering, and cloud solutions for digital transformation.
  • Beavercreek, Oregon, USA
  • http://illuminationworksllc.com/
  • Founded in 2006
  • 51-200 employees

Qualifications

  • 4+ years of experience as a Data Engineer or in a similar data-focused role
  • Possess advanced SQL skills (i.e., complex joins, aggregations, window functions, transformations)
  • Proficiency with Python for data engineering and transformation
  • Hands-on experience with Databricks, including development and maintenance of notebooks and data pipelines
  • Experience developing and maintaining ETL/ELT pipelines and data integration workflows
  • Experience with Delta Lake
  • Experience with database design, data modeling, schema development, and data-centric documentation
  • Experience integrating and transforming data from multiple data source types
  • Experience troubleshooting data issues and optimizing queries and pipelines
  • Strong analytical and problem-solving skills
  • Excellent verbal and written communication skills and ability to collaborate effectively with technical and business stakeholders
  • Bachelor's degree in Computer Science, Mathematics, Data Science, Engineering, or a comparable academic discipline
  • Must hold an active Secret clearance with eligibility for Top Secret (U.S. Citizenship required)
  • Must successfully pass required background screening and drug testing
  • Experience supporting data scientists and advanced analytics or machine learning use cases
  • Functional knowledge of Department of War or U.S. Air Force data sources and systems
  • Experience working with logistics, supply chain, maintenance, or other operational data
  • CompTIA Security+ certification
  • Holds Top Secret clearance

Required skills

  • SQL, Python, Databricks, ETL/ELT Pipelines, Delta Lake, Data Modeling, Database Design, Data Integration, Data Transformation, Data Pipelines, Query Optimization

Preferred skills

  • CompTIA Security+ certification, • Holds Top Secret clearance

Experience

  • 4+ years

Job details

Employment type

Full-time

Seniority level

4+ years

Date posted

Sep 18, 2026

Work mode

Remote

Job source

Ethic Leaf recruiter

Company

Illumination Works

Information Technology & AI

Data science, engineering, and cloud solutions for digital transformation.

See all 2 jobs from Illumination Works →

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs

Airbnb

1d ago

New

Data Engineer Tech Foundations

Full-timeRemoteUnited States$162K – $186K/yr

Airbnb is hiring a Data Engineer to build and operate reliable, reusable datasets and pipelines that support AI usage and cost measurement, Unit Economics, enterprise application data, and critical financial metrics.

Why similarSame roleData ModelingRemote

Coinbase

1d ago

New

Senior Software Engineer, Data Engineering Platform

Full-timeRemoteUnited States$186K – $219K/yr

Coinbase is hiring a Senior Software Engineer for its Data Platform team. The role builds and maintains SDKs, self-service applications, reusable abstractions, and security and observability tooling that help internal teams create, manage, and use data…

Why similarSame roleData PipelinesRemote

Curana Health

1d ago

New

Data Engineer

Full-timeRemoteUnited StatesCompetitive

Curana Health is hiring a Data Engineer to build, optimize, and maintain data pipelines supporting clinical, operational, and analytical reporting.

Why similarSame roleDatabricksRemote

Get new Data Engineer jobs by email

Create job alert

Data Engineer

Illumination Works · $401K/yr

Apply via Ethic Leaf