Business analyst

Wells Lamont LLC

As a part of the global industrial organization Marmon Holdings—which is backed by Berkshire Hathaway— you’ll be doing things that matter, leading at every level, and winning a better way. We’re committed to making a positive impact on the world, providing you with diverse learning and working opportunities, and fostering a culture where everyone’s empowered to be their best.

Position Overview

The Business Analyst supports the Finance department with data-driven insights, financial analysis, and reporting that drive strategic decisions – while equally focusing on automation. This role reduces manual effort by automating recurring finance processes with Python scripting and builds reliable, governed Power BI dashboards and reports. Partnering closely with Controllers and cross-functional teams, the Business Analyst ensures accurate, timely delivery of information and continuously strengthens the robustness of our financial procedures.

Essential Duties and Responsibilities

Analytics Projects

• Analyze product, customer, and sales data including:
• SKU Count
• Inflation Trends
• Product / Style Ranking
• 80/20 Analysis and Quartile Segmentations
• Tariff Analysis
• Fulfill custom reporting requests as needed by leadership

Financial and Sales Reporting

• Prepare and reconcile reports such as Sales vs GL, AR vs Sales, and Profitability Scorecards.
• Maintain and update the Apprise Profitability Scorecard.
• Generate Customer Profitability Reports and Sales Reports segmented by customer, product, and sales representative.
• Develop Financial Reporting Packages for senior management review.

Planning, Forecasting, and Budgeting

• Collaborate with finance team members on Forecasting, Budgeting, and Cost Maintenance efforts.
• Support the development and maintenance of Proforma Templates.

Qualifications

• 3+ years of experience in data analysis, financial reporting, or business intelligence.
• Degree in Mathematics, Computer Science, Information Systems, or related fields
• Basic or indeterminate knowledge in Accounting/Finance
• High proficiency in Python, Power BI, Excel, SQL, and related analytic tools.
  • SQL: Able to write queries that join multiple tables, apply filters, and perform aggregations. Comfortable using SQL to retrieve and validate data for financial analysis and reporting.
  • Python: Capable of writing scripts to automate routine tasks or process data files.
  • Power BI: Able to connect various data sources; understands data modeling through table relationships and foundational DAX for reporting insights.
  • Version Control (GitHub): Experience using Git/GitHub for branching, pull requests, and code reviews; comfortable with basic CI/CD concepts.
• Familiarity with financial systems such as OneStream.
• Excellent problem-solving and communication skills with a high attention to detail.
• Ability to independently manage multiple priorities in a dynamic environment.
• Experience in Retail or Finance industries is a plus.

Pay Range:

We offer a comprehensive benefits package that may include medical, dental, vision, 401k matching, and more!

Following receipt of a conditional offer of employment, candidates will be required to complete additional job-related screening processes as permitted or required by applicable law .

We are an equal opportunity employer, and all applicants will be considered for employment without attention to their membership in any protected class. If you require any reasonable accommodation to complete your application or any part of the recruiting process, please email your request to [email protected], and please be sure to include the title and the location of the position for which you are applying.