IT Data Operations Intern (Hybrid - NY office)

FIRST; New York (NY); Hybrid; USD 28,000 - 34,000; Part time

Job summary

FIRST is seeking an IT Data Operations Intern in New York for a hybrid role. You will assist the PMO with a Salesforce data cleanup initiative, categorize data, and help build a reliable data foundation to improve project metrics.

The role emphasizes data analysis, Excel-based data manipulation, and collaboration with business stakeholders. The program runs 20–25 hours weekly through the fall.

Qualifications

• Strong data problem solving and analytical mindset.
• Proficient in Excel (lookup, pivot tables, formulas).
• Familiarity with enterprise Salesforce architecture a plus.

Responsibilities

• Support PMO in Salesforce data cleanup and remediation.
• Categorize, prioritize, and cleanse data sets to improve pipelines.
• Maintain audit logs and a status dashboard for leadership.
• Collaborate with stakeholders to translate analysis into actionable plans.

Skills

Data curiosity

Excel proficiency

Data organization

SFDC familiarity

Education

Pursuing college degree

Tools

Excel

Salesforce

Job description

with a Story

FIRST is a leading global brand experience agency providing Content, Creative, Digital Technology, Management & Delivery, and Data & Insights services. For 30 years, we have utilized three flexible delivery models: Embedded teams, Corporate Campus operations, and a Full-Service Agency. Managing over 37,000 events & projects annually across 110 countries, FIRST serves 130+ brands, specializing in Fortune 500 companies within the Financial Services, Technology, Healthcare, Media, and Professional Services sectors. FIRST is part of the broader Encore family of companies. Encore is a global leader in event production and technology. Consistently recognized for excellence, recent honors include 2026 Chief Marketer Agency of the Year, the Ad Net Zero Award for sustainability, and more.

Building a Brand Starts with a Story

FIRST is a leading global brand experience agency providing Content, Creative, Digital Technology, Management & Delivery, and Data & Insights services. For 30 years, we have utilized three flexible delivery models: Embedded teams, Corporate Campus operations, and a Full-Service Agency. Managing over 37,000 events & projects annually across 110 countries, FIRST serves 130+ brands, specializing in Fortune 500 companies within the Financial Services, Technology, Healthcare, Media, and Professional Services sectors. FIRST is part of the broader Encore family of companies. Encore is a global leader in event production and technology. Consistently recognized for excellence, recent honors include 2026 Chief Marketer Agency of the Year, the Ad Net Zero Award for sustainability, and more.
Learn more at www.firstagency.com
Location: New York. This is a hybrid role, must live in the NY tri state area and be able to go into office 2 days a week (Tuesday plus a Wednesday or Thursday,) subject to change at any time but also based on school schedule.
The Program will run from Sept 21 to Dec 11th (20-25 hours per week)

What You’ll Get To Do

The IT Data Operations Intern will directly support the PMO and key business stakeholders in executing a vital Salesforce data cleanup initiative. Following a comprehensive data analysis of our Salesforce environment, this role will focus on systematically categorizing, prioritizing, and cleansing targeted data sets to build a reliable data foundation. This work will directly improve pipeline tracking, project metrics, and operational reporting accuracy while eliminating systemic data gaps. This high-visibility role offers hands‑on experience across the end‑to‑end lifecycle of an enterprise data remediation project.

Your Contributions

• Review initial data analysis readouts to identify specific, manageable categories of corrupted, duplicate, or incomplete Salesforce data.
• Interview business stakeholders and data owners across departments to understand data origins and operational context.
• Assist in translating high-level data analysis readouts into actionable remediation project plans.
• Help develop a prioritization matrix to determine which data buckets require immediate cleanup versus long‑term monitoring based on business impact.
• Utilize Excel and Salesforce data tools to clean, standardize, and validate prioritized data sets.
• Experiment with approved AI tools and advanced Excel techniques for data manipulation, audit trails, and quality tracking.
• Maintain an audit log and status dashboard of cleanup progress to present to PMO leadership.

This job description is not designed to contain a comprehensive listing of activities, duties or responsibilities that are required for this position. The employee may be asked to perform other duties and responsibilities, as necessary.

What We Are Looking For

• Strong data curiosity with a desire to investigate and solve complex data problems.
• Proficiency with Excel functions (e.g., VLOOKUP/XLOOKUP, Pivot Tables, filtering, and text formulas).
• High level of organization and detail orientation, with the ability to structure messy data into logical categories.
• Exposure to or eagerness to learn enterprise Salesforce architecture and AI‑assisted data tools.

Working Conditions

• Requires ability to operate a computer, telecommunications devices and other office equipment for prolonged periods of time throughout the workday.
• Requires the ability to work and cooperate with other employees and clients at all levels and from diverse backgrounds to exchange ideas, information and opinions to facilitate the task at hand.
• Requires clarity of near vision. This factor is important when special and or minute accuracy is demanded and defective near acuity would adversely affect job performance and/or safety of self and others.

United States Residents:

The base pay for this position is $20 per hour for anyone that is an undergraduate and $25 per hour for graduated students.

FIRST is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. FIRST is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment. All employment decisions are based on business needs, job requirements and individual qualifications without regard to race, color, religion or belief, national, social or ethnic origin, sex (including pregnancy), age, physical, mental or sensory disability, sexual orientation, gender identity and/or expression, marital, civil union or domestic partnership status, past or present military service, family medical history or genetic information, family or parental status, or any other status protected by the laws or regulations in the locations where we operate. We stand firm: FIRST will not tolerate discrimination or harassment based on any of these characteristics. If any candidate feels that they are unable to meet the requirements of the role, please get in touch to discuss adjustments or other suitable roles.