Job Posting Financial Reporting & Data Analyst

Financial Reporting & Data Analyst

The Financial Reporting & Data Analyst role requires an inquisitive and analytical leader to act as key liaison to the Commercial and Executive Leadership Team in planning and executing business strategy based on data driven results. Core responsibilities include market and financial data analysis and reporting to determine results and trends to support business initiatives. The Business Analyst reports to the VP Finance / Treasurer and will interface with sales, marketing, client services, reimbursement, finance, and senior leadership.

Qualifications

Education, certifications, and experience :

Bachelor's Degree required preferably in Finance, Accounting, Data Analytics, Business or related field.

3 years of work-related experience in a sales, finance, analytics, or marketing analyst role.

Expert level with Microsoft Applications including PowerPoint and Excel. Must know pivot tables, VLOOKUP functionality, automation methods, dynamic charts / graphs, workflow diagrams. Working knowledge of Excel Power Query, Power Pivot, DAX Calculations.

Must be proficient in developing reports and management presentations.

Minimum of 2 years' experience with Python / Pandas (Preferred), R, SQL (Preferred), SAS, Jupyter Notebooks or other analytical coding language.

Minimum of 2 years' experience with data visualization tools like Power BI (Preferred), Tableau or Data Studio.

Able to programmatically connect data sources together via APIs or other automated methods.

Knowledge, skills, and abilities :

Excellent analytical skills required. Ability to analyze / reconcile large amounts of data (in memory) and see gaps or trends that may impact anticipated results or identify that a change or new solution is required.

Proven problem solving, critical thinking and evaluation skills. Ability to teach themselves new analytical skills without much manager oversight.

Passionate about documentation. Ability to create clear and concise documentation that is reusable and reproduceable.

Strong communication and presentation skills. Must be able to facilitate working meetings, ask questions and apply active listening skills, and convey data driven results.

Ability to collaborate with cross-functional teams and get along with diverse personalities at all levels of the organization.

Superior interpersonal abilities. Ability to work with diverse personalities at all organizational levels in pursuit of the company's goals; tactful, mature and flexible.

Accustomed to working collaboratively in a team setting.

Demonstrated organization skills and accuracy skills.

Ability to work independently with minimal direction, take initiative within scope of work responsibilities.

Able to prioritize work, anticipate department needs, plan accordingly for needs, multi-task and adapt to change.

Working Conditions / Physical Requirements

Working conditions :

Majority of work is completed in an office setting working inside a temperature-controlled environment.

Occasional work outside may be required to support employee events.

May perform activities in an environment containing hazardous elements and requiring safety awareness and adherence to all safety and GMP policies and guidelines.

Work must be performed in a safe manner for personal protection and for the protection of other team members.

Physical requirements :

Position requires the ability to sit for a minimum of 6 hours per day.

Ability to stand, walk, bend over, and reach above head on a regular basis.

Ability to lift or carry up to 25 pounds occasionally.

Repetitive use of hands / arms for writing, filing, and computer work.

Ability to use a phone, utilizing a headset as required.

Ability to wear personal protective equipment to enter the manufacturing areas.

Responsibilities

Sales Forecasting Forecast anticipated sales by region, distribution channel, and product division.

Commercial Analysis Prepare quarterly sales commission reports. Analyze Sales, COGs / Margin data, to make pricing recommendations. Analyze trends in geographic regions, distribution channels, product categories.

Performance Reporting Prepare financial performance reports across the US and International businesses. Track sales performance against budget, determine marketing promotion effectiveness (digital and non-digital channels), and identify key drivers of performance from within cross functional datasets.

Financial Analysis and Dashboards Prepare financial analysis on the success of new products, provide financial support on special projects, and develop dashboards which highlight KPIs for Senior Leadership.

Variance Analysis Research, automate via analytics tools and report on variances from standard data such as cost and time.

Marketing Campaigns Collect, analyze, and provide results on various marketing campaigns and initiatives.

SalesForce Opportunities Retrieve, analyze and report patient loyalty trends as well as report conversion data from sample to new patient starts.

Customer Satisfaction Analytics Leverage attitudinal data by administering our annual healthcare professional and patient satisfaction surveys.

Build Analytical Infrastructure Work closely with team members to create end to end data pipelines, clean (ETL) existing data sources from APIs / CSVs / Databases, set up staging tables within databases and present data via Visualization Tools.

Other duties as assigned.

Salary Range

$78,733-$96,000

EEO Statement

Ajinomoto Cambrooke, Inc. is an Equal Opportunity Employer-Vets / Disabled, committed to a diverse workforce. If you need assistance with completion of an application for employment, please contact Human Resources Department.