Sr. Business Analyst, Corporate Strategy & Analytics

Job Summary

We are seeking a Senior Business Analyst to partner with key stakeholders to facilitate financial modeling and data-driven strategic decision-making across ERMCO. The ideal 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 will have a direct impact on ERMCO's Mergers & Acquisitions ambition and on supporting leadership decisions.

Responsibilities

• Financial Analysis

• M&A/Corporate Development
• 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 refining 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
• 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

• Strategic Initiatives

• 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

• Minimum 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

Join ERMCO and TRANSFORM your career!

Job Locations: US