Jr. Data Analyst - Digital Commerce

Proteam Solutions; Columbus (OH); Hybrid; USD 45,000 - 65,000; Full time

Benefits offered by this job

Company computer provided

Hybrid work schedule

Job summary

Proteam Solutions is seeking a Jr. Data Analyst - Digital Commerce to ensure the accuracy and completeness of product data and imagery across digital channels.

You will act as a product data expert, collaborating with multiple teams to extract insights and enable effective digital activation for partner needs. The role focuses on managing digital product data, troubleshooting with partners, and maintaining data integrity through cross-functional coordination.

Qualifications

• 2+ years of corporate experience.
• 2+ years of Excel experience required.
• Proficiency with VLOOKUP.
• Experience with SUM and SUMIF.
• Experience with COUNT and COUNTIF.
• Familiarity with Find and Replace.
• Experience creating and using Pivot Tables.
• Knowledge of MATCH.
• Knowledge of CONCAT and Conditional Formatting.
• Well organized and detail oriented.
• Strong time management and prioritization in a dynamic environment.
• Excellent oral and written communication skills.
• Able to take initiative and collaborate effectively in a cross-functional team.
• Experience learning new technical applications.
• Proficient in Microsoft Office with a strong emphasis on Excel.
• Experience with SharePoint or Adobe Experience Manager strongly preferred.

Responsibilities

• Manage the complete catalog of digital product data and imagery, ensuring precision and alignment with partner specifications.
• Offer guidance, troubleshoot, and communicate clearly with partners and internal stakeholders.
• Collaborate with cross-functional teams to validate information and maintain smooth workflows.
• Proactively identify, investigate, and resolve issues through testing and problem-solving.
• Uphold high data integrity by implementing and refining processes for accuracy and scalability.
• Extract, analyze, and organize data from multiple sources using advanced Excel capabilities.

Skills

Strong communication

Time management

Attention to detail

Tools

Excel

VLOOKUP

Pivot Tables

SUM / SUMIF

COUNT / COUNTIF

Find & Replace

CONCAT

Conditional Formatting

SharePoint

Adobe Experience Manager

Microsoft Office

Job description

The Jr. Data Analyst - Digital Commerce supports the accuracy and completeness of product data and imagery across digital channels. Serving as a product data expert, the role collaborates with multiple teams to extract insights and enable effective digital activation for partner needs.

Responsibilities

• Manage the complete catalog of digital product data and imagery, ensuring precision and alignment with partner specifications.
• Offer guidance, troubleshoot, and communicate clearly with partners and internal stakeholders.
• Collaborate with cross-functional teams to validate information and maintain smooth workflows.
• Proactively identify, investigate, and resolve issues through testing and problem-solving.
• Uphold high data integrity by implementing and refining processes for accuracy and scalability.
• Extract, analyze, and organize data from multiple sources using advanced Excel capabilities.

Requirements

• 2+ years of corporate experience
• 2+ years of Excel experience required
• Proficiency with VLOOKUP
• Experience with SUM and SUMIF
• Experience with COUNT and COUNTIF
• Familiarity with Find and Replace
• Experience creating and using Pivot Tables
• Knowledge of MATCH
• Knowledge of CONCATProficiency with Conditional Formatting
• Well organized and detail oriented
• Strong time management and prioritization in a dynamic environment
• Excellent oral and written communication skills
• Able to take initiative and collaborate effectively in a cross-functional team
• Experience learning new technical applications
• Proficient in Microsoft Office with a strong emphasis on Excel
• Experience with SharePoint or Adobe Experience Manager strongly preferred

Technologies

• Excel
• SharePoint
• Adobe Experience Manager
• Microsoft Office

Core Competencies

• Lead with curiosity and humility
• Build high performing teams for today and tomorrow
• Influence and inspire with vision and purpose
• Observe, engage and connect
• Strive to achieve operational excellence
• Deliver business results

Additional Information

• Top skills required: ability to hit the ground running with minimal training, strong Excel skills, and quick learning ability
• Interview process: 1-hour virtual round with initial Excel skill testing, possible second round
• Typical day: updating data reports, handling troubleshooting requests, and collaborating with cross-functional teams
• Contract duration: 6 months with a likely extension
• Work environment: Hybrid (Tue – Thur) 9 am to 5 pm office hours
• Company computer provided