Senior Business Intelligence & Financial Strategy Analyst

Job Title: Senior Business Intelligence & Financial Strategy Analyst

Location: Waterloo, Iowa

Salary: $75-95K plus bonus  

Job Summary of the Senior Business Intelligence & Financial Strategy Analyst : This role will serve as a strategic partner to the executive leadership team. This role combines advanced financial analysis, business intelligence, data management, forecasting, and artificial intelligence applications to drive better decision-making throughout the organization. The ideal candidate is highly analytical, exceptionally skilled in Excel, comfortable working with large and complex datasets, and passionate about leveraging AI and modern technology to improve business performance. This individual will work directly with senior leadership to provide actionable insights that influence operational, financial, and strategic decisions.  

Job Duties & Responsibilities of the Senior Business Intelligence & Financial Strategy Analyst:

· Develop and maintain sophisticated financial models, forecasts, and budgeting tools.

· Analyze profitability by product line, customer, market segment, and operational area.

· Prepare executive-level reporting, dashboards, and performance metrics.

· Support strategic planning, capital investment analysis, and business case development.

· Identify trends, risks, and opportunities through financial and operational analysis.

· Collect, organize, validate, and analyze data from multiple business systems.

· Design and maintain automated dashboards and KPI reporting tools.

· Develop business intelligence solutions that improve visibility into company performance.

· Create predictive models and scenario analyses to support executive decision-making.

· Translate complex data into clear recommendations for leadership.

· Build advanced Excel models utilizing: Power Query, Power Pivot, Complex formulas, Dynamic dashboards, VBA/macros where appropriate

· Improve and automate reporting processes.

· Ensure data integrity and establish best practices for data management.

· Identify opportunities to apply AI tools across finance, operations, sales, and manufacturing.

· Develop AI-assisted workflows to improve productivity and decision quality.

· Evaluate emerging technologies and recommend practical applications.

· Partner with leadership to implement AI-driven solutions that create measurable business value.

· Serve as an internal champion for responsible AI adoption.

· Work directly with the CEO and executive team on special projects.

· Conduct market, competitive, and operational research.

· Support mergers, acquisitions, strategic initiatives, and growth opportunities as needed.

· Provide data-backed recommendations to support company strategy.

Education & Experience Requirements of Senior Business Intelligence & Financial Strategy Analyst:

· Bachelor's degree in Finance, Accounting, Economics, Data Analytics, Business, Engineering, or related field. MBA, CPA, CFA, or related advanced credentials a plus.

·5+ years of experience in financial analysis, business intelligence, data analytics, or related roles.

· Expert-level Microsoft Excel skills.

· Advanced financial modeling and forecasting experience.

· Strong analytical and problem-solving capabilities.

· Experience working with ERP systems and large datasets.

· Excellent communication and presentation skills.

· Demonstrated ability to work independently and drive projects to completion.

· Experience in manufacturing, industrial, transportation, or equipment industries.

· Experience with Power BI, Tableau, SQL, Python, or similar analytics tools.

· Experience implementing AI solutions in a business environment.

· Knowledge of machine learning, automation platforms, and modern AI tools.

· Familiarity with Microsoft Copilot, ChatGPT, Claude, Gemini, and related technologies.