BruntWork

Overview:
Our client is seeking a detail-oriented
Senior FP&amp;A and Reporting Automation Analyst (SQL | VBA)
to manage and streamline our recurring financial reporting infrastructure across NetSuite, BigQuery, Google Sheets, Apps Script, and Excel VBA. In this full-time remote role, you will execute monthly close tie-outs, maintain automated data pipelines, and draft executive-level variance commentary. You will also manage master data mappings and actively work to optimize codebase efficiency and reporting workflows. Strong financial literacy, intermediate SQL skills, and advanced Excel/VBA expertise are required.
Schedule:
Monday - Friday, 9:00 AM - 6:00 PM EST | With a 1-hour unpaid break (40 hours per week)
Responsibilities:
<ul>
<li>FP&amp;A Dashboard &amp; Budget vs. Actuals:
Run full monthly refreshes across Apps Script and BigQuery, tie the channel P&amp;L back to NetSuite actuals, clear unallocated balances, and produce the monthly budget versus actuals pack with first-pass variance commentary</li>
<li>Revenue Reporting:
Draft weekly revenue recaps, explain account variances above established thresholds, and maintain brand-specific Gross Revenue Trackers (GRTs) while verifying order shipping statuses</li>
<li>Data Pipelines &amp; Syncs:
Manage weekly and monthly retailer door sales syncs using Excel and VBA calculations, and produce monthly clinic KPI reports utilizing Boulevard service category mappings</li>
<li>Shipping &amp; Profitability:
Execute monthly shipping file checks, classify job tickets, manage 3PL billing accuracy, and update SKU gross margin (GM) reports</li>
<li>Calculators &amp; Scenarios:
Run monthly and quarterly field and sales team bonus calculators, and maintain the international pricing calculator to test new market and SKU scenarios based on VAT, Tariff, and FX logic</li>
<li>Master Data &amp; Database Support:
Own master tables (customer, vendor, employee) and GL account groupings, ensuring new records are onboarded ahead of each close. Operate and extend NetSuite and third-party file loads into BigQuery, actively monitoring for schema changes and failed loads</li>
<li>Process Documentation &amp; Continuity:
Keep the internal reporting portal (HUB) current and create reliable, written runbooks for every recurring process to ensure seamless coverage by a second person.</li>
<li>Conduct a full function inventory of the Apps Script codebase to eliminate duplicate logic and mystery functions</li>
<li>Develop caching layers to replace repeated live queries, reducing query costs and ensuring trend charts match P&amp;L methodologies</li>
<li>Deploy channel splits and allocation logic, and introduce new guard checks on inbound retailer and logistics files.</li>
<li>Propose new solutions to remove manual steps or simplify mapping logic, providing estimated time savings for each proposal</li>
</ul>
Must-Have Requirements:
<ul>
<li>Experience:
4+ years preferred in FP&amp;A, financial reporting, business analytics, or finance shared services</li>
<li>Financial Literacy:
The ability to independently read a P&amp;L, with a strong understanding of debits and credits, accruals, gross-to-net revenue, COGS, and gross margin</li>
<li>Technical Proficiency:
Intermediate SQL skills (Joins, CTEs, aggregation, window functions) alongside advanced Google Sheets/Excel knowledge (Array formulas, QUERY, XLOOKUP, Power Query)</li>
<li>VBA Expertise:
Strong VBA skills with the ability to read, debug, and extend existing macro-driven calculation workbooks</li>
<li>Adaptability:
A demonstrated ability to self-teach new languages or tools, specifically JavaScript/Google Apps Script, which powers most of the reporting layer</li>
<li>Communication:
Strong verbal and written English skills to accurately document processes and draft executive-level commentary</li>
<li>Work Ethic:
A self-starter mentality with reliable attendance, a track record of self-directed automation, and comfort proactively escalating issues</li>
</ul>
Nice-to-Have Requirements:
<ul>
<li>Familiarity with BigQuery, including partitioning and query cost awareness</li>
<li>Experience with NetSuite or comparable ERPs, particularly pulling saved searches and standard exports</li>
<li>Industry background in beauty, CPG, or retail, including exposure to retailer sell-in/sell-through data or 3PL billing</li>
<li>Business Intelligence literacy (Looker Studio, Power BI, or Tableau)</li>
<li>Knowledge of Python for file handling, or version control habits like Git</li>
</ul>
Independent Contractor Perks:
<ul>
<li>Permanent work from home</li>
<li>Immediate hiring</li>
<li>Health Insurance Coverage for eligible locations</li>
</ul>
Note:
Please click the "Apply" button to complete your application, including the assessment questions, technical check, and voice recording. Your hourly pay rate will be established based on your performance in the application process; submissions with all requirements fulfilled will receive priority review.
One application, multiple possibilities:
When you apply, our team reviews your background against all current openings, not just this one! If a different role fits your skills, we'll get in touch! We also encourage you to keep exploring our job board and apply directly to any position that excites you.

Senior FP&A and Reporting Automation Analyst (SQL | VBA)

Senior FP&A and Reporting Automation Analyst (SQL | VBA)

This job is no longer available

Talents

Recruiters

About