Systems Development Intern
What You’ll Do Your primary responsibility will be to support the design, development, integration, and continuous improvement of internal business systems connecting Jira, QuickBooks, Power BI, and other operational data sources. The role is intended for someone who enjoys building practical system solutions, integrating applications, automating workflows, and improving how information moves across the organization. Key responsibilities include:
• Assist in designing and developing integrated business reporting solutions across Jira, QuickBooks, Power BI, and other internal systems.
• Build and maintain Power BI dashboards, data models, and automated reporting workflows for project, operational, and financial reporting.
• Support the development of data pipelines, system interfaces, and automated data flows between business applications.
• Use SQL, Python, APIs, Power Query, or similar tools to extract, transform, validate, and automate data processing where appropriate.
• Configure and improve Jira workflows, custom fields, reporting structures, and process automation to support project execution and operational control.
• Assist in developing lightweight internal tools, scripts, or automation solutions to reduce manual work and improve process efficiency.
• Assist in developing automated reports, recurring management dashboards, and system-generated alerts.
• Support the development and documentation of system architecture, data models, business logic, reporting processes, and workflow designs.
• Explore the use of AI, scripting, and automation tools to streamline repetitive business processes, data processing, and reporting activities.
• Support ad hoc data analysis and other business improvement projects as needed. ________________________________________
Who You Are
• Currently pursuing a Bachelor's or Master's degree in Computer Science, Information Systems, Software Engineering, Data Science, Data Analytics, Business Analytics, or a related field.
• Students from Oakland University or other universities in the Detroit metropolitan area are welcome to apply.
• Native or professional proficiency in Mandarin Chinese, with the ability to communicate effectively in English, is required to support cross-regional collaboration.
• Strong interest in system development, business application integration, workflow automation, data engineering, and internal tool development.
• Experience with Excel is required; hands-on experience with Power BI, SQL, Python, Power Query, APIs, scripting, or similar development and analytics tools is highly preferred.
• Ability to understand business requirements and translate them into data structures, workflows, dashboards, automation logic, or system solutions.
• Familiarity with databases, APIs, ETL concepts, automation platforms, or business systems configuration is a strong plus.
• Familiarity with AI tools and models such as ChatGPT, Microsoft Copilot, or similar platforms, with an interest in using AI to improve productivity and automate repetitive tasks.
• Strong attention to detail, problem-solving ability, and organizational skills.
• A proactive self-starter who is comfortable learning new systems and working in a fast-paced environment. • Available to work 20–30 hours per week during the academic semester. ________________________________________
What You’ll Gain
• Hands-on experience working with Power BI, Jira, QuickBooks, SQL/Python-based automation, and real-world business data.
• Practical experience in business systems development, systems integration, workflow automation, data pipelines, and reporting architecture.
• Exposure to project management, financial analysis, cost control, and business operations.
• Experience building dashboards, internal tools, automated workflows, and analytical solutions used by management.
• Practical experience applying AI and automation tools in a business environment.
• Exposure to the operations of a growing North American industrial technology business. ________________________________________