Business Systems Analyst Intern

Pacific AG Management, Inc•Wasco, CA

3d•Onsite

About The Position

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 GitHub, and AI-assisted productivity tools, including Copilot, ChatGPT, and Claude.

Requirements

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. Experience may include developing effective prompts, using AI to write or troubleshoot code, or exploring advanced capabilities such as custom GPTs, Claude Projects, Claude Code, and other AI tools or integrations.
Familiarity with Git/GitHub, including experience creating repositories, making commits, or collaborating on projects using version control.
Basic proficiency with Microsoft 365 applications, including Excel, Teams, and SharePoint.

Nice To Haves

Interest in agriculture, agribusiness, or agricultural operations in the Central Valley.

Responsibilities

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.
Assist with maintaining IT documentation, inventory records, and knowledge-base articles to ensure information remains accurate and up to date.
Utilize GitHub 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.
Participate in IT team meetings, project check-ins, and training sessions to gain insight into IT operations, project coordination, and professional development.
Document processes, procedures, and key learnings to support the development and maintenance of internal knowledge-base content.
Explore and recommend ways AI tools and modern productivity software can streamline reporting, GIS, and IT support workflows.
Complete assigned learning projects and present a summary of key accomplishments, and skills gained at the conclusion of the internship.