Business Systems Analyst Intern

Pacific Ag Management is seeking an intern to support its core technology platforms and IT operations. The role focuses on Power BI reporting, SQL, GIS mapping, help desk support, data analysis, documentation, and AI-assisted productivity tools while providing hands-on learning and cross-departmental collaboration.

What you'll do:

• Assist with the development, maintenance, and testing of Power BI reports and dashboards under the guidance of senior analysts
• Assist with writing, executing, and troubleshooting basic SQL queries to retrieve, clean, and validate data from SQL Server
• Support data transformation processes in Power Query and assist with basic data modeling tasks
• Assist in documenting report logic, data sources, and refresh schedules
• 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
• Assist with maintaining and updating geospatial maps, dashboards, and field data collection tools
• Support data entry and quality assurance checks for spatial datasets and feature layers
• Assist in preparing maps and visualizations to support Farm Operations stakeholders
• Develop foundational knowledge of ArcGIS Online and ArcGIS Pro while assisting end users with routine questions
• Provide day-to-day help desk support, including basic troubleshooting and service ticket management
• Assist with mobile device management (MDM) tasks, including MaaS360 administration, cellphone ordering coordination, and the creation of email accounts and user profiles
• Support Active Directory user management tasks, including account creation, updates, and password resets, under supervision

What they're looking for:

• 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
• Familiarity with GIS concepts and tools, such as ArcGIS, or a strong willingness to learn
• Comfortable using AI tools, such as ChatGPT, Copilot, or Claude, to support research, writing, analysis, and technical tasks
• Working knowledge of Git/GitHub fundamentals, including cloning repositories, committing changes, and creating pull requests, gained through coursework, personal projects, or professional experience
• Strong attention to detail, with a proactive approach to asking questions and seeking clarification when needed
• Strong written and verbal communication skills, with the ability to clearly document work and communicate information effectively
• Ability to effectively manage time and prioritize tasks with guidance and direction from a supervisor
• Ability to maintain confidentiality of company information
• Currently pursuing or recently completed a degree or certificate in Information Systems, Computer Science, GIS, Data Analytics, Business, or a related field
• No prior experience required
• Coursework, personal projects, hackathons, or class assignments involving SQL, Power BI, GIS, or GitHub are highly valued
• Hands-on experience with at least one AI platform, such as ChatGPT, Microsoft Copilot, Claude, or Gemini, gained through coursework, personal projects, or self-directed learning