Business Data Analyst

Job Description

Manage the seamless integration of data from third-party platforms into company systems, ensuring accurate and timely reporting of sales and adjustments. Maintain and enhance Power BI dashboards, oversee regular and ad-hoc reporting, and support financial processes, including P&L management, budgeting, and business case analysis. Collaborate cross-functionally with internal and external stakeholders to ensure data integrity and provide insights that drive strategic decision-making for the business. Demonstrate the company’s core values of respect, honesty, integrity, diversity, inclusion, and safety.

Key Responsibilities

• Manage data integration from third-party data into systems, ensuring accurate and timely flow of sales data at various levels (department, commodity, item), as well as sales adjustments (discounts, commissions) and operational metrics (downtime, cancellations, courier wait times)
• Perform quality assurance checks and collaborate with third-party marketplaces to resolve discrepancies and ensure data accuracy
• Manage, maintain and improve reporting, working with leaders across multiple departments and external partners to ensure reporting requirements are being met and integrations are maintained.
• Develop and refine Power BI reports to address evolving business needs, incorporating data from third-party marketplaces and other relevant company sources
• Lead weekly and ad hoc reporting and analysis to support merchandising, marketing, and operational decision-making
• Maintain accurate profile and loss (P&L) statements, working collaboratively with Finance teams to provide insights to inform strategic business decisions
• Support the annual budgeting process by analyzing historical data and current trends to forecast sales and expenses
• Assist with business case development by leveraging data-driven insights to assess projected expenses, benefits, and internal rate of return (IRR)
• Create, manage, and optimize business processes that support reporting, financial analysis, marketing, and operations to ensure successful execution and tracking of company third-party delivery offerings.
• Communicate complex data and insights to both technical and non-technical audiences
• Ability to work cooperatively in high paced and sometimes stressful environment
• Ability to manage conflict in a reasonable, nonconfrontational and cooperative manner
• Ability to act with honesty and integrity regarding customer and business information
• Ability to follow directions and seek assistance when necessary to resolve customer and business issues
• Must be able to perform the essential functions of this position with or without reasonable accommodation

Experience:

• 5 years of experience in data analysis; focus on statistical methodology
• Any experience using statistical data programming language (R, Python), database querying language (SQL, Alteryx) and Power BI/Tableau for data visualization/communication
• Financial Acumen
• Advanced proficiency in Microsoft Office
• Advanced analytical, investigative, and problem-solving skills
• Proficient understanding of statistics and using algorithms for predictive performance
• Knowledge of data wrangling and ability to make recommendations on solutions