• Design & implement a modern data warehouse using Amazon Redshift, ensuring scalability and performance. • Develop and maintain ETL pipelines using AWS Glue (Python/PySpark), moving data from SQL Server (RDS) and other sources. • Structure our S3 data lake for efficient storage, partitioning, and integration with Redshift. • Define data models (star schema, dimensional modeling) to support reporting and analytics. • Establish data governance—documentation, quality checks, and monitoring for pipelines. • Collaborate with BI teams to ensure the warehouse meets reporting needs (CRM, dashboards). • Optimize costs by tuning Redshift clusters, managing Glue job efficiency, and automating workflows. • Troubleshoot data infrastructure issues and optimize performance across systems. • Contribute to the long-term vision for the data platform, including new tools, workflows, and process automation. • Maintain documentation of data systems, flows, and integration strategies. • Support project planning and estimation in coordination with business and technical teams

• Design, develop, and maintain scalable data pipelines and ETL processes using Python and AWS services • Build and deploy serverless functions using AWS Lambda for data processing and automation • Implement data integration solutions connecting diverse source systems to analytics platforms • Mentor junior data engineers through pair programming, code reviews, and technical coaching • Collaborate with data analysts and business stakeholders to understand requirements and deliver solutions • Optimize data pipeline performance, reliability, and cost efficiency in AWS environments • Develop and maintain comprehensive documentation for data systems and processes • Participate in on-call rotation to support production data infrastructure • Contribute to the establishment of team coding standards and engineering best practices • Work with Git for version control and participate in collaborative development workflows

• Design, build, and maintain ETL/ELT pipelines for structured and unstructured datasets • Process and analyze customer, operational, and financial transaction data • Develop scalable data workflows and reusable scripts for automation and reporting • Maintain data models, metric definitions, and analytics documentation • Optimize SQL queries and improve data processing performance and reliability • Integrate external data sources such as ABS and Census datasets into existing databases • Support cloud-based data platforms and modern data lakehouse environments • Build dashboards and reports for internal and external stakeholders • Translate business requirements into actionable analytics and reporting solutions • Support KPI tracking, operational reporting, and customer behavior analysis • Help identify trends, anomalies, and opportunities through data-driven insights • Collaborate with engineers, analysts, and stakeholders in agile environments • Participate in planning, testing, debugging, and deployment activities • Contribute ideas to improve workflows, system reliability, and engineering processes • Adapt quickly to changing priorities and evolving business requirements • Support development of reusable templates, modular scripts, and data engineering best practices • Support additional engineering or analytics initiatives as needed • Identify opportunities to improve processes, systems, and performance • Contribute to a collaborative and high-performing team environment • Assist in maintaining data quality, governance, and documentation standards

Location and Travel Details: Dayton, OH area preferred, remote considered Launch Your Career with a Paid Data Engineering Internship! Are you ready to build the future of data? We’re offering an exciting paid internship in Data Engineering, where you’ll integrate into an existing project team to gain hands-on experience in a breadth of data engineering and software development areas. This is your chance to work hands-on with advanced technologies and powerful data pipelines, transforming data that fuels innovation and business success. If you’re passionate about data, problem-solving, and making an impact—apply now for this highly competitive opportunity and start engineering the future! The Illumination Works 2026 Internship Program runs from May 2026 to August 2026. Start and end dates within those months are flexible, ensuring a minimum internship duration of 10 or more weeks. Please note your availability, including start, end, and any vacation days/weeks on your Cover Letter. Responsibilities may include: - Assist in the development and/or maintenance of data pipelines that support data extraction, cleansing, transformation, and load processes - Work on large-scale data systems, ensuring the efficient and secure movement of data across various platforms and exposure to downstream processes - Implement data integration strategies and build processes for cleaning and aggregating raw data from multiple sources - Collaborate with data scientists to ensure seamless integration of machine learning models into data pipelines - Optimize data storage and retrieval processes to enhance system performance - Assist with the design and development of data infrastructure on cloud platforms (e.g., AWS, Azure) - Communicate findings and present results to the project team, leadership, and fellow interns, providing clear recommendations and next steps Must have qualifications: - Senior or recent graduate in a 4-year university pursuing a degree in a relevant field (i.e., Computer Science, Information Technology, Engineering, or other related scientific field) - Minimum GPA of 3.4 on a 4.00 scale - Understanding of ETL processes, data modeling, and database architecture - Experience with SQL, Python and/or Cypher, as well as familiarity with data technologies such as Databricks, Neo4j, Spark, or Kafka - Familiarity with cloud platforms (AWS, Azure) and data storage solutions (e.g., graph databases, SQL databases, NoSQL databases, data lakes) - Strong analytical skills and attention to detail in handling large data sets - Innovative, creative, out-of-box thinking with willingness to learn new skills - Strong verbal and written communication skills - Proficiency in MS Office Suite (Word, Excel, PowerPoint) - Acceptable candidates must successfully pass a drug test, pass a background screen, and provide official transcripts - US Citizenship Additional desired qualifications: - Experience with collaborative coding and source control tools (e.g., GitHub) - Experience working in an agile framework with tools such as Jira Application requirements: - Resume with GPA - Cover letter with why you are interested in the internship, why you feel you are the right fit for the internship, your goals for the internship, and your schedule availability - Letter of reference (strongly encouraged) About Illumination Works 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. Illumination Works is committed to hiring and retaining the best workforce. We hire the best talent for our customer’s needs. We make our hiring decisions without regard to race, color, religion, sexual orientation, gender identity or national origin, age, veteran status, disability, or any other protected class. Acceptable candidates must successfully pass a drug test and background screen.