Senior Business Analyst, Corporate Strategy & Analytics

Role Description

We have an opening for a Sr. Business Analyst that will partner with key stakeholders to facilitate financial modeling and data-driven, strategic decision-making across ERMCO. A successful candidate will be a driven individual who loves helping people across the organization. This role will work cross-functionally with operations, sales, quality, safety, human resources, IT, and engineering to develop the insights needed to make important decisions. The role will have a high level of exposure to senior leadership, and the work will have a direct impact on ERMCO’s Mergers & Acquisitions ambition and on supporting leadership decisions. The candidate must be a Microsoft Excel financial modeling ninja and a Microsoft Power BI guru with an eye for creating dashboards!

This is a remote role in the following states: FL, GA, IL, KS, NC, NE, SD, TN, TX, WI, WY. Relocation is available.

Responsibilities

• Financial Analysis
  • Performing financial statement analysis and other quantitative and qualitative assessments
  • Reviewing confidential Information memoranda, board of directors’ presentations and financial models to develop an understanding of the company being analyzed
  • Market research including general economic conditions, market condition and trends, acquisitions and divestitures
  • Participating in developing and refinement of 5-yr. Long Range P&L Forecasts including P&L, Balance Sheet, Cash Flow Statements
  • Build detailed joint venture and partnership models, including capital contribution structures, profit-sharing waterfalls, and scenario-based return analyses
• Strategic initiatives
  • Construct internal project-level Net Present Value (NPV) and Internal Rate of Return (IRR) models to support capital investment decisions, greenfield/brownfield facility evaluations, and capacity expansion business cases.
  • Prepare comprehensive business cases with clearly defined assumptions, sensitivity analyses, and risk-adjusted return profiles to support executive and board-level decision-making.
• Business Intelligence
  • Dashboards
    • Design, develop, maintain scaled, automated, user-friendly systems, reports and dashboards that will support our leaders
    • Define key metrics/KPIs in collaboration with business stakeholders
    • Drive cross-functional reporting by building dashboards, self-service tools, and reports to analyze and present data
    • Support ad-hoc reporting requests and identify ways to improve scalability and enable self-service drilldowns within the Power BI tool
  • Analytics tooling
    • Develop and optimize semantic data models within Power BI, including DAX measures, calculated columns, and relationships across multiple data sources to ensure accurate and performant reporting
    • Research and source external data inputs to support and enhance analytics tools, ensuring data quality, relevance, and usability for business insights and reporting
    • Connect to and integrate diverse data sources (ERP systems, Excel workbooks, SQL databases, cloud-based platforms) using Power Query to build robust and automated data pipelines

Qualifications

• Bachelor’s Degree in a quantitative discipline (e.g., Finance, Accounting, Statistics, Mathematics, Data Science, Analytics, or similar)
• 3+ years of experience in Financial Modeling including DCF, acquisition valuations, LBO, JV Modeling, project NPV/IRR, business casing, sensitivity analysis, due diligence support
• 3+ years of experience in Business Intelligence, Data Analytics, or related quantitative functions
• 3+ years of experience in performing data analysis on Microsoft Excel using various functions
• Knowledge and direct experience using business intelligence reporting tools – specifically Microsoft Power BI, DAX/Power Query and Data Modeling
• 2+ years of SQL - Experience with relational databases and knowledge of query tools

Preferred Qualifications

• Experience in strategy consulting, financial analyst, business intelligence analyst

Job Locations

• US