IT Data Operations Intern

Jobtailor; New York (NY); On-site; USD 70,000 - 110,000; Full time

Job summary

Jobtailor in New York, NY seeks a data analyst to clean and standardize Salesforce data using Excel and AI-assisted tools. You will translate data readouts into executable remediation plans and collaborate with stakeholders to prioritize work based on business impact.

Expect a data-cleanup focus with rigorous audit trails and progress dashboards. The role emphasizes data curiosity, strong organizational skills, and the ability to turn messy data into actionable insights while maintaining data

Qualifications

• Strong data curiosity and problem solving for complex data issues.
• Proficiency with Excel functions and data tools for cleanup.
• Ability to structure messy data into logical categories and maintain quality.
• Exposure to Salesforce architecture and AI-assisted data tools.

Responsibilities

• Review data readouts to identify corrupted, duplicate, or incomplete Salesforce data.
• Interview stakeholders to understand data origins and context.
• Translate readouts into remediation project plans.
• Develop prioritization matrix for immediate cleanup vs. long-term monitoring.
• Use Excel and Salesforce tools to clean and validate data sets.
• Experiment with approved AI tools for data manipulation and audit trails.
• Maintain an audit log and status dashboard for PMO leadership.

Skills

Data Analysis

Excel Functions

VLOOKUP

XLOOKUP

Pivot Tables

Data Standardization

Data Validation

Data Manipulation

Audit Trails

Quality Tracking

Tools

Salesforce

Excel

AI Tools

Job description

• 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.

Requirements

• 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.

Core Competencies

Demonstrates strong data analysis capabilities with proficiency in Excel and Salesforce tools, focusing on data cleanup and standardization. Possesses a keen ability to translate complex data issues into actionable plans while maintaining organization and attention to detail.

Highest-signal resume keywords

• Data Analysis
• Excel Proficiency
• Salesforce Data Tools
• Data Cleanup
• Organizational Skills

ATS Optimization Keywords

Hard Skills

• Data Analysis
• Excel Functions
• VLOOKUP
• XLOOKUP
• Pivot Tables
• Data Standardization
• Data Validation
• Data Manipulation
• Audit Trails
• Quality Tracking

Soft Skills

• Data Curiosity
• Problem Solving
• Detail Orientation

Industry Keywords

• Data Cleanup
• Data Management
• Data Quality
• Enterprise Architecture

Tools & Technologies

• Salesforce
• Excel
• AI Tools