Junior Data Analyst (Python) for an E-commerce company (US-based/Remote)

Paired; United States; Remote; USD 55,000 - 90,000; Full time

Benefits offered by this job

Remote Working for a US Company

Exposure to new technology & trend

Competitive Salary

Job summary

Paired, a global staffing and recruiting agency, is seeking a Junior Data Scientist for a role focused on cleaning, reconciling, and analyzing Amazon-related data. You will work with Python, pandas, and Excel/CSV/Parquet datasets, uncover insights, validate data with tests, and generate client-facing reports.

Remote work offered for a US company; strong organizational and learning mindset required. You'll join a team helping online sellers optimize profitability and recovery, with opportunities

Job description

Paired is a global staffing and recruiting agency that pairs remote work with top-tier talent. We help individuals from around the world connect with great companies that are looking for their specific skill set. Our mission is to provide great jobs to talented people, no matter where they are located.

Our client isan e-commerce consultancy firm specializing in data analysis to enhance seller efficiency, helping online sellers boost profitability, streamline operations, recover lost revenue, and maximize advertising performance.

About the Role

We are looking for aJunior Data Scientistwho enjoys figuring things out. You will help the team investigate problems in client accounts, dig into Amazon data, and surface insights that help drive financial recovery. This is an ideal role for someone early in their career who is organized, curious, and comfortable working in spreadsheets. You don’t need to know everything up front, but you should be eager to learn and able to work independently once trained.

Responsibilities

• Clean and normalize Excel, CSV, and Parquet datasets using Python and pandas.
• Reconcile Amazon claims against invoices, purchase orders, and payment records.
• Match inconsistent IDs while avoiding unsupported or ambiguous matches.
• Classify discrepancies using defined recovery and reconciliation taxonomies.
• Build pandas logic for underpayment checks, multi-currency analysis, and reversal matching.
• Investigate unexpected results and trace discrepancies back to their source data.
• Write pytest/conformance tests to validate critical data-handling logic.
• Determine when incomplete data is insufficient to support a recovery claim.
• Process and analyze multi-million-row datasets across approximately 170 vendor accounts.
• Generate accurate Excel, CSV, and PDF recovery reports for non-technical clients.
• Use AI tools as part of the daily workflow while validating outputs and results.
• Contribute to improving the reliability and repeatability of reconciliation processes.

Requirements

• Solid Python fundamentals, including files, lists, dictionaries, and data structures.
• Basic experience with pandas, including filtering, merging, and aggregation.
• Strong attention to detail and a methodical approach to data validation.
• Ability to investigate data discrepancies and explain how conclusions were reached.
• Clear written English for client-facing findings and reports.
• Comfortable using AI tools to support coding, analysis, and problem-solving.
• Willingness to work with large and messy datasets.
• Ability to make careful decisions when data is incomplete or ambiguous.
• Nice to Have Basic SQL knowledge.
• Experience with Git/GitHub.
• Experience writing tests in pytest or another testing framework.
• Exposure to Amazon Vendor Central, chargebacks, deductions, or retail vendor operations.
• Experience working with Excel, CSV, or Parquet data at scale.
• Academic or personal projects involving Python/data analysis.

Benefits

• Remote Working for a US Company
• Exposure to new technology & trend
• Competitive Salary