Luke B.
About Luke B.
Luke B. is a Senior Data Engineer at Illuminate Education, Inc. in Santa Clara, California, where he has worked since 2021, specializing in automation and data integration.
Work at Illuminate Education
Luke B. has been employed at Illuminate Education, Inc. as a Senior Data Engineer since 2021. In this role, he focuses on automating data processes and implementing new school district configurations. His responsibilities include setting up FTP accounts, creating EVL packages, and ensuring the proper configuration of instances. He has contributed to the development of various data interfaces and automation scripts that enhance the efficiency of data handling within the organization.
Education and Expertise
Luke B. has a diverse educational background. He studied at San Jose State University, where he earned a Bachelor’s Degree in Business Administration and Management from 2005 to 2010. Prior to that, he attended Cogswell Polytechnical College for a year, focusing on Audio Engineering from 2003 to 2004. He also studied at San Jose City College for one year from 2004 to 2005. This combination of studies has equipped him with a broad skill set applicable to his role in data engineering.
Technical Skills and Projects
In his current position, Luke B. has automated various data processes using SQL Server, SSIS, and Python. He automated the loading of student accommodations from TestHound using a SQL Server stored procedure and SSIS package. Additionally, he developed a Python script to load FTP file records into a Google Sheet every 30 minutes from an AWS server. His work includes implementing new API interfaces for Clever API, Skyward OneRoster API, and Certica AB Connect, enhancing data retrieval and integration capabilities.
Data Management Initiatives
Luke B. has been involved in several data management initiatives at Illuminate Education. He created a process to report on stale roster data files, utilizing a combination of Python scripts, PowerShell scripts, a SQL Server stored procedure, an SSIS package, and an SSRS report. His efforts in automating data loading and reporting contribute to improved data accuracy and operational efficiency within the organization.