BI Developer & Analyst

Job Overview:
We are a growing distributor based in USA, looking for a skilled BI Developer to build our business reporting system. This is a part-time, long-term role (10–20 hours per week) with opportunity to grow into more hours over time. We have two data sources we want to turn into dashboards:

Our ERP system — it has an existing API. We want to pull real-time data for KPIs across sales, customer service, inventory, and financial performance.
System emails — our business software sends several structured emails per day (order confirmations, quotes, transaction notifications) that contain data we want captured and reported on.

You will work directly with the senior managers to design the solution, build it, and improve it over time.

About the Work:
Your first projects will include:

Connecting to our ERP API and pulling the data we need into a reporting layer (Google Sheets, a database, or a tool you recommend)
Building email parsing automations for our daily system notifications
Building dashboards in Google Looker Studio (or your recommended BI tool) for daily, weekly, and monthly review
Defining KPI frameworks for our CSR team, sales, inventory, and financials

We already have a detailed KPI build guide for our CSR team that gives you a clear starting point. From there we will expand together.

Responsibilities:

Integrate with our ERP's existing API to extract data on a scheduled basis
Build email parsing automations for our daily system notifications
Design a clean data structure that's easy to maintain and expand
Build dashboards and reports in Google Looker Studio (or your preferred BI tool)
Define KPIs with clear calculation logic, targets, and documentation
Document everything so our team knows how metrics are calculated
Recommend tools and workflows — we are open to your expertise
Maintain and improve the system over time as our business grows
Meet weekly by video call to review progress and plan next priorities

Requirements:

3+ years of experience building business dashboards (please show examples)
Strong skills in Google Looker Studio, Power BI, or Tableau
Experience consuming REST APIs from business systems — ERP, CRM, e-commerce, or similar

Email parsing automation experience using one or more of: Google Apps Script, Zapier, Make (Integromat), or Power Automate
Strong skills in Google Sheets AND at least one of: SQL, Python, or JavaScript
Experience defining KPIs from scratch, not just building charts someone else specified
Able to write clean English and communicate clearly in video calls
Reliable internet, quiet workspace for calls
Detail-oriented — will notice inconsistent data and ask questions rather than build on broken foundations
Available for at least a 30-minute overlap with US Eastern Time hours

Nice to Have:

Experience with HVAC, distribution, wholesale, or trades industry ERP systems
Experience with cloud data warehouses (BigQuery, Snowflake)
Experience presenting dashboards to non-technical users
Comfortable debugging API authentication and rate-limit issues

How to Apply:
Please send your application with the following. Applications missing any of these will not be considered:

A link to your portfolio or 2–3 screenshots of dashboards you have built (anonymize sensitive data)
A short description of a project where you pulled data from a business system API (ERP, CRM, or similar) into a reporting system — which system, what data, what was the end result?
A short description of a project where you extracted data from emails into a reporting system
Which BI tools, automation tools, and programming languages you are strongest in, with years of experience for each
Your proposed monthly rate for 10–20 hours per week
Answer this question: "Walk me through how you would build a daily sales dashboard that pulls data from an ERP API every morning. What tools would you use, how would you handle authentication, and how would you make sure the data stays accurate?"
Start your message with the word "CURIOUS" so we know you read the full post

Compensation and benefits to be discussed based on experience and proposed rate.
We review every application that follows these instructions. We ignore applications that don't. Looking forward to meeting you.