Data Analyst and Bookkeeper

We are seeking a skilled and detail-oriented individual to join our team as a Data Analyst and Bookkeeper. The ideal candidate will play a crucial role in managing and reconciling e-commerce spreadsheets, monitoring stock levels, processing bi-weekly affiliate payments, providing data-driven insights to name a few tasks. Additionally, the candidate will be responsible for conducting monthly financial analyses to support strategic decision-making. This position involves the use of advanced spreadsheet formulas, data analysis tools, and automation to streamline processes and ensure accurate financial reporting.

Key Responsibilities include:

Reconcile E-commerce Spreadsheets:
- Regularly reconcile and analyze e-commerce transaction data to ensure accuracy.
- Identify discrepancies and work collaboratively to resolve issues.

Monitor Stock Levels:
- Track and analyze inventory levels to ensure optimal stock management.
- Generate reports on stock movement and provide insights on inventory optimization.

Reconcile Affiliate Payments:
- Regularly reconcile and analyze affiliate performance data to ensure accurate tracking of commissions.
- Collaborate with the finance team to verify and cross-check affiliate payments.
- Identify and resolve discrepancies in affiliate transactions and commission calculations.

Monthly Financial Analysis:
- Conduct comprehensive monthly financial analyses to evaluate business performance.
- Provide insights into key financial metrics and trends.

Data Analysis and Reporting:
- Utilize spreadsheet formulas and data analysis tools to extract meaningful insights.
- Create reports and dashboards to communicate key performance indicators (KPIs) to stakeholders.

Automate Data Analysis Processes:
- Develop and implement automation processes to streamline data analysis tasks.
- Identify opportunities for efficiency improvements in data-related workflows.

Educated Recommendations:
- Analyze data trends and patterns to provide informed recommendations for business improvement.
- Collaborate with cross-functional teams to implement recommended changes.

Qualifications:
- Bachelor's degree in a relevant field (e.g., Finance, Business Analytics, Data Science).
- Proven experience in data analysis and bookkeeping roles.
- Proficiency in spreadsheet creation and automations (e.g., Microsoft Excel, Google Sheets).
- Strong analytical and problem-solving skills.
- Experience in e-commerce data reconciliation, and affiliate marketing analysis are a plus.
- Deep knowledge of automation tools and techniques.