Data Analytics Coordinator

Resource Innovations • Boston, MA

3h • $50 - $60 • Remote

About The Position

Resource Innovations is seeking a Data Analytics Coordinator to join our growing team, working remotely or from one of our local offices. We are seeking a highly skilled and motivated Data Analytics Coordinator with a strong background in data analytics, aggregation, and transformation to join our dynamic team. As a Data Analytics Coordinator, you will engage with our customer engagement development team leads to extract data from our Commerce Manager system, transform it to meet client invoicing and reporting requirements, and facilitate system uploads required for payment.
Resource Innovations (RI) is a women-led energy transformation firm focused on impact. Building on our expertise in energy efficiency, we're constantly expanding our portfolio of clean energy solutions to guide utilities through increasingly complex, connected challenges. Load flexibility. Electrification. Carbon reduction. With every step, we're leading the charge to power change.

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.)

Nice To Haves

• 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.

Responsibilities

• 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.

Benefits

• Resource Innovations offers competitive salaries based on a candidate's skills, experience and qualifications for the position.
• In addition to base pay, employees may be eligible for a discretionary annual bonus.
• We offer a comprehensive benefits package designed to promote health, financial security, and work-life balance.
• This includes three weeks of paid vacation annually, paid holidays, a 401(k) retirement plan with employer match, medical, dental and vision coverage, parental leave, an employee assistance program, commuter benefits, and additional supplemental offerings.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level