Wells Lamont LLC is looking for a Data Automation Engineer Intern to support multiple departments by building and maintaining automation solutions using Python and SQL, with exposure to BI reporting and executable deployment.
Requirements
- Knowledge of Python (required); prior experience automating tasks is a plus.
- Knowledge of SQL (highly preferred); experience with MySQL strongly preferred.
- Familiarity with Git and GitHub (preferred).
- Knowledge of Power BI or other data visualization tools (preferred).
- Understanding of relational database concepts (preferred).
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
- Demonstrated leadership & academic achievement in student & extracurricular activities
- Adaptability & ability to work independently
- Strong analytical, problem solving, and critical thinking skills
