Data Engineer

Illumination Works; United States; On-site; USD 110,000 - 170,000; Full time

Job summary

Illumination Works seeks an experienced Data Engineer to design and maintain data pipelines and structures for advanced analytics and data science capabilities. You will collaborate with data scientists and stakeholders to ensure reliable, high-quality data for analysis.

Required 4+ years in data engineering, strong SQL/Python, Databricks, Delta Lake, and experience with ETL/ELT workflows. Must hold a Secret clearance and pass background checks. This role is based in the United States.

Qualifications

• 4+ years of experience as a Data Engineer or in a similar data-focused role.

Responsibilities

• Develop, maintain, and optimize 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 for analytics and data science needs.
• Collaborate with data scientists to understand data requirements and adapt pipelines accordingly.
• Create complex SQL queries using joins, aggregations, window functions, and advanced techniques.
• Integrate and transform data from multiple structured and semi-structured sources.
• Support data quality through validation, troubleshooting, and issue resolution.
• Document data sources, transformations, flows, schemas, and pipeline configurations.
• Partner with engineers, analysts, and stakeholders to deliver data solutions for mission goals.

Skills

SQL

Python

Databricks

ETL/ELT

Delta Lake

Data modeling

Data integration

Troubleshooting

Communication

Analytical thinking

Education

Bachelor's degree in Computer Science, Mathematics, Data Science, Engineering, or a comparable academic discipline

Tools

Databricks

Job description

We are seeking an experienced Data Engineer to support challenging data engineering, data management, and analytics initiatives. In this role, you will develop and maintain data pipelines and data structures that enable advanced analytics and data science capabilities. You will work closely with data scientists and other technical stakeholders to understand evolving data needs, incorporate new data elements, and ensure reliable, high-quality data is available for analysis.

Preferred Qualifications

• 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

Required 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

Key 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

Do you have what it takes?

We value passion, curiosity, and perseverance, along with the ability to communicate ideas and results to diverse audiences. We look for people who thrive in both collaborative and independent assignments, quickly learn new data and business domains, and enjoy solving complex data challenges.

About ILW

At Illumination Works, we know data, and we should, we've been doing it since we started in 2006! We specialize in everything data from big data to data science, data engineering, software engineering, and cloud design. We are a trusted technology partner in user-centered digital transformation-delivering impactful business results to clients. We partner with customers to solve their unique technology and data challenges and stay on top of modern technologies and advancements leveraging our Innovation Lab. Check out our website to learn more at www.ilwllc.com.

Why choose us?

We invest in our employees in all aspects of their life and we value family. We offer market-competitive salary, a generous PTO package, and comprehensive medical, dental, vision and life insurance plans. We also offer 401K, short/long-term disability insurance, a fun and engaging culture, and training opportunities to keep you up to speed on the latest technologies.

Commitment to Non-Discrimination

All qualified applicants will receive consideration for employment without regard to disability, status as a protected veteran, or any other status protected by applicable federal, state, local, or international law.

Know Your Rights Poster

Accommodations

If you are an individual with a disability and would like to request a reasonable workplace accommodation for any part of our employment process, please contact the Human Resources Staff by sending an email to [e-mail]. This option is reserved only for individuals who are requesting a reasonable workplace accommodation. It is not intended for other purposes or inquiries.

Notification for current or previously cleared professionals:

Official U.S. Government information appearing in the public domain shall not automatically be considered UNCLASSIFIED or approved for public release. ILW recognizes that information contained in resumes of current or previously cleared professionals may be sensitive, containing potentially proprietary and/or protected information. Protected Information is considered classified, in the process of a classification determination, or unclassified, but protected by statute. Therefore, all resumes should be approved for public release by a U.S. Government Official with Original Classification Authority, prior to posting the resume to ILW’s applicant tracking system.

By submitting my resume, I understand that I am NOT authorized to upload content with Official U.S. Government information that is considered, sensitive, proprietary, or protected.