• Assess legacy data and reporting workloads to identify where automation replaces manual effort. • Lead the migration of Informatica-based data workloads to Databricks, ensuring performance, reliability, and data integrity. • Design and execute an automation-first modernization strategy for data pipelines, reporting systems, and analytics platforms. • Apply tool-assisted and AI-assisted techniques to accelerate modernization while maintaining compliance and control. • Build repeatable frameworks and patterns for: Data ingestion, transformation, and orchestration; Reporting and analytics modernization; Data validation, reconciliation, and quality controls. • Establish governance to ensure modernization efforts are consistent, auditable, and scalable. • Partner with distributed data teams to deploy and scale modernization patterns across environments. • Provide hands-on technical leadership while remaining engaged in execution.

• 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

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.