Business Analyst Finance with Power BI

Overview

On Site
Depends on Experience
Full Time
10% Travel

Skills

Budget Management
Business Intelligence
Financial Reporting
Microsoft Power BI
Microsoft Excel

Job Details

Sr. Business Analyst:

Specific types of analytics and reporting may include performance dashboards, business analytics, modeling, budgeting, and forecasting.


Job Responsibilities
Budget Management: Develop, manage, and monitor the annual budget process, ensuring alignment with organizational goals and objectives. Collaborate with department lead planners to gather budget inputs and provide guidance.
Forecasting: Lead the forecasting process, including monthly, quarterly, and annual forecasts. Analyze variances between actuals and forecasts and provide actionable insights to management.
Financial Analysis: Conduct detailed financial analysis to support business decisions, including profitability analysis, cost-benefit analysis, and scenario planning.
Cost Allocation: Design and maintain cost allocation models to accurately distribute costs across departments and projects. Ensure compliance with internal policies and external regulations.
Reporting: Prepare and present financial reports and dashboards to senior management, highlighting key financial metrics, trends, and variances.
Strategic Planning: Support long-term strategic planning initiatives by providing financial projections, risk assessments, and recommendations for improvement.
Data Management: Maintain and improve financial databases and systems to ensure data accuracy and integrity. Implement process improvements to enhance efficiency and reporting capabilities.
Collaboration: Work closely with cross-functional teams, including business finance, operations, and executive leadership, to provide financial insights and support business initiatives.
Experience with downloading and extracting data from SAP and creating meaningful business intelligence reports and dashboards
Create metrics and compile dashboards and reports; develop summary variance explanations and recommends remedial actions
Assist with the daily operations and provide general IT business & planning support.
Assist in the initiation and coordinating of studies and analysis on IT operations, resource allocation, financial reviews; and analyzing programs to ensure that program goals and work plans are on target.
Analyzes actual spend and forecasting to determine if/when appropriate Change Controls must be implemented.
Provides financial analysis on portfolio cost variances for plan vs. actual and can identify inappropriate charges by resources or vendors and makes appropriate corrections in SAP.
Proficient in mapping data to original source systems to ensure data accuracy and consistency
Perform data verification and validation (i.e. tracing, spot checks, building controls) to identify discrepancies and maintain data integrity
May work as a liaison among stakeholders to coordinate, document, and schedule changes to IT infrastructure and information systems.
Capture, analyze and present data to managers and directors to aid in making business decisions.
Effectively plans and control work on a small project; integrates all aspects, tracks and ensures that work progresses on schedule and that work meets specification or required standard.
Develops communications needed to summarize analysis and to discuss recommendations for peers and executives. This may take the form of dashboards or power point decks.
Facilitates problems solving sessions and workshops with diverse set of business and technology team members.
Proactively follows-up on issues and initiatives for senior leaders to ensure successful resolution and implementation.
Works closely with leaders and other key stakeholders to ensure that key initiatives and activities are delivered in a timely and coordinated manner and aligned with the goals of the organization.
Works with IT and functional leadership to establish a variety of key business, financial and performance metrics.

Qualifications
Minimum:
Bachelors Degree in Business Administration or job-related discipline or equivalent experience
6 - 8 years job-related experience
Expert with Power BI. Able to create dashboards from data sets

Desired:
MBA or Graduate Degree
Proficient in Microsoft Office, Project, Visio, PowerPoint and expert level Excel skills
Experience with Power Automate and Power Apps is a plus

Other Desired Experience:
Financial Reporting: Excel and PowerPoint skills to provide monthly reporting.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.