Data Analytics Coordinator

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.

Duties and 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.

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

Preferred skills, education and experience

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

About Resource Innovations

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.

Resource Innovations is an Equal Opportunity Employer, committed to ensuring equal employment opportunities for all job applicants and employees without regard to race, color, religion, national origin, gender, age, disability, marital status, genetics, protected veteran status, sexual orientation, or any other protected status. In addition to federal law requirements, Resource Innovations complies with applicable state and local laws governing non-discrimination in employment in every location in which the company does work.

Compensation & Benefits

Resource Innovations offers competitive salaries based on a candidate's skills, experience and qualifications for the position.  The compensation range for the base salary for this position is $50-$60k.  In addition to base pay, employees may be eligible for a discretionary annual bonus.  The stated salary represents the expected compensation for this position. Final compensation will be determined based on factors such as the candidate's experience, education and location. 

At Resource Innovations, we believe supporting our people is essential to delivering impact. 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.

Employment with Resource Innovations is contingent upon the successful completion of a comprehensive background check and reference check. If applicable to the position, a pre-employment drug screen may also be required.

The above job description and job requirements are not intended to be all inclusive. Resource Innovations retains the right to make changes or adjustments to job descriptions and/or job requirements at any time without notice.