Data Analyst Intern

About the Role

Key Responsibilities

• Generate scripts and queries in Microsoft (MS) Access and using SQL.
• Perform database queries and generate reports to support QC review of deliverables.
• Perform data analytics using tools like Microsoft PowerBI, Qlik, and Tableau.
• Manage large datasets, typically including .mdb files and photos, for reference and record purposes.
• Create data visualizations, dashboards, data forensics, and perform minimum programming in Python or other codes to support linking datasets or databases together to conduct data analysis.
• Generate visual and large language learning models to conduct analysis, simplify repetitive tasks, or automate workflows.
• Conduct activities in line with internal procedures, legislation, and industry standards.
• Pursue continuous professional development and maintain a high degree of discipline, knowledge, and awareness.
• Work in a safe manner at all times and report all health and safety incidents and concerns.
• Additional duties as required.

Requirements

• The ideal candidate will have completed at least 2 years of college course work prior to starting the internship.
• Qualified candidates will have experience using MS Office applications and will be proficient in Access and SQL.
• More highly qualified candidates will possess a demonstrable ability to leverage Excel macros, Access forms, SQL queries, and VBA scripting to process data and automate tasks.
• Experience with tools such as MS DOS batch files, MS Powershell, VBScript, MS SQL Server, AutoDesk AutoCAD, ESRI ArcGIS, or MS Visual Studio is preferred but not required.
• Experience with Microsoft PowerBI or other Business Intelligence tools is preferred.
• GIS experience is preferred.
• Ability to work independently with minimum oversight while maintaining schedule discipline.
• Strong work ethic and problem-solving skills.
• Effective time management skills with the ability to meet tight schedules.
• A valid driver's license in good standing.
• The candidate must be a U.S. Citizen due to project requirements.

Nice to Have

• Experience with tools such as MS DOS batch files, MS Powershell, VBScript, MS SQL Server, AutoDesk AutoCAD, ESRI ArcGIS, or MS Visual Studio.

Qualifications

• Completed at least 2 years of college coursework prior to internship.
• Experience with MS Office applications, especially Access and SQL.
• Proficiency in leveraging Excel macros, Access forms, SQL queries, and VBA scripting is a plus.

Benefits & Perks

• Comprehensive and market-competitive benefits.
• Merit-based financial rewards.
• Flexibility and company-wide commitment to work/life balance.
• Collaborative team atmosphere that values contributions of all employees.
• Learning and development opportunities for ongoing professional growth.