The Intern will support all emergency management functions of ACDC by assisting their supervisor and/or Peer Mentor in organizational operations related to the department functions.
Interns will participate in cross-training opportunities within ACDC’s various Divisions.
Participate in professional development activities including training, meetings with leadership, policy research, and related functions.
Support managers with administrative tasks and data entry.
Work on projects that have a direct impact on clients if available/needed.
Interns will be given the opportunity for shadowing experiences and exposure to various divisions and projects as available.
Assist in building and maintaining dashboards in Power BI;
Extract, clean, and transform data from multiple sources using SQL and Excel;
Write and optimize SQL queries, including joins across multiple datasets;
Support data validation and quality assurance processes;
Analyze data trends and provide insights to support recovery operations;
Collaborate with team members to define reporting requirements and KPIs;
Document data sources, processes, and dashboard logic;
Assist in automating recurring reports and workflows;
Participate in team meetings and present findings as needed
Perform other duties as assigned.

Requirements

Currently pursuing a Bachelor degree in Data Analytics, Information Systems, Computer Science, Business Analytics or a specialized function in a closely related field, or recent graduate in the past 12 months.
1 month - 1 year (beginner-level) knowledge/experience in data analysis concepts principles.
1 month - 1 year (beginner-level) customer service experience.
Proficient in Microsoft Office 365, particularly Excel.
Experience using Power BI or Tableau to create dashboards
Experience working with real-world datasets (internships, academic projects, or personal projects)
Knowledge of data cleaning and transformation techniques
Basic experience with SQL (coursework or projects acceptable).

Benefits

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data analysisdata cleaningdata transformationSQLExcelPower BIdashboard creationdata validationquality assurancereporting

Soft Skills

collaborationcommunicationorganizational skillsproblem-solvingpresentation skillscustomer service