Wells Lamont LLC needs to analyze site usage and assist in marketing efforts by deploying digital tracking technologies. They are looking for a Data Automation Engineer Intern to build and maintain automation solutions using Python and SQL, with exposure to BI reporting and executable deployment, to support multiple departments and improve data processes.
Requirements
- Knowledge of Python (required)
- Knowledge of SQL (highly preferred)
- Prior experience automating tasks is a plus
- Experience with MySQL
- Experience with Git/GitHub
Responsibilities
- Develop and maintain automation scripts for cross-department processes (file handling, scheduled jobs, API calls, Data Pipelines, etc.).
- The potential to package Python scripts into executable (.exe) files for ease of distribution and use.
- Write and optimize SQL queries within MySQL to extract, validate, and analyze data.
- Use Git/GitHub for collaborative development and source code management.
- Support supervisor-directed projects and ad-hoc initiatives.
Other
- Pursuing an undergraduate (or Graduate) degree in Mathematics, Computer Science, Data Science, Informational Systems, or related field
- Rising junior status or above
- Interns will complete a capstone type project over the summer culminating in a presentation to business leadership.