Year-Round Data Analytics Intern Job

Year-Round Data Analytics Intern
Location: Charlotte, NC (On-Site Required)
Internship Duration: March 2nd - December 31st

Key Responsibilities
- Collaborate with IT and business stakeholders to gather, understand, and document data requirements.
- Support business analysis activities, including requirements gathering, process mapping, and solution documentation.
- Participate in meetings and workshops to facilitate communication between technical teams and business users.
- Analyze existing data management and ETL processes and identify areas for improvement.
- Work with ETL tools and Microsoft Azure services (Synapse or Microsoft Fabric) to support data integration and transformation workflows.
- Assist in business intelligence development, including creating and maintaining dashboards and reports using Power BI.
- Create semantic models for Power BI and other BI solutions.
- Write SQL queries for data extraction, transformation, and reporting.
- Prepare clear and concise documentation, including business requirements, data dictionaries, workflow diagrams, and BI solution specifications.
- Contribute to the creation of training materials and user guides for ETL processes and BI best practices.

Required Skills and Qualifications
- Currently pursuing a Bachelor's or Master's degree in Information Systems, Business Administration, Technical Communication, or related field.
- Strong analytical and problem-solving skills.
- Excellent written and verbal communication abilities.
- Ability to work collaboratively with cross-functional teams.
- Attention to detail and commitment to producing high-quality work.
- Proficiency in SQL and Python.
- Proficiency in Microsoft Office Suite (Word, Excel, PowerPoint).
- Experience with ETL tools (Microsoft SSIS, Azure Synapse) and business intelligence tools (Power BI) is preferred.
- Familiarity with ETL methodologies and business analysis practices is preferred.
- Microsoft Fabric and Cloud experience is preferred.