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.