Sr. Business Analyst, Corporate Strategy & Analytics

ERMCO Remote•,

1d•Remote

About The Position

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.

Requirements

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

Nice To Haves

Experience in strategy consulting, financial analyst, business intelligence analyst

Responsibilities

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
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.
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
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