Resource Innovations

A women-led clean energy solutions company, ranked #10 in the energy category on the 2022 Inc. 5000 list.

Data Analytics Coordinator

Data AnalystData AnalystFull TimeRemoteTeam 201-500H1B SponsorCompany SiteLinkedIn

Location

Massachusetts

Posted

16 days ago

Salary

$50K - $60K / year

Bachelor Degree2 yrs expEnglishMagentoPythonSQL

Job Description

• Extract order, customer, and transaction data from Magento and Commerce Manager using a mix of exports, integrations, or API pulls • Validate exports for missing fields, corrupt rows, duplicate orders, or partial transactions • Validate tax and fee fields against finance rules (e.g., combined tax vs. itemized tax) • Normalize fields (SKUs, order IDs, timestamps, status codes, currency formats) to conform with client business rules and requirements for incentive reimbursement • Map data exports to each program’s designated system of record’s required schema for incentive processing • Run reconciliation checks between Magento and the payment processors (order counts, revenue totals, fees) • Coordinate with finance and account teams on cutoffs and exceptions • Adjust mapping logic when Magento schema or payment partner requirements change • Other duties as assigned.

Job Requirements

  • Ability to work with large data sets and automate data transformation to meet client requirements
  • At least 2-3 years demonstrated expertise in data management, analytics, and transformation
  • Experience transforming transaction data (split tax fields, reformat amounts, consolidate line items, apply rounding rules, etc.) as needed to reconcile data with the system of record’s business rules to enable fast invoice processing
  • Expertise in generating settlement-ready files in the required formats (CSV, XML, JSON, EDI, XLSX) and lead uploads to client system of record (Microsoft Dynamics, procurement portals, e.g., ARIBA, etc.)
  • Bachelor's Degree in business administration, data analytics/statistics, data management, or similar field highly preferred
  • Fluency in SQL databases, Microsoft Excel, Power Bi, and Python
  • Experience in E-Commerce or retail and familiarity with Authorize.net or Magento, a plus
  • Interest in sustainability and passionate about making a meaningful impact on the environment.

Benefits

  • Three weeks of paid vacation annually
  • Paid holidays
  • 401(k) retirement plan with employer match
  • Medical, dental and vision coverage
  • Parental leave
  • Employee assistance program
  • Commuter benefits
  • Additional supplemental offerings

Related Categories

Related Job Pages

More Data Analyst Jobs

Finance & Analytics Manager, Transportation

CVS Health

Bringing our heart to every moment of your health.

Data Analyst16 days ago
Full TimeRemoteTeam 10,001+Since 1963H1B No Sponsor

Finance & Analytics Manager supporting the Transportation team at CVS Health

Idaho + 2 moreAll locations: Idaho, Rhode Island, Texas
$66.3K - $145.9K / year

Data Analyst

Jump - Advisor AI

Jump uses AI to help financial managers automatically take notes, stay compliant, update their CRM, and serve clients.

Data Analyst16 days ago
Full TimeRemoteTeam 51-200Since 2023

Data Analyst driving better decisions through analysis and collaboration at Jump.

CloudSQL
United States
$90K - $120K / year

Senior Marketing, Data Analyst

Stone Hendricks Group

SHG is in the business of making connections, and honed our process through years of providing direct-hire services.

Data Analyst16 days ago
Full TimeRemoteTeam 11-50Since 2021

Senior Marketing Data Analyst aggregating and analyzing marketing data

PythonSQLTableau
California
$175K - $240K / year

Data Analyst

Themark

É simples assim.

Data Analyst16 days ago
Full TimeRemoteTeam 1-10Since 2023

Remote Data Analyst providing insights for clients in various real estate industries

California