Data Analytics Coordinator, Resource Innovations

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

Desirable

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