We believe being healthy should not require tradeoffs. SCN BestCo is a leading innovator, developer and manufacturer of Vitamin, Mineral & Supplement (VMS), Over-the-Counter (OTC) and prebiotics/probiotics in enjoyable forms such as gummies, lozenges and chews. With over 50 years of excellence, our team leads the way in changing how consumers make healthier choices. With unique food science expertise and proprietary processes, we’ve pioneered many firsts. The fire in our belly to create new to the world products has guided and continues to be core to our mission of making health and wellness more enjoyable. Come join us and become a part of our winning formula!
The Senior Data Analyst Accounting supports Financial Planning & Analysis (FP&A), Finance, Accounting, and business leaders by improving visibility to company performance and strengthening confidence in reported results. The role manages and enhances the Hyperion reporting environment, partners with Information Technology (IT) on reporting dimension changes, and supports commercial forecasts and budgets. The Senior Finance Analyst has significant project emphasis related to the buildout of analytical tools and profitability models. This position requires strong technical, mathematical, and analytical skills, as well as attention to detail, clear communication skills, and a process-oriented and task-oriented disposition.
Estimated starting annual base salary is $120,833.27 - $181,249.90 per year less applicable withholdings and deductions, paid on a bi-weekly basis. Please note that the actual compensation offered may vary based on relevant factors as determined by the Company, which may include, but is not limited to, location, experience, qualifications, education, skillset, and market conditions. The target base compensation for this role is in the low to middle of the range, with the top of the range reserved for only exceptional circumstances. In addition, this role is eligible for a discretionary, variable annual incentive, paid based on Company performance factors. SCN BestCo offers a competitive benefits package to eligible full-time employees, which currently includes medical, dental, and vision plans, 401(k) with employer matching contributions, life insurance, paid time off, tuition reimbursement, and more, as well as paid sick leave in accordance with applicable law. Each benefit is subject to eligibility requirements as specified in plan documents, and the Company reserves the right to modify the benefits it offers from time to time.
Essential Duties and Responsibilities
- Co-administer Hyperion reporting structures, metadata, hierarchies, business rules, & 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 the development and maintenance of profitability reporting and analytical models by customer, product, channel, and other key business dimensions.
- Extract, reconcile, validate, and analyze financial, commercial, operational, and master data from enterprise resource planning (ERP), Hyperion, data warehouse, and related systems.
- Develop dashboards, datasets, reconciliations, and analytical tools that improve performance visibility and reporting confidence.
- Investigate data discrepancies and reporting issues; coordinating with Finance, Accounting, Sales, Logistics, Operations, and IT to resolve root causes.
- Support finance systems, data warehouse, and enterprise resource planning (ERP) initiatives by defining requirements, validating outputs, testing, and documenting reporting needs.
- Prepare recurring and ad hoc analyses related to revenue, margin, profitability, forecast performance, customer trends, product trends, and business drivers.
- Communicate findings, reporting changes, and project updates clearly to finance and cross-functional stakeholders.
- Travel as needed to Company sites for projects, systems work, and cross-functional collaboration.
Required Qualifications
Education & Experience:
- 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, commercial finance, or a 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.
Knowledge, Skills, & Abilities (KSAs):
- Strong understanding of FP&A processes, including forecasting, budgeting, variance analysis, performance reporting, and profitability analysis.
- Driven, task-oriented work style with the ability to manage priorities, support projects, and meet deadlines collaboratively.
- Strong attention to detail, data accuracy, reporting integrity, documentation, controls, and issue resolution.
- Working knowledge of financial reporting systems, multidimensional structures, metadata, hierarchies, mappings, and reporting dimensions.
- Ability to translate business questions into reporting requirements, analytical approaches, and decision-useful insights.
- Ability to design, maintain, and troubleshoot datasets, dashboards, reconciliations, validations, models, and repeatable reporting processes.
- Ability to administer or support planning and reporting environments such as Hyperion, Essbase, Oracle, or comparable platforms.
- Understanding of ERP, data warehouse, master data, and finance system concepts, including the reporting impact of data structure changes.
- Advanced Excel and analytical skills, with the ability to work accurately with large and complex datasets.
- Proficient in Microsoft Office (Word, Outlook, PowerPoint).
- Ability to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane and solid geometry and trigonometry. Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.
- Must have the ability to communicate effectively, both verbally and in writing, with internal staff and management. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from internal stakeholders.
- Must be able to demonstrate practical problem solving and troubleshooting skills. Ability to solve practical problems and operate in situations where only limited standardization exists.
Preferred Qualifications
- Hands-on experience with Hyperion, Essbase, Oracle EPM, Oracle ERP, Power BI, SQL, Power Query, DAX, Alteryx, Python, or comparable finance and analytics tools.
- Experience supporting commercial forecasting, sales finance, customer or product profitability, margin analysis, or enterprise profitability modeling.
- Experience with data warehouse, BI, master data, reporting dimension, metadata governance, or financial reporting control initiatives.
- Experience in consumer packaged goods, food, dietary supplement, consumer healthcare, or another product-based environment.
- General understanding of standard costing, inventory, manufacturing variances, SKU-level margin, customer profitability, and operational drivers of financial performance.