Data Operations Intern (Excel & Data Quality)
*About the Role*
All Points Media is seeking a detail-oriented, organized intern to support our Data Department in transforming raw venue location information into accurate, complete, and usable data for our Sales and Operations teams.
The primary work involves consolidating files generated by our location research scripts, organizing records into APM’s standardized Universe List structure, cleaning and enriching information, and documenting exceptions. This role requires strong practical Excel skills, careful file management, and the ability to independently verify the accuracy of completed work.
*Key Responsibilities*
- *Merge and organize data:* Consolidate venue location files, align their fields, and establish records into Universe List formats.
- *Clean and standardize records:* Apply consistent formatting to location names, addresses, phone numbers, ZIP codes, and other fields while preserving existing Location IDs and source information.
- *Separate addresses accurately:* Parse full addresses into the appropriate street address, city, state, and ZIP code fields, and flagging ambiguous entries.
- *Complete and enrich records:* Populate required fields and proactively add useful information beyond the minimum requirements, such as missing contact details, websites, map links, and other relevant venue information using reliable sources.
- *Check data quality:* Compare completed files against source data, reconcile record counts, identify missing or conflicting values, and handle duplicates according to established matching rules.
- *Track exceptions:* Maintain clear records of incomplete information, uncertain matches, address issues, corrections, and items requiring review by the Data Department.
- *Maintain file integrity:* Follow established folder structures, file naming conventions, and version tracking practices so source files, working files, and completed deliverables remain organized and traceable.
- *Support departmental workflows:* Communicate progress, raise questions when information is unclear, and prepare dependable files that Sales and Operations can use with minimal additional cleanup.
- *Audit outputs produced with AI:* Review AI-assisted work against source information and established formatting rules, identify errors, and verify corrections before delivery.
*Required Qualifications*
- Strong working knowledge of Microsoft 365 applications, especially *Microsoft Excel*, with familiarity using shared files through SharePoint or OneDrive and communicating through Teams and Outlook.
- Practical Excel skills, including sorting and filtering, tables, text functions, lookup formulas such as XLOOKUP or VLOOKUP, Text to Columns, conditional formatting, data validation, and duplicate identification.
- Ability to combine multiple spreadsheets, map fields to a template, clean inconsistent values, and validate results.
- Exceptional attention to detail, including recognizing subtle errors such as shifted columns, lost leading zeros, incorrect address components, and mismatched records.
- Strong organizational skills and a disciplined approach to file management, documentation, and following established procedures.
- Ability to research missing information, evaluate whether a source supports a match, and clearly document uncertainty.
- Clear communication, reliability, and willingness to ask questions when a record or instruction requires clarification.
*Independent Skills and AI Verification*
*Candidates must be able to perform the core Excel and data preparation tasks described above without assistance from AI and explain how they completed and checked their work.*
This independent understanding is essential to the role. When AI tools assist with data preparation, the intern must be able to audit the output, recognize errors, and verify the result using their own spreadsheet skills and the underlying source data.
*Preferred Qualifications*
- Experience with Excel Power Query.
- Experience cleaning, merging, or maintaining large spreadsheets through coursework, projects, internships, or employment.
- Familiarity with business location data, address formatting, or structured data templates.
- Interest in data operations, data quality, or business analytics.
*What Success Looks Like*
Success means delivering consistently structured, accurate, and well-documented Universe Lists that help Sales and Operations work efficiently. Required fields are completed where reliable information is available, useful supplemental information is added, unresolved issues are clearly tracked, and files remain organized and traceable throughout the process.
Pay: $20.00 - $25.00 per hour
Benefits:
- Dental insurance
- Health insurance
- Vision insurance
Work Location: In person