This job has closed.

Bopinc · 12 hours ago

Business Analyst II, Financial Planning & Analysis, Shopbop

Madison, WI

Full-time

Onsite

Mid Level

$67K/yr - $143K/yr

3+ years exp

Bop LLC is seeking an experienced Business Analyst to drive strategic financial planning and business optimization initiatives across the organization. The successful candidate will focus on developing financial models, conducting business performance analysis, and providing data-driven insights to support key business decisions.

CharityConsultingInnovation ManagementNon Profit

Responsibilities

Develop and maintain financial models to support business planning, forecasting, and strategic initiatives

Create and analyze monthly, quarterly, and annual financial reports to track business performance and identify trends

Partner with business leaders to develop revenue forecasts and expense budgets

Build and maintain dashboards to monitor key business metrics and KPIs

Conduct variance analysis and provide insights on business performance against plans

Support strategic initiatives through financial modeling, scenario analysis, and ROI assessment

Perform market analysis and competitive benchmarking to identify business opportunities

Analyze customer behavior and revenue trends to support growth strategies

Develop and automate reporting solutions to improve efficiency and data accuracy

Partner with cross-functional teams to drive process improvements and operational efficiency

Support business cases for new initiatives with comprehensive financial analysis

Qualification

Financial modelingData analysisExcel VBAExcel pivot tablesSQLData visualization (Tableau)Financial statements knowledgeStakeholder managementCommunication skills

Required

3+ years of tax, finance or a related analytical field experience

5+ years of Excel (including VBA, pivot tables, array functions, power pivots, etc.) and data visualization tools such as Tableau experience

3+ years of business or financial analysis experience

Bachelor's degree or equivalent

Experience defining requirements and using data and metrics to draw business insights

Experience with Excel

Experience with SQL

Experience making business recommendations and influencing stakeholders

Strong understanding of financial statements and accounting principles

Excellent written and verbal communication skills

Preferred

Experience in IBM Cognos TM1/Planning Analytics work including system configuration, model building and developing reports or dashboards with TM1

Experience using data visualization tools

Experience in stakeholder management, dealing with multiple stakeholders at varied levels of the organization

Experience using Oracle, or experience in solving complex business challenges by delivering accurate and timely financial models, analysis, and recommendations that have a proven impact on business (e.g., financial savings, operational improvements, or customer benefits)