Business Intelligence / Financial Analyst / Power BI (W2 Position)

Hi We have a job opportunity of a Role Business Intelligence / Financial Analyst / Power BI with given job description on W2. Please forward updated profile to Koti@megansoft.com or 1  (248) 671-4750.

Role: Business Intelligence / Financial Analyst / Power BI (W2 Position)

Location: Dearborn, MI (Hybrid)

Duration: 12 Months

Experience: 5 Years

JD:

• As part of Ford Supply Chain IT, this role is to work as a part of the Director’s Planning and Integration team to manage the forecasts and actuals for Purchase Orders for our $100M department.
• We are replacing the monthly report out (mostly using Excel and graphs in PowerPoint) with PowerBI and PowerAutomate procedures.
• This role is to continue development of our PowerBI dashboards, develop new dashboards, and integrate PowerAutomate to automate the manual processes. Additionally, when needed, communicate monthly with the supervisors to gather their headcount/financial plans and then partner with the other team members to collate that data for senior leadership.
• Use creativity to clearly explain the data to the leadership team, with graphics and “tell a story”, when appropriate.
• Gather actual financial spending each month and enter future financial forecasts. Provide fallback support for when the team’s other financial analysts are unavailable, regarding the monthly Purchase Orders forecasts and actual-payments.
• Additionally, partner with the Integration Team’s supervisor to support diverse requests from Finance and the IT Business Office.
• While Excel data is often the basis of such requests, use AI and PowerPoint to generate ways to explain conclusions creatively and clearly.
• In summary, while this position is primarily for PowerBI, PowerAutomate, the selected candidate needs to be comfortable working with financial data and the precision that requires.

Skills Required:

• Financial Reporting, Microsoft Office, Microsoft Excel

Skills Preferred:

• Financial Reporting

Experience Required:

• 2 years developing PowerBI, PowerAutomate dashboards and processes
• 3 years with Microsoft Office suite (Outlook, PowerPoint, SharePoint, etc.)

Experience Preferred:

• 2 years Accounting or IT Analysis experience
• 3 years leveraging Excel for data analysis (doesn’t have to be financial data)

Additional Information :

• Hybrid Position 4 days a week onsite