Job Description

Overview:

Business Analyst analyzes financial data forecasts trends prepares financial models and statements and supports strategic planning and performance management.

Job Duties:

1. Collect analyze and forecast sales and revenue projections from the BP manager estimate logistics expenses from the logistics department and compile fixed personnel salaries travel expenditures employee benefits and other operational costs from the HR and administrative departments. Develop and structure the predictive index report ensuring accuracy and completeness and submit it to Tagetik system for strategic analysis and decision-making.
2. Use Power BI to present planned forecasted and actual financial data analyzing variances between actual results and projections to assist management in addressing accounting and financial inquiries and enabling informed decision-making.
3. Upon completing the month-end closing extract the detailed revenue and cost report from SAP segmenting the data by customer brand category and product type. Analyze and present variances between actual figures and forecasted values across different customers and product lines using Excel ensuring transparency and insightful financial assessment.
4. Prepare and examine financial statements based on accounting rules using SAP; Apply Excel VBA and Excel Power Query to analyze the statements using multiple financial theories including. DuPont analysis Costvolumeprofit analysis and Sensitivity analysis.
5. Utilize Power BI and Power BI DAX to construct and maintain comprehensive financial and operational analysis models enabling multi-dimensional insights into business performance. This includes tracking year-over-year (YoY) and month-over-month (MoM) changes as well as comparisons between year-to-date (YTD) and current months results. The models also allow for the quick identification of profitable or loss-making models providing valuable decision-making support for leadership. Automate data analysis processes and adjust models to accommodate new business requirements and changes. Regularly publish reports to ensure all teams are informed of critical updates fostering a proactive approach to managing performance and adapting to evolving business dynamics.
6. Use Excel and Power BI conducting a three-factor model analysis examines the impact of price structure and cost on gross profit margins for each product category. By integrating these factors you can quickly identify how each element influences profitability highlighting areas for improvement such as pricing adjustments cost reduction or product mix adjustments. This analysis empowers managers to make data-driven decisions optimize resource allocation and address underperforming products ultimately enhancing profitability and supporting sustainable long-term business growth.
7. Utilize SAP and Power BI analyze on-hand inventory by evaluating the storage duration of different product models across various warehouses. Identify models that exceed the predefined storage threshold and investigate the reasons for slow inventory turnover. Proactively notify responsible teams about sales progress to prevent stockpiling minimize warehouse space usage and optimize storage costs ensuring efficient inventory management and operational effectiveness.

Job Requirements:

At least a Bachelors degree in Business Analytics Operations Research Finance Business Management Business or a closely related field plus minimum 2 years of post-baccalaureate experience working as Business Analyst Operations Research Analyst Financial Analyst or closely related positions. Foreign degree equivalent is acceptable. We will also accept any suitable combination of education training and/or experience. Experience should include working on SAP Tagetik Excel VBA Excel Power Query forecast; financial assessment; financial statements; Cost-Volume-Profit (CVP) analysis; Sensitivity analysis; and model analysis.

Hours: M-F 9:00 a.m. 6:00 p.m.

Job Location: Suwanee GA 30024

Contact: Email resume referencing Job code #BAHisense to HR Manager Hisense USA Corporation at with a copy to .

Hisense USA provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race color religion sex national origin citizenship status age disability or any other category protected under applicable law. This policy applies to all terms and conditions of employment including but not limited to hiring placement promotion termination layoff recall transfer leaves of absence compensation and training.

Required Experience:

IC

Job Tags

Similar Jobs