FP&A Business Intelligence Analyst

Omega Holdings is private equity-owned leading distributor of air conditioning and other high demand aftermarket components to a broad range of light-duty and heavy-duty vehicle end markets. Omega has created a unique, market leading platform in the automotive aftermarket with numerous opportunities to apply its repeatable playbook to grow both organically and through acquisition.

Position Summary:

Omega Holdings' corporate headquarters is seeking a detail-oriented and high-performing professional to assist and support the finance & IT department. The role involves using Microsoft Power Tools such as Power BI, Power Query, and Power Automate to standardize financial analysis, developing financial KPIs, and streamlining reporting across all Omega brands. The role will report directly to the Director of FP&A.

Duties/Responsibilities:

• Automate processes and spreadsheets using Microsoft Power Automate
• Prepared data for loading into Power BI using Power Query
• Collaborate with stakeholders to understand data needs and analyze the datasets to uncover trends and insights
• Develop reporting and analyses around key business functions including pricing, cost, margin, expenses, and inventory to allow business units to make decisions quickly
• Identify key trends and patters and develop actionable insights to improve the business
• Provide ad-hoc data support to the business units
• Provide data analysis to support planning and executing transactions, partnerships, and strategic growth initiatives
• Design interactive dashboards and reports to clearly visualize key metrics, using tools such as Power BI

Desired Professional Skills and Experience:

• 2-4+ years of work experience ideally in a finance department developing processes using Microsoft Power Automate
• 2-3+ years developing dashboards using Microsoft Power BI
• Undergraduate degree in finance, accounting, STEM or related preferred
• Patience and ability to excel under pressure, handling multiple requests often with tight deadlines
• Knowledge of accounting and finance principles and previous financial reporting/modeling systems
• Strong organizational and analytical skills
• Extensive experience working with raw data sets with Microsoft Excel or similar analytical program preferred
• The ability to present and communicate work effectively to management
• Outstanding communication skills in both written and verbal expression
• Distribution, manufacturing, or retail Industry experience is a plus, but not required
• Degrees in Finance, Computer Science, or Statistics with years of experience using Microsoft Power Tools