Financial Analyst Full-Time

Big Ideas Social Media Inc.; United States; Remote; USD 90,000 - 130,000; Full time

Benefits offered by this job

Remote work

Job summary

Big Ideas Social Media Inc. is seeking a meticulous, commercially minded remote Financial Analyst to support our US-based client in the beauty and wellness sector. You will transform transactional data into financial models, variance analyses, and executive narratives, reporting to the FP&A Manager.

This is a full-time, contractual freelance role for an initial 3-month trial while working remotely. A favorable outcome may lead to contract renewal with potential benefits.

Qualifications

• Bachelor's degree in Accounting/Finance or related field.
• 4–5+ years FP&A or corporate finance experience.
• Experience supporting omnichannel DTC brands.
• Strong business sense and financial acumen.

Responsibilities

• Operate NetSuite and third-party file loads into BigQuery; monitor schema changes and fix loads.
• Run Retailer door sales sync; reconcile data between Excel VBA and Google Sheets.
• Prepare monthly/ quarterly FC packs; draft variance commentary.
• Produce KPI reports and pricing/profitability analyses.
• Maintain master data and pricing schedules; support FP&A functions.

Skills

SQL (Advanced)

Data analysis

Financial fluency

English proficiency

Education

Bachelor's degree in Accounting/Finance

CPA/CMA/CFA track advantageous

Tools

NetSuite

BigQuery

Google Sheets

Google Apps Script

VBA

Excel

Job description

This is a remote position.Big Ideas is seeking a meticulous, commercially minded, and proactive remote Financial Analyst to support our US-based client, a growing company in the beauty and wellness industry. In this role, you will report directly to the FP&A Manager and serve as a core analytical resource responsible for financial planning, budgeting, forecasting, and commercial decision support. Supporting an omnichannel consumer brand footprint spanning direct-to-consumer (Shopify DTC), Amazon marketplace, and wholesale retail partner channels, you will transform transactional data into clear financial models, variance analyses, and strategic executive narratives.

This is a full-time, contractual, freelancer position for a trial period of 3 months while working at home. If you are a highly motivated and detail-oriented individual with experience and qualified based on the criteria below, we encourage you to apply.

Upon successful completion of the evaluation period, the contractor's performance will be reviewed, potentially leading to a contract renewal that may include a benefits package.

JOB DESCRIPTION1.

• Weekly Cadence Database Support: Operate the existing NetSuite and third party file loads into BigQuery. Extend them to new sources using the patterns already designed. Watch for schema changes and failed loads, and fix the cause rather than re-running. Design changes are specified by FP&A and reviewed before deployment.
• Weekly and Monthly Cadence Retailer door sales sync: Run the two-stage pipeline. Excel and VBA calculation engine on Dropbox feeding the Google Sheets values layer through Apps Script. Reconcile door counts and investigate breaks in the source file. Update monthly FC and maintain report backends.

Monthly and Quarterly Cadence

• Budget versus actuals: Produce the pack across GL account, department and channel. Draft first-pass variance commentary. Maintain the transaction-type dispatch engine and the Description Aliases sheet as new posting patterns appear. Lock latest monthly & Quarterly FC.
• Clinic KPI reporting: Produce reports. Maintain the Boulevard service category mapping.
• Shipping profitability and 3PL billing: Run the shipping file checks and add new ones when a gap is found. Classify job tickets, flag duplicate orders and quantity convention errors, and keep the profitability model current across accounts.
• Field team bonus calculator: Run the Field and Corporate pool calculations. Reconcile the output and confirm caps, gating and payout rates apply correctly before anything is released.
• Sales team bonus calculator: Maintain and update the sales lead / customer mapping. Reconcile against the GRTs.
• Profitability: Maintain, update and archive Brand Pricing schedules for SKUs

Ad Hoc and Continuous Cadence

• International pricing calculator: Maintain VAT, Tariff and FX logic. Run new markets and new SKU scenarios. Check margin outcomes against the intended landed cost build.
• Master data: Own the customer, vendor and employee master tables, channel and sub-channel tagging, and GL account groupings. Onboard new records ahead of each close rather than after a variance surfaces.
• Internal reporting portal: Keep the resource directory (HUB) and its links current as reports move or are replaced.
• Pricing: Maintain / update and archive Brand Pricing schedules for SKUs.

Requirements

QUALIFICATIONS

• Bachelor’s Degree with studies in Accounting, Finance, Economics, or related quantitative field. CPA, CMA, or CFA track is an advantage.
• Minimum of 4–5+ years of proven corporate experience in Financial Planning & Analysis (FP&A), commercial finance, or corporate finance.
• Demonstrable experience supporting omnichannel consumer products, retail, or fast-scaling Direct-to-Consumer (DTC/e-commerce) brand environments.
• Strong business background and financial acumen.

Required Qualifications

FP&A, financial reporting, business analytics, or a finance shared services experience (4+ years preferred)Intermediate SQL. Joins, CTEs, aggregation, window functions. Able to read a long query written by someone else and explain both what it returns and where it would breakAdvanced Google Sheets and Excel. Array formulas, QUERY, INDEX/MATCH and XLOOKUP, pivot tables, Power Query or equivalent.Strong VBA. Able to read, debug and extend an existing macro-driven calculation workbook. Recording macros is not enough on its own.

• Demonstrated ability to teach yourself a new language or tool. Most of the reporting layer runs on Google Apps Script, so you will be writing/editing JavaScript within the first few months
• Able to read a P&L unaided. Understands debits and credits, accruals, gross to net revenue, cost of goods sold and gross margin.
• Strong English skills, both verbal and written.
• Ability to document all processes for a cold execution.
• Comfortable asking questions and escalating issues.
• Self-starter. Evidence of self-directed automation preferred. Something you built because the manual version was slow, and you’re able to explain the design choices behind it.
• Reliable attendance.

Required Technical and Other Skills

• Intermediate to Advanced skills and proficiency with NetSuite

Advanced Excel & Scripting Mastery: Expert proficiency in Microsoft Excel, complex formula architecture, and VBA calculation engines. Experience with Google Sheets and Google Apps Script integrations.

Database & Data Pipeline Management: Practical experience with NetSuite ERP extractions, BigQuery database file loads, schema monitoring, and third-party data pipelines.

Data Integrity & Master Data Ownership: Hands-on experience maintaining chart of accounts groupings, customer/vendor master tables, and product SKU hierarchies.

SYSTEMS & TECHNOLOGY STACK Database & Data Warehouse: NetSuite, BigQuery, third party file loads. Calculation Engines & Scripting: Microsoft Excel, VBA calculation engines (Dropbox), Google Sheets, Google Apps Script. Internal Portals & Repositories: Internal reporting portal / resource directory (HUB). Enterprise ERP & Accounting Systems: NetSuite (cloud ERP) for GL account extraction, department, channel, and master data management.

• Highly organized,