Business Systems Analyst Intern

Description

The IT & Business Systems Intern will gain practical, hands-on experience supporting Pacific Ag's core technology platforms while contributing to business intelligence, data analysis, geospatial mapping, and day-to-day IT operations. The intern will primarily support Power BI reporting and SQL, ESRI ArcGIS geospatial tools, and IT help desk functions. Working alongside the IT team, the intern will contribute to real-world projects while developing technical and collaborative skills in reporting, GIS, version control platforms such as Git Hub, and AI-assisted productivity tools, including Copilot, ChatGPT, and Claude.

• 1) Assist with the development, maintenance, and testing of Power BI reports and dashboards under the guidance of senior analysts.
• 2) Assist with writing, executing, and troubleshooting basic SQL queries to retrieve, clean, and validate data from SQL Server.
• 3) Support data transformation processes in Power Query and assist with basic data modeling tasks.
• 4) Assist in documenting report logic, data sources, and refresh schedules.
• 5) Explore and apply AI-assisted tools, such as Copilot, ChatGPT, and Claude, under supervision to support data cleaning, draft SQL and DAX queries, and streamline documentation.

• 1) Assist with maintaining and updating geospatial maps, dashboards, and field data collection tools.
• 2) Support data entry and quality assurance checks for spatial datasets and feature layers.
• 3) Assist in preparing maps and visualizations to support Farm Operations stakeholders.
• 4) Develop foundational knowledge of ArcGIS Online and ArcGIS Pro while assisting end users with routine questions.

• 1) Provide day-to-day help desk support, including basic troubleshooting and service ticket management.
• 2) Assist with mobile device management (MDM) tasks, including MaaS
  360 administration, cellphone ordering coordination, and the creation of email accounts and user profiles.
• 3) Support Active Directory user management tasks, including account creation, updates, and password resets, under supervision.
• 4) Assist with maintaining IT documentation, inventory records, and knowledge-base articles to ensure information remains accurate and up to date.
• 5) Utilize Git Hub or similar version control tools to organize and track scripts, queries, and configuration files while gaining hands-on experience with version control fundamentals, including repositories, commits, and pull requests.

• 1) Participate in IT team meetings, project check-ins, and training sessions to gain insight into IT operations, project coordination, and professional development.
• 2) Document processes, procedures, and key learnings to support the development and maintenance of internal knowledge-base content.
• 3) Explore and recommend ways AI tools and modern productivity software can streamline reporting, GIS, and IT support workflows.
• 4) Complete assigned learning projects and present a summary of key accomplishments, and skills gained at the conclusion of the internship.

• A) Basic understanding of or strong interest in databases and reporting concepts, including SQL, Excel, and Power BI. Relevant coursework or self-directed projects are welcome.
• B) Familiarity with GIS concepts and tools, such as ArcGIS, or a strong willingness to learn.
• C) Comfortable using AI tools, such as ChatGPT, Copilot, or Claude, to support research, writing, analysis, and technical tasks.
• D) Working knowledge of Git/Git Hub fundamentals, including cloning repositories, committing changes, and creating pull requests, gained through coursework, personal projects, or professional experience.
• E) Strong attention to detail, with a proactive approach to asking questions and seeking clarification when needed.
• F) Strong written and verbal communication skills, with the ability to clearly document work and communicate information effectively.
• G) Ability to effectively manage time and prioritize tasks with guidance and direction from a supervisor.
• H) Ability to maintain confidentiality of company information.

• A) Currently pursuing or recently completed a degree or certificate in Information Systems, Computer Science, GIS, Data Analytics, Business, or a related field.

• A) No prior experience required. Coursework, personal projects,…