Vacancy expired!
- The Business Intelligence Data Analyst (BIDA) will be an integral member of the worldwide FP&A team and will support the Global Senior Finance Director.
- This position will support the existing reporting structure for Sales, Finance and Accounting, assist with the transitions/architect/document to an EDW environment and develop advanced MS Excel/Power BI reporting within the finance function.
- Create new Power BI reporting dashboards mirroring existing reporting and identified reporting from senior leadership.
- Review/validate data for accuracy and consistency and work with any other teams necessary to improve accuracy and reliability of data
- Prepare internal management daily/weekly/monthly/quarterly reporting and analysis to support senior leadership and sales - such as the Daily Sales Report, ABC Customer analysis, Logistical Heat Maps and Key Customer reporting.
- Assist with the budget and forecasting analysis/templates for FP&A by leveraging trend analysis. Load the final approved Volume, Revenue, and Cost budgets into SAP.
- Experience with SAP (ERP system) and the ability to query and directly access transactional level data tables strongly preferred
- Collect and analyze geo fields, key attributes, and industry & general economic data to support longer-term strategic planning
- Passion for reporting excellence thru process improvements, technological efficiencies, and transparency.
- Bachelor's degree in Finance, Accounting, Economics, Mathematics, Statistics, Computer Science, or Data Analytics require
- Advanced/Expert-level Excel skills and demonstrable ability to efficiently create advanced/dynamic data modeling
- Microsoft SQL Server, SQL, MS Access, and Power BI considered a must
- Data Modeling Experience
- Advanced SQL skills
- Microsoft SQL Server Expert - 2016 & Above
- Azure SQL (cloud based) - Preferred
- SQL Server Management Studio (SSMS) (minimum requirement)
- SQL Server Reporting Services (SSRS)
- SQL Server Integration Services (SSIS)
- Performance Tuning
- Automation of Report Generation
- Advanced Power BI
Vacancy expired!