Senior FP&A Data Analyst - Hyperion & Profitability

SCN BestCo; Golden (CO); On-site; USD 121,000 - 181,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) with employer matching

Life insurance

Paid time off

Tuition reimbursement

Job summary

SCN BestCo, a leader in vitamins and supplements, seeks a Senior Data Analyst Accounting to optimize FP&A, financial reporting, and profitability analyses. The role focuses on Hyperion management, data integrity, and strategic forecasting.

The ideal candidate brings 7+ years in FP&A, 3+ years in manufacturing, and strong data skills. Travel to company sites may be required; a collaborative, systems-minded approach is essential.

Qualifications

• Bachelor's degree in accounting, finance, data analytics, information systems, business analytics, economics, statistics, or a related field.
• 7 years' experience in FP&A, financial systems, accounting, financial analysis, data analytics, business intelligence, or related role.
• 3 years' experience in a manufacturing environment.
• Experience with financial planning, reporting, forecasting, budgeting, profitability analysis, or data management.
• Experience using ERP, financial reporting, planning, BI, or data warehouse tools to prepare, reconcile, validate, and analyze data.
• Experience collaborating with Finance, Accounting, IT, Sales, Operations, or other stakeholders on reporting, analytics, or systems projects.

Responsibilities

• Co-administer Hyperion reporting structures, metadata, hierarchies, business rules, and recurring reporting processes.
• Collaborate with IT and system owners to test, document, and implement reporting dimension, data feed, and finance system changes.
• Partner with the sales team to generate commercial forecasts, annual budgets, scenario models, and performance reporting.
• Create executive-level financial presentations for management, owners, and board of directors.
• Support profitability reporting and analytical models by customer, product, channel, and other dimensions.
• Extract, reconcile, validate, and analyze financial, commercial, operational, and master data from ERP, Hyperion, data warehouse, and related systems.
• Develop dashboards, datasets, reconciliations, and analytical tools to improve visibility and confidence in reporting.
• Investigate data discrepancies; coordinate with Finance, Accounting, Sales, Logistics, Operations, and IT to resolve root causes.
• Support finance systems, data warehouse, and ERP initiatives by defining requirements and validating outputs.
• Prepare recurring and ad hoc analyses related to revenue, margin, profitability, forecast performance, and trends.
• Communicate findings and project updates clearly to finance and cross-functional stakeholders.
• Travel as needed to Company sites for projects and cross-functional collaboration.

Skills

Analytical thinking

Communication

Detail orientation

Multitasking

Education

Bachelor's degree in accounting, finance, data analytics, information systems, business analytics, economics, statistics, or a related field

Tools

Hyperion

Essbase

Oracle EPM

Power BI

SQL

Job description

SCN BestCo, a leader in vitamins and supplements, seeks a Senior Data Analyst Accounting to optimize FP&A, financial reporting, and profitability analyses. The role focuses on Hyperion management, data integrity, and strategic forecasting.

The ideal candidate brings 7+ years in FP&A, 3+ years in manufacturing, and strong data skills. Travel to company sites may be required; a collaborative, systems-minded approach is essential.