Information Technology Summer Intern - Data… at Oakland… · Waterford

Summary: Oakland County is one of Michigan’s leading public service organizations, committed to strengthening communities and improving the quality of life for nearly 1.3 million residents. The IT Intern will support the County’s data and analytics initiatives, assisting in data collection, analysis, and exploration of AI tools to improve public services across County departments. Responsibilities: - Work with IT staff and department stakeholders to understand business data needs and reporting requirements - Participate in early AI and advanced analytics exploration, including evaluating potential use cases for automation, predictive insights, and improved service delivery - Support data collection, data integration, and data preparation from various county applications and systems - Conduct basic data analysis and exploratory analysis to identify trends, patterns, and opportunities for improved reporting - Help develop dashboards, visualizations, and reports that support county leadership and departmental operations Required Qualifications: - Current enrollment in an accredited college or university with status as a junior/senior student - Current enrollment in an accredited college or university in a graduate degree program - Pursuing a graduate or undergraduate degree in Information Technology, Computer Science, Data Science, or closely related field - Possess and maintain a valid motor vehicle operator's or chauffeur's license Preferred Qualifications: - Excellent communication, both written and verbal skills with the ability to communicate technical findings clearly to non-technical staff - Demonstrate critical thinking skills and a proactive mindset - Strong analytical and problem-solving skills - Proficiency in MS Office products, Python and/or SQL, SSIS reporting(or similar reporting tool) - Familiarity with data visualization tools such as Power BI and cloud data platforms such as MS Azure and AWS Required Skills: Python, SQL, Data analysis Important Skills: Data visualization, MS Office proficiency Nice-to-Have Skills: cloud platforms Benefits: Competitive pay, Comprehensive benefits