Internship Microsoft Excel Jobs in San Ramon, CA

Penta is a leading corporate affairs advisory firm that helps organizations predict what matters and shape outcomes. By combining proprietary intelligence, stakeholder insights, and strategic counsel, we help CEOs and leadership teams navigate the increasingly complex intersection of business, policy, culture, and reputation. Our clients turn to us when the stakes are high, the signals are difficult to interpret, and the consequences of getting it wrong are significant. We are building a new model for corporate affairs advisory and are seeking leaders who want to help define the future of the industry.
Penta's global team brings decades of experience in business, government, communications, research, data science, and media. Our clients include many of the world's most influential organizations across technology, financial services, energy, healthcare, and other sectors, including over 25% of the Fortune 100. Penta has offices in New York, Washington DC, San Francisco, London, Brussels, Dublin, and Singapore.
Role Summary:
As a Monitoring & Insights Intern, you will support Penta's Intelligence division across both our proprietary insights and real-time monitoring services, helping global clients understand stakeholder sentiment, media coverage, and emerging risks. You will work with large volumes of news, media, and proprietary data to produce both real-time outputs and longer-form analysis, contributing to alerts, briefings, and client and industry facing reports on reputation, topic trends, and stakeholder views. Your work will involve tracking developments as they unfold, identifying key drivers behind trends, creating visualizations, and translating data into clear, actionable insights.
Working alongside our analysts, you will use industry-leading media aggregation and analytics tools to monitor coverage in real time while building structured analyses. You will support the delivery of alerts, briefings, and reports, helping clients respond to media developments as they happen while also contributing to deeper insights that inform planning, strategy, and decision-making. This role is ideal for an ambitious and analytically minded early-career professional interested in media analysis, business intelligence, and stakeholder insights, and offers training, mentorship, and professional development within a fast-paced and dynamic team.
This role is expected to:

• Monitor news and events across outlets and platforms, including print, digital, television, radio, and social media
• Collaborate with a team of analysts to alert the news to clients in a timely and effective manner
• Collect and prepare data to support media analysis and scheduled report deliveries
• Assist with long-term research projects
• Create pivot tables from Excel report data
• Update report graphics and charts for review
• Write descriptive text to tell the stories behind data
• Validate and interpret automated scoring from Penta's proprietary platform on reputation risk, and stakeholder views

The ideal candidate will have:

• A bachelor's degree in any discipline, where a focus on communications, journalism, economics, history, or another social science is preferred
• Experience writing analytical reports & creating engaging presentations using Microsoft office, or Google Suite products
• A solid understanding of leveraging Excel for exploratory data analysis & visualization purposes
• A strong interest in media, the 24/7 news cycle, and the intersection of culture, business, and politics
• Excellent communication, organizational, and writing skills
• Intellectual curiosity and a desire to understand the deeper meaning behind content or data
• Meticulous attention to detail and a strong ownership mentality
• Coachability and possess a learning & growth oriented mindset
• The ability to prioritize multiple, competing priorities
• Experience working in teams with a collaborative mindset

Compensation:
This is a non-exempt position eligible for overtime. The hourly pay for this internship will be $20 per hour. Any pre-approved hours worked over 40 hours per week will be paid at time and a half.
Benefits:

• Dynamic and supportive environment for learning and growth
• Access to ongoing training to help develop a strong understanding of the technology and methods used to monitor the news
• Mentoring opportunities and support in the development of long-term career goals

Location, Work Hours, and Remote Schedule:
For this position, we are only considering applicants located on the west coast of the United States who are able to work remotely 35-40 hours per week during a 11 am - 7 pm PT shift. Occasional afternoon shifts (2 pm - 5 pm PT) on both Saturday and Sunday will be required on a rotational basis every six weeks throughout the internship. The internship's duration will be 3 months with the possibility of extension, and have anticipated start date of mid-May through early June 2026.
Penta Group, LLC values diversity and inclusion, is committed to equal employment opportunity, and to compliance with federal anti-discrimination laws. We also comply with District of Columbia law, which prohibits discrimination and harassment against employees, applicants for employment and interns based on race, color, religion, sex (including pregnancy, childbirth or related medical conditions, reproductive health decisions and breastfeeding), national origin, disability, age (18 and over), personal appearance, sexual orientation, gender identity or expression, marital status, family responsibilities, matriculation (e.g., being enrolled in a college or university or in a business, nursing, professional, secretarial, technical or vocational school), political affiliation, genetic information (including family medical history), lawful use of tobacco products, unemployment status and status as a victim or the family member of a victim of domestic violence, a sexual offense or stalking.
Penta Group, LLC is committed to providing reasonable accommodations to qualified individuals with disabilities throughout the application and hiring process. If you require an accommodation to complete your application, participate in an interview, or otherwise engage in the recruitment process, please contact us at [email protected]. We will work with you to ensure appropriate arrangements are made.
We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.