jobapplier

Senior Financial Analyst

Biotage

Skills

Required

  • Supervisory
  • Excel
  • PivotTables
  • Power Query
  • Power BI
  • data modeling
  • data transformation
  • visualization
  • Power BI/Power Query
  • data-processing
  • queries
  • data analysis
  • DAX
  • Microsoft
  • D365 ERP system

Preferred

  • revenue reporting
  • Advanced Excel
  • Microsoft D365
  • revenue forecasting
  • tracking
  • Business Intelligence
  • Microsoft D-365
  • Power BI reporting

This role is hybrid (minimum 3 days a week onsite required) in Charlotte, NC. Biotage offers a comprehensive benefits package including health, dental, and vision insurance as well as a 401k program w/ company match and more!

About Biotage

  • From drug discovery and development to analytical testing, Biotage supports the work that drives progress in life science and improves human health.
  • With expertise in separation and purification technologies and versatile, intelligent workflow solutions, we help optimize processes for more than 5,000 customers worldwide.
  • to empower scientists to simplify and accelerate discovery and development.

Responsibilities

  • Description The Senior Financial Analyst will report to the CFO and be responsible for supporting the Americas and APAC management teams over multiple sites with a focus on commissions and revenue reporting.
  • Oversee and manage the financial analysis process.
  • Competent in Power BI, Advanced Excel, Power Query, DAX and Microsoft D365.
  • Create and maintain commission plans for the Americas and APAC commercial teams based on parameters provided. • Manage the revenue reporting and revenue forecasting processes to ensure timely delivery of information. • Oversee deferred revenue and gross margin tracking reporting. • Track sales discounts and manage annual discount review process. • Build Power BI reports based on the needs of management. • Participate in global projects related to Business Intelligence. • Support Microsoft D-365 needs. • Communicate with and train users of Excel and Power BI reporting

Requirements

  • Excellent verbal and written communication skills. • Highly organized and detail oriented. • Supervisory and management skills. • Advanced proficiency in Excel, including PivotTables and the ability to read, troubleshoot, modify, and build complex formulas and models • Strong Power Query skills, particularly connecting to external data sources, transforming and combining data, and building refreshable models based on those connections. • Strong Power BI skills, with an emphasis on data modeling, Power Query, and data transformation rather than primarily visualization. • Ability to use Power BI/Power Query as a data-processing platform, not just a reporting tool. • Ability to write and modify queries is strongly preferred • Proficient with data analysis, critical thinking and problem-solving. • Skilled in time management and the ability to prioritize tasks. • Strong technical troubleshooting and root-cause analysis • Ability to explain technical concepts and results clearly to nontechnical users
  • Bachelor’s degree in finance • Advanced Excel skills • Proficient in Power BI, Power Query and DAX • Experienced with Microsoft D365 ERP system. • 3 years of experience in report creation and financial/data analysis.
Easy Apply