Job Closed

This listing is no longer active.

Resource Innovations logo
Resource Innovations

Resource Innovations offers environmental consulting services with a focus on energy and water efficiency. Past jobs at Resource Innovations have offered work-from-home flexibility

Data Analytics Coordinator

Location

Massachusetts

Posted

105 days ago

Salary

$50K - $60K / year

Seniority

Mid Level

Bachelor Degree2 yrs expEnglishMagentoPythonSQL

Job Description

Data Analytics Coordinator

Resource Innovations

• 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

CVS Health logo

Finance & Analytics Manager, Transportation

CVS Health

Bringing our heart to every moment of your health.

Data Analyst105 days ago
OtherRemoteTeam 10,001+Since 1963H1B No Sponsor

• Manage and enhance financial and metric reporting such as P&L results, route, mileage, cost per mile, miles per route, cube/route, fuel consumption • Monitor the monthly EIA change in fuel price vs the budgeted and forecasted fuel rates • Calculate the cost impact on re-alignments and overrides and change in shipment plans • Maintain complex databases, data queries linked to metric and financial reporting • Support the Transportation team with various analysis for RFP’s and union negotiations • Analyze transportation metrics to uncover, communicate, and solve for opportunities • Provide weekly projections, monthly and quarterly P&L reporting for leadership team and DCs to review • Develop the new year financial/metric budget models • Work with the dedicated and private fleet teams in developing a bottoms up budget and incorporating the necessary initiatives and layers • Identify and model budget shifts and variance explanations vs previous forecast

Idaho + 2 moreAll locations: Idaho | Rhode Island | Texas
$66.3K - $145.9K / year
Job Closed
HIKINEX logo

E-discovery Data Analyst

HIKINEX

Design Your Dream Team

Data Analyst105 days ago
Full TimeRemoteTeam 201-500H1B No Sponsor

• Prepare and process electronically stored information (ESI) for legal review platforms • Handle sensitive client data for litigation, analytics, and hosted review • Support and maintain multiple databases and projects while following strict security and confidentiality standards • Migrate data to secure, online platforms used by legal teams • Troubleshoot processing and database issues until a full resolution is achieved • Double-check data accuracy and ensure all client and project requirements are met • Communicate regularly with internal teams to keep projects moving and on track • Meet deadlines and ensure data deliverables are accurate and high quality • Stay up to date on eDiscovery standards, tools, and technologies

Philippines
Job Closed
ContractRemoteTeam 201-500H1B No Sponsor

• Manage and analyze sales, expense, and performance data to produce clear, data-driven insights • Build and maintain dashboards and financial models that track overall company health and sales performance • Oversee bookkeeping and ensure financial records are accurate, organized, and current • Lead payroll review, billing, and payment processes with a focus on accuracy and timeliness • Review and process agent invoices and commission calculations • Reconcile accounts and track inventory across systems to ensure data consistency • Partner with leadership on revenue forecasting, growth modeling, and KPI tracking • Identify opportunities to improve processes and automate finance and reporting workflows

Colombia
Jump - Advisor AI logo

Data Analyst

Jump - Advisor AI

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

Data Analyst105 days ago
OtherRemoteTeam 51-200Since 2023H1B No Sponsor

• Partner cross-functionally to define KPIs, answer strategic questions, and support decision-making. • Build reporting and dashboards that drive action — not just monitoring. • Present insights clearly to both technical and non-technical stakeholders. • Perform data analysis to uncover trends, risks, and growth opportunities. • Define and maintain core business metrics to ensure alignment across teams. • Support and improve dimensional data models (fact and dimension tables) in the warehouse. • Build and maintain reliable data transformations to ensure accuracy and consistency. • Help improve data quality, documentation, and reporting standards. • Contribute to forecasting, experimentation analysis, and predictive or inference modeling initiatives.

United States
$90K - $120K / year